gps
Last Activity: Apr 8 '07, 02:44 AM
Joined: Apr 7 '07
Location:
-
gps started a topic Dmax criteria to limit only NUMBERS pulled from field that also may contain ALPHAin AccessDmax criteria to limit only NUMBERS pulled from field that also may contain ALPHA
I'm trying to use Dmax to dip into a my invoice header table and pull the maxium invoice number out of it.
I'm running Access 2007 on Vista Business, but had the same prob with Access 2003 on XPP.
Here's a snapshot of the table data:
InvoiceID
79571
79572
ACCT
ACCT
CREDIT
79572
79573
Here's the code I'm using:
MaxInvoiceID = DMax("[InvoiceID]",...
No activity results to display
Leave a comment: