DMax with And condition
- From: "DavidS" <anon@xxxxxxxxxxxx>
- Date: Mon, 17 Apr 2006 21:29:08 -0400
I've tried every way possible to figure this one out.
ItemNo is a text value on the record.
GraphedID is a numeric long on the record.
I call this from a record in acontinuous subform,
looking for a max value from among that subform's records.
Dim LastLocation As Integer
LastLocation = DMax("[DefectLocation]", "tblDefectsGraphed",
"ItemNo = " & [ItemNo] & " And GraphedID > " & [GraphedID]")
Continue to get "Type mismatch in expression"
I've tried many combinations of quoting and combinig these
elements. Also tried several solutions I found in the Google
Groups, but no luck.
Any suggestions?
Thanks
Steve
.
- Follow-Ups:
- Re: DMax with And condition
- From: Steve
- Re: DMax with And condition
- Prev by Date: Re: Stored Procedure from Access
- Next by Date: Re: DMax with And condition
- Previous by thread: Stored Procedure from Access
- Next by thread: Re: DMax with And condition
- Index(es):