Hi Everybody!
I have a query that averages some costs, but if the item hasn't come in, the result in query.lastcost will be 0.
if it's 0, I need to get the result from another query for that item. How do I do this? ( I have the other query built already) Do I need to give more information? Thank you!!!
Jennifer
p.s. - this query result needs to be used by reports and other queries.....so i know that if it was a FORM i could do a DLookup to the other query, but how do I do this in a query and not in code????So confused.....
I have a query that averages some costs, but if the item hasn't come in, the result in query.lastcost will be 0.
if it's 0, I need to get the result from another query for that item. How do I do this? ( I have the other query built already) Do I need to give more information? Thank you!!!
Jennifer
p.s. - this query result needs to be used by reports and other queries.....so i know that if it was a FORM i could do a DLookup to the other query, but how do I do this in a query and not in code????So confused.....
Last edited: