Queries

PendulumMan
11-08-2000, 01:12 PM
Here we go again - Lets see if I can explain this correctly.
I have 1 query that is similar to this:
Select * from Table where Id = <<a choice made on a form>>
I am trying to use the Data Environment feature of VB6 and cant figure out how to create this query.
I also need to have another query that links to the results of this query - How do I create this second query using
the Data environment?

Thanks,
Derrick

dusteater
11-14-2000, 12:30 AM
Derrick,
I am not quite sure I know what you are trying to do. Do you want to find all the items in Table whos Id has not been set. If so <> will not work you will have to use null. Give me a little more info on what you are trying to do and I might be able to help you out. You probably could get away with one query using an "AND".
Rick

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum