Reports with dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone.
I'm kinda stuck here.
How can i put a line on my header report with first date of all records and
last date of all records.
My reports are made from qrys but some are from crosstab qry with no date
field in it.
My field date is named [Data] (portuguese for date].
Tks in advance for all your help.
Pedro
 
Pedro said:
Hello everyone.
I'm kinda stuck here.
How can i put a line on my header report with first date of all
records and last date of all records.
My reports are made from qrys but some are from crosstab qry with no
date field in it.
My field date is named [Data] (portuguese for date].
Tks in advance for all your help.
Pedro
Click to expand...

In the Report Header or Footer you should be able to use...

=Min(DateField)
=Max(DateField)

....to get the first and last dates. Of course this works only if the underlying
query contains dates. If it doesn't you might be able to use DMin() and DMax()
pointed at the domain that the query without a date is based on (assuming that
domain has a date field).
 
Hi Rick
How about "telling" To read from the file [Tabela de Dados] and get me the
first date on a control and the last date on another.
I have qry that are crosstab from 4 crosstab. Don't know how to do it.
Will you help me please?
Tks in advance
Pedro

Rick Brandt said:
Pedro said:
Hello everyone.
I'm kinda stuck here.
How can i put a line on my header report with first date of all
records and last date of all records.
My reports are made from qrys but some are from crosstab qry with no
date field in it.
My field date is named [Data] (portuguese for date].
Tks in advance for all your help.
Pedro
Click to expand...

In the Report Header or Footer you should be able to use...

=Min(DateField)
=Max(DateField)

....to get the first and last dates. Of course this works only if the underlying
query contains dates. If it doesn't you might be able to use DMin() and DMax()
pointed at the domain that the query without a date is based on (assuming that
domain has a date field).
Click to expand...
 
Back
Top