Date based query

[vt1]

Hi,
I am trying to write query based on date differences.
I want count of records where date difference is 1 day, 2 day and 4 days.

Please see attached for details and comment.


I don't want to import / export from access.

Thanks,

[Mordred]

Try using a filter. See here.

[vt1]

Thanks for response however I don;t want to take filter route. There are number of conditions and files will be huge. There are chances that user mat mistake while applying the filters hence I am thinking of some formulas which can provide count based on conditions.
Please comment.

[vt1]

Hi,
Please can you advice if date based queries can be achived from formulas / macros...
Thanks

[mike7952]

This what you want?

Please Login or Register  to view this content.