Last Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 15 May 2007 19:28 GMT

I'm trying to find the last Date a transaction occured for a particular
customer and the DMax doesn't seem to be working. Should I be using
something else?

Forms!Form6!Text2 = DMax("ChkDate", "tblChecks", "ChkCustomerID = " &
Forms!Form6!Text0)

Thnaks
DS

Reply to this Message

Maurice - 15 May 2007 20:57 GMT

Why not create a regular query sorted by Date descending and try that
instead. You could use a Dlookup for that. Try something like:

Forms!Form6!Text2 = DLookup("ChkDate", "YourQuery", "ChkCustomerID = " &
Forms!Form6!Text0) - where yourquery references the query you made.

Maurice

> I'm trying to find the last Date a transaction occured for a particular
> customer and the DMax doesn't seem to be working. Should I be using
[quoted text clipped - 5 lines]
> Thnaks
> DS

Reply to this Message

Ofer Cohen - 15 May 2007 21:31 GMT

It should work, what do you get?

If the ChkCustomerID field is text then try
Forms!Form6!Text2 = DMax("ChkDate", "tblChecks", "ChkCustomerID = '" &
Forms!Form6![Text0] & "'")

Make sure that the name of the text box spelled correctly

Signature

Good Luck
BS"D

> I'm trying to find the last Date a transaction occured for a particular
> customer and the DMax doesn't seem to be working. Should I be using
[quoted text clipped - 5 lines]
> Thnaks
> DS

Reply to this Message

DS - 16 May 2007 15:45 GMT

It works! Now, for whatever reason!
DS
DS

> It should work, what do you get?
>
[quoted text clipped - 13 lines]
>> Thnaks
>> DS

Reply to this Message