 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Chat Forum
2
Posts
2
Users
0
Reactions
43
Views
Topic starter
if i have a query run on x date, how do i then run it again without the data from the previous query showing. My thinking is to run a parameter with a start and end date, is their another easier way?
Posted : 21/09/2018 12:08 pm
You could use BETWEEN [Start] And [End]
Or => [Start]
Depends if you want records between a date range or everything entered after a date.
I usually create a reporting switchboard (form) and put two date formatted unbound fields, in the query put the code in to look between the dates on the form, then on the form use a command button to run the query.
Posted : 21/09/2018 1:41 pm
Posted : 21/09/2018 1:51 pm