Viewing 3 posts - 1 through 3 (of 3 total)
  • MS access query help
  • iamanobody
    Free Member

    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?

    highpeakrider
    Free Member

    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.

    highpeakrider
    Free Member

    This is a great site for everything access

    https://www.access-programmers.co.uk/forums/

Viewing 3 posts - 1 through 3 (of 3 total)

The topic ‘MS access query help’ is closed to new replies.