Lookup values form Query to Table

[sreelalts]

Hi,

I have qiven an "IIF" condition in Query to identify the values based on todays date and its populating correctly.

I need those result either in 'Table' or 'Form' to do a Dsum function. ( I can do the "IIF" condition in 'Form' but which is not flowing to 'Table")

I'm not sure it is possible or not, but please help me to suggest a solution for that.


With Thanks
Sreelal T S

[zmbd]

sreelalts: There are many methods to do this; however, you're objective isn't really very clear.

If the query is running correctly, then you can use that query in an aggregate query to return your summation without resorting to the DSUM()

It would be helpful to see the actual SQL you are working with... cut and paste it here, format the SQL using the [CODE/] toolbar... please see the FAQ and the Access Forum Stickies for more guidance.