report problem

  • Thread starter Thread starter me
  • Start date Start date
M

me

I have a database with records where a "date" field might or might not list
consecutive dates.

I need to design a report where:

non consecutive dates print out, but consecutive dates print a range, i.e.

1/5/2004
1/7/2004
1/8/2004
1/9/2004
1/20/2004

report lists:
1/5/2004
1/7/2004 - 1/9/2004
1/20/2004

any suggestions? could be excel also.
 
me said:
I have a database with records where a "date" field might or might not list
consecutive dates.

I need to design a report where:

non consecutive dates print out, but consecutive dates print a range, i.e.

1/5/2004
1/7/2004
1/8/2004
1/9/2004
1/20/2004

report lists:
1/5/2004
1/7/2004 - 1/9/2004
1/20/2004
Click to expand...


The key to getting a report to do what you want is to first
get it's record source query to provide the needed data
records.

In this case you would need some tricky SQL to get the
ranges. You can start by looking at:
http://www.mvps.org/access/queries/qry0021.htm

and if you need further help with it, reformulate your
question to the context of the query and ask it in the
queries newsgroup where the SQL wizards hang out.
 
Back
Top