If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query joins using and/or operators
I don't know if this is possible in Access - I can do it in Crystal but
haven't been able to figure out how in Access. I have two tables - one shows the number of a response card sent back to us (Survey_tbl). The other shows a range of response card numbers for a particular region (Kits_tbl). There is one field in the Survey_tbl with the response card number[KitNumber]. There are two fields in the Kits_tbl with the response card numbers assigned to a region [KitStartNumber] and [KitEndNumber]. I would like to be able to create a query joining the Survey_tbl to the Kits_tbl. In Crystal, i am able to create joins that link the [KitNumber] in the Survey_tbl to both the [KitStartNumber] and [KitEndNumber] in the Kits_tbl, with a = and = join type. Is there any way to do the same sort of thing in Access? |
Thread Tools | |
Display Modes | |
|
|