(Msg. 1) Posted: Thu Jul 24, 2008 1:04 pm
Post subject: Max Date Add to elertz Archived from groups: microsoft>public>access>reports (more info?)
I have a report showing Bid Information for various projects, including the
Field [Bid Date] which is formatted as Date/Time. In the footer of the report
I would like to show the most recent date from this field. I have tried to
use =max([Bid Date]) which returns #Error.
(Msg. 2) Posted: Thu Jul 24, 2008 1:52 pm
Post subject: RE: Max Date Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
try using Dmax (which stands for Date Max)
"Jeefgeorge" wrote:
> I have a report showing Bid Information for various projects, including the
> Field [Bid Date] which is formatted as Date/Time. In the footer of the report
> I would like to show the most recent date from this field. I have tried to
> use =max([Bid Date]) which returns #Error.
(Msg. 3) Posted: Thu Jul 24, 2008 2:05 pm
Post subject: RE: Max Date Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I used Dmax("[Bid Date]","Estimating Guide") works great....btw..Dmax stands
for Domain Max
"Golfinray" wrote:
> try using Dmax (which stands for Date Max)
>
> "Jeefgeorge" wrote:
>
> > I have a report showing Bid Information for various projects, including the
> > Field [Bid Date] which is formatted as Date/Time. In the footer of the report
> > I would like to show the most recent date from this field. I have tried to
> > use =max([Bid Date]) which returns #Error.
(Msg. 4) Posted: Thu Jul 24, 2008 2:11 pm
Post subject: Re: Max Date Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Thu, 24 Jul 2008 13:04:00 -0700, Jeefgeorge wrote:
> I have a report showing Bid Information for various projects, including the
> Field [Bid Date] which is formatted as Date/Time. In the footer of the report
> I would like to show the most recent date from this field. I have tried to
> use =max([Bid Date]) which returns #Error.
The Footer of the Report?
A report can have many Footers.
Do you mean the PAGE Footer?
You cannot use that expression in a report page footer.
Place that expression in the report Detail section. You can make it
Not Visible.
Then, in the page footer you can refer to that control.
=[NameOfControlInDetail]
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
(Msg. 5) Posted: Thu Jul 24, 2008 2:37 pm
Post subject: Re: Max Date Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Thu, 24 Jul 2008 14:05:02 -0700, Jeefgeorge wrote:
> I used Dmax("[Bid Date]","Estimating Guide") works great....btw..Dmax stands
> for Domain Max
> "Golfinray" wrote:
>
>> try using Dmax (which stands for Date Max)
>>
>> "Jeefgeorge" wrote:
>>
>>> I have a report showing Bid Information for various projects, including the
>>> Field [Bid Date] which is formatted as Date/Time. In the footer of the report
>>> I would like to show the most recent date from this field. I have tried to
>>> use =max([Bid Date]) which returns #Error.
The problem with your using DMax (as written) is that it is checking
for the maximum date in the table, which may or may not be the maximum
date shown in the report, i.e. if you have filtered the report, the
maximum date in the report may be different than that in the table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other