jim may
Well-known Member
- Joined
- Jul 4, 2004
- Messages
- 7,486
I am not familiar enough with Access to walk through this...
But I have created a simple query in Design view. Under the field MovementDate on the criteria row I've entered:
Between [Enter Start Date:] And [Enter End Date:] and his works FINE!
Now, I want to create another query further to this one where I "add" the parameter to filter on a specific piece of equipment
shown in another field of the same query (field name) EquipmentName. I'd like to when I run this new query have a combobox appear first allowing the user to Choose (from the CB) the single piece of equipment he wants to filter on. Once he selects one from the CB then the Between prompt would show. The end result would provide this single piece of equipment with all the records with a movement between start and end.
I have been googling, and I find "How to Articles" that are 6 pages long. Can this be reduced by someone in the forum down to one page of instructions?
Thanks in advance. Jim
But I have created a simple query in Design view. Under the field MovementDate on the criteria row I've entered:
Between [Enter Start Date:] And [Enter End Date:] and his works FINE!
Now, I want to create another query further to this one where I "add" the parameter to filter on a specific piece of equipment
shown in another field of the same query (field name) EquipmentName. I'd like to when I run this new query have a combobox appear first allowing the user to Choose (from the CB) the single piece of equipment he wants to filter on. Once he selects one from the CB then the Between prompt would show. The end result would provide this single piece of equipment with all the records with a movement between start and end.
I have been googling, and I find "How to Articles" that are 6 pages long. Can this be reduced by someone in the forum down to one page of instructions?
Thanks in advance. Jim