Quick DLookUp question

[snipe]

I know that I can use DLookUp to find an order number (SO_DOC_NUM) from our sales table (SALES_SO) for a specific customer code on a specific day. What if there are multiple tickets for that customer on that day. How can I pull the first one written that day? SO_DOC_NUM is a number field and they are sequential.

[amrut]

SO_DOC_NUM is a number field and they are sequential

To retrieve the first one on that day, first you need to find the minimum of SO_DOC_NUM on a particular date and then use it in your criteria for dlookup.
Like DLookup("LookupField","TableName","[SO_DOC_NUM]=" & DMin("SO_DOC_NUM","TableName","[DateField]=#" & [SpecificDate] & "# AND [CustomerCode]=" & [SelectedCustomer])
Does it helps ?

[snipe]

Ah that makes sense. Haven't tried the DMin function yet. I'll give it a try when I get back to my desk. Appreciate it!

[snipe]

So that worked. Except I forgot about something. I'm not sure if this is possible with out building a bunch of other queries.

SALES_SO is linked to a table called SALES_SO_LN

SALES_SO has the customers info, the sales number, and the comments. SALES_SO_LN shows all of the items that the customer bought. The 2 tables are linked by the field SO_DOC_NUM.

Back my original question:

I want to pull the first ticket written of the designated day, for the designated customer, where there is a certain SKU in the SALES_SO_LN table.

For example:

Jim has 3 tickets (1,4,5) on 2/17/14 and 1 ticket (3) on 2/18/14. Tickets 4 and 5 from 2/17 and ticket 3 from 2/18 have the extended warranty SKU on them, but ticket 1 from 2/17 does NOT. I want my expression to find the first ticket written on 2/17 that has the extended warranty SKU, which would be ticket 4 from 2/17.

Make sense?

[snipe]

BTW, I am aware that I can do all of this with queries and no special functions (such as DMin and DLookUp) but even looking at a 1 week period, it goes SO slow. Like 10-15 minutes.

[snipe]

Actually scratch this thread. I figured out a smoother way of doing via another table I have access to.

Sorry for wasting anyone's time!