"Between" in expression builder

[Ben6550]

Hi,

I want to produce an auto key macro that filters for data between two dates by prompting the uset to enter the dates. I cannot use the "between" function in the expression builder. Is there a way i get around this?

 

[SteveR77]

You will need to create a query with the date field you wish to search on having its criteria as Between [Start Date] And [End Date]

Then create your macro doing the assignment of the key stroke that you wish such as {F11} for the F11 key.

Assign the action to be OpenQuery and set the query name to the query that you created.

Save the macro as AutoKeys and that should give you what you are looking for.


Steve