DMax function

[Revned]

hi,

i just want to know how and where to write the DMax function?

i have this table

TblInvoice
InvoiceID
InvoiceNumber
InvoiceDate
CustomerID

TblInvoiceDetail
InvoiceDetailID
InvoiceID
ItemID
Quantity
ItemPrice

i used this table for the purpose of controlling customer order using
invoice number
so that by filtering invoice number i can view in reports what are those
products are ordered by the customer

sorry guys but im not an access expert but anyway

thanks for any help, i am using access 2003

 

[Jeff Boyce]

So, what do you want the DMax() function to do for you?

Regards

Jeff Boyce
Microsoft Office/Access MVP