Need VB coding for Access Query - see sample

[Randy11]

qrySample 1 Fields "Name" & "Time"

qrySample 2 Fields "Name" & "Time"

Need VB code to create another query. Want to select "Name" from qrySample1 & "Time" from qrySample 2. qrySample 2 will be missing some names that are in qrySample 1. Want Null or 0 value to show for any that are not present in qrySample2.

 

[Frink]

Hallo,

Isn't this just a normal query with a different type of join? I thought the wizard guides you through making one of these.

- Frink

 

[PantoKing]

Hello,

Have a look at the QueryDef information in the Access help file. This shows you how to create a new query, or you could pass an SQL string to a recordset and retrieve the data like that.

Cheers,

Steve. Make things as simple as possible — but no simpler.