|
| 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
October 5th, 2006, 09:21 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Parameter querie, is this possible ?
Hello,
currently the parameter is looking like this [Input department code:]. Input will be like "300" and It will then return the data belonging to this department. My question: Can I write so that I get between departments. By using something similar to this: "300..306" in the same input window and still get answares listing all the departments between those 2 input values ? Perag 
|
|
#2
October 5th, 2006, 10:15 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Parameter querie, is this possible ?
something like:
BETWEEN [enter dept 1] AND [enter dept 2] "Perag" wrote in message ... Hello, currently the parameter is looking like this [Input department code:]. Input will be like "300" and It will then return the data belonging to this department. My question: Can I write so that I get between departments. By using something similar to this: "300..306" in the same input window and still get answares listing all the departments between those 2 input values ? Perag
|
|
#3
October 5th, 2006, 11:00 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Parameter querie, is this possible ?
Sweet, thanks alot that worked!
Perag "David F Cox" wrote: something like: BETWEEN [enter dept 1] AND [enter dept 2] "Perag" wrote in message ... Hello, currently the parameter is looking like this [Input department code:]. Input will be like "300" and It will then return the data belonging to this department. My question: Can I write so that I get between departments. By using something similar to this: "300..306" in the same input window and still get answares listing all the departments between those 2 input values ? Perag
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
