DMin in textBox problem

  • Thread starter Thread starter gator
  • Start date Start date
G

gator

I'm just trying to get the earliest Date from a query and nothing I do is
getting it.

This is as close as I can get to what I want...
=(Format(DMin("TranDate","mmmm yyyy")),"Transactions200902DetailQuery")

can someone help me get the right syntax?
 
gator said:
I'm just trying to get the earliest Date from a query and nothing I do is
getting it.

This is as close as I can get to what I want...
=(Format(DMin("TranDate","mmmm yyyy")),"Transactions200902DetailQuery")

can someone help me get the right syntax?
Click to expand...


=Format(DMin("TranDate","Transactions200902DetailQuery"),"mmmm
yyyy")

If that query is used as the report's record source, it
should be easier to use the Min function:
=Min(TranDate)

Either way, put the mmmm yyyy in the text box's Format
property instead of using the Format function.
 
it's telling me invalid syntax for the following...
=Format(DMin("TranDate","Transactions200902DetailQuery"),"mmmm yyyy")
 
gator said:
it's telling me invalid syntax for the following...
=Format(DMin("TranDate","Transactions200902DetailQuery"),"mmmm yyyy")
Click to expand...


I don't see a syntax error in there. Do you have any other
clues?

Are you sure the error is coming from that text box?
 
I am basing the report on Query2 which is a Totals query from Query1.
TranDate is a field in Query1 but not Query2(which is what the report is on).
So there is no TranDate field directly tied to the Report. But, I'm still
getting the syntax error....something about maybe an operand without an
operator?
 
Back
Top