DLookUp Question

[David the CFO]

Hi guys, my name is David





Need help with following matter:

I have a table (Query) of "Purchases" with some columns of "Purchase ID", "Purchase Date", "Purchased Material", "Amount", "Unit Price".

In another table (Query) of Material Expenditures with some columns of "Expenditure ID", "Expenditure Date", "Material", "Unit Cost", I want to fill "Unit Cost" column with appropriate Unit Price (from Purchases), where the unit price is the latest for the "Expenditure Date". In short, if I'm using a material at a stated date, I wanna know unit cost of it as a latest purchase price for that date of material expenditure.


What I've done is that I successfully DLookUp-ed purchase price of the expansed material.

[orange]

Is Purchases a table or a query? Can you show a jpg of your current database (relationships window)?

Dlookup info

[David the CFO]

Both of them are queries.
Unfortunately i can't do that, guess the problem is linked to the website.

[orange]

Please describe the situation.
Can you save a PrintScreen to file? If you are working with vba, this would be a desktop application, I think.
Did you create the database?
Readers need more info in order to offer advice.

[June7]

Did you build query that joins the two tables on the date and material fields?