between dates

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,
I have a parameter query which has the criteria that
is "Between DateAdd("d",-2,[Type in the date]) And DateAdd
("d",4,[Type in the date])". It shows total 7 days in row
when I type in specific day.

Ex: if I type in 10/08/04 in pup-up box, it will show all
information from 10/06, 10/07/, 10/08, 10/09, 10/10,
10/11, 10/12.

I use that query to create a report which will show 7 days
in row. Every thing is fine. However, I would like the
dates (10/06, 10/07/, 10/08, 10/09, 10/10, 10/11, 10/12)
show at the report header or footer.

Please help me.

Thank you
Loi
 
Hi,
I have a parameter query which has the criteria that
is "Between DateAdd("d",-2,[Type in the date]) And DateAdd
("d",4,[Type in the date])". It shows total 7 days in row
when I type in specific day.

Ex: if I type in 10/08/04 in pup-up box, it will show all
information from 10/06, 10/07/, 10/08, 10/09, 10/10,
10/11, 10/12.

I use that query to create a report which will show 7 days
in row. Every thing is fine. However, I would like the
dates (10/06, 10/07/, 10/08, 10/09, 10/10, 10/11, 10/12)
show at the report header or footer.

Please help me.

Thank you
Loi
Click to expand...

In the Report Head, ad an unbound text control.
Set it's control source to:
=Format([[Type in the date]-2,"mm/dd") & ", " & Format([[Type in the
date]-1,"mm/dd") & ", " & Format([[Type in the date],"mm/dd") & ", " &
Format([[Type in the date]+1,"mm/dd") & ", " & etc....

The Text within the brackets must be identical to the bracketed text
in the query parameter.
 
Back
Top