Hi,

I have a make table query that joins two other queries and puts the resulting data into a new table. I'm calling the make table query using the DoCmd.OpenQuery syntax. However, when I look at the data in the table, it looks like it's running only one of the two queries and populating the table with only the information from the one query. It doesn't seem to be doing the join.

When I run the query from Access, it creates the table and works fine, but when I call it from VBA it's not working. I must be doing something wrong, just not sure what.

Thanks for any help you can provide.