Calculated field for distance - Cannot get DMax() to work.

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

Access 2000:

Distance: [tblRepairs].[RepairMileage] -
Dmax("tblRepairs.RepairMileage","tblRepairsQuery","tblRepairs.RepairMileage
< "
& [tblRepairs].[RepairMileage] )

Access complains " the expression contains invalid syntax"

Can anyone help?
TIA
Doug
 
Hi,


You probably have a NULL among the values under RepairMileage, so that the
third argument of DMax makes a string which, once trying to evaluate it, is
an invalid syntax... Try:


Distance: tblRepairs.RepairMileage -
Dmax("RepairMileage","tblRepairsQuery","RepairMileage
< " & Nz(RepairMileage, 0) )



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top