Display date ranges

[jackiefm]

I need to display date ranges for missing data in a query in the following manner:

1/1/08-1/15/08, 126/08, 1/28/08-2/5/08, etc.

as opposed to

1/1/08
1/2/08
1/3/08
etc.

is there a way to do that in access?

[MindBender77]

I need to display date ranges for missing data in a query in the following manner:

1/1/08-1/15/08, 126/08, 1/28/08-2/5/08, etc.

as opposed to

1/1/08
1/2/08
1/3/08
etc.

is there a way to do that in access?

Take a look at this thread it might help.
Bender

http://www.thescripts.com/forum/thread779016.html