Combining data from two or more dlookups

[mahmud1180]

Hey, I am very new to the access VBA. I need to add up the data from three or four queries to make a table in access or excel. Instead of using SQL select queries I found DLookup more convenient. But I dont actually know how to combine the result from two different dlookups and how to get the combined result. Any help?

[JoeM]

Try to avoid using DLOOKUP when possible. They can be unreliable, inefficient, and only work for one-to-one matches.
I would recommend SQL over DLOOKUP, whenever possible.

[ranman256]

ALWAYS use querys. Not dlookup.

[mahmud1180]

Thank you for your replies. For select queries I cant execute.. runSQL. I guess I need to store the result in a recordset. Like this one


Dim rs As DAO.Recordset
Query2 = "SELECT Futures.Date, Futures.PX_SETTLE FROM Futures WHERE (((Futures.Date)>#1/1/2014#));"
Set rs = CurrentDb.OpenRecordset(Query2)

I don't know how to see the recordset in access and also dont know how to combine three or four recordset. Any Idea?

THanks

[ranman256]

Dont run queries in recordset code.
Create them in the query designer list.

Combine multiple queries in a UNION query.

[mahmud1180]

I would like to run them in UNION query but the only problem is that in VBA I cant run that directly esp the SELECT queries. Could you please tell how to do that in VBA?

THanks

[ranman256]

How is that possible? Access is made to query. Thats is prime function.

It does no good to make select queries in code, you cant display them.