Search results

Yes, I am pulling the same fields each time, but requesting different zipcodes. however, i am selecting multiple zipcodes. for example, chicago is subdivided into 8 parts. for north chicago, i: Select tblCustomer.* From tblCustomer Where ZipCode = 89089 OR 23432 OR 95435 OR 45425 OR 45243 OR...

thank you for the suggestion. However, I am uncertain that this is the best way to achieve my goal. I have 300+ queries which each select specific non-dynamic data from a single table depending on a zipcode. In addition to the criteria in these queries, i also need to execute a query on the...

do any of you have any examples of using multiple queries for a single report? basically i want to execute a query on a query. then excecute another query on that result set. any examples? oh yes, im using access and vb6. thx

Perfect Pat Hartman. Your suggestion works nicely. I also find great value in your comment about writing the positive first. Thank You.

SELECT tblCustomer.cResort, tblCustomer.cUnit, tblCustomer.cWeek, tblCustomer.cLName, tblCustomer.cFName, tblCustomer.cAddress, tblCustomer.cCity, tblCustomer.cState, tblCustomer.cZipCode, tblCustomer.cAreaCode, tblCustomer.cPhoneNum, tblCustomer.cYear FROM tblCustomer WHERE...

perhaps i need a nest query?

hi. my name is tim. im having some problems with a query that I am writing. it should be rather simple and involves only one table. the table is called tblCustomer. The query involves 2 fields: cResort and cWeek. Neither of these fields are unique. Together they make up the primary key...