Hello again to everyone!
I've taken off like a rocket with this database, and there's no stopping me! That is, if you guys give your usual support...
I need to make my report. I call it "The Rute" because it should be made up of all the customers that have a service due for the current month in a given city, so I know who to visit. So I need a single report for every city I choose to print. But the thing is, I need to figure out how to structure the report so I know what queries to make.
The idea I have is the following, please correct me:
Make a report using qryActiveCustomers with a subform using tblAddress to show the address for each active customer and a sub-subform for the inventory of that particular address. The thing is, the tblInventory is the one that has the service due date in the field "NxtServDate". How would I filter it so I only get, for example all the customers in the city of San Juan with a next service date of July? The parent form would have to be filtered by the grandchild form, is this posible? If so, How?
I'm thinking of using a user input in the qryActiveCustomer to ask for the City name...
Tidak ada komentar:
Posting Komentar