George Nicholson said:WHERE [MyFieldName] In(5, 7, 25, 30, 33, 99)
dg said:Hi George, I am currently not getting the results. I have a parameter where
I "enter a staring record number" and "enter ending record number". Can the
parameter be design to prompt the user to enter many records number in any
sequences?
George Nicholson said:WHERE [MyFieldName] In(5, 7, 25, 30, 33, 99)
--
George Nicholson
Remove 'Junk' from return address.
dg said:How would I create a query utilizing parameters to produce records not in
sequence? For example, query a table with 100 records, I would like the
information form record 5, 7, 25, 30, 33, and 99 to appear.
Edward G said:dg
One thing you might try in the criteria row of the record number field is
[Enter a record#] Or [Enter a record#] Or [Enter a record#]
I tried this and it worked once (at least it worked once when there were
only two repetitions).
And then I couldn't get it to work again for anything. I had a similar
problem the other day with
a pair of Iif statements joined by AND. I would love to hear from anyone who
can offer an
explanation as to why a computer would produce different results for
identical actions. I recently upgraded
the memory on this machine. Could that be causing this sort of anomaly?
Anybody?
Ed
notdg said:Hi George, I am currently not getting the results. I have a parameter where
I "enter a staring record number" and "enter ending record number". Can the
parameter be design to prompt the user to enter many records number in any
sequences?
George Nicholson said:WHERE [MyFieldName] In(5, 7, 25, 30, 33, 99)
--
George Nicholson
Remove 'Junk' from return address.
How would I create a query utilizing parameters to produce records
Edward G said:dg
Okay, learned something about parameters today. You can't enter the same
text in successive parameters. [Enter a record#] Or [Enter a record#] Or
[Enter a record#] will not work. Access will only display the Enter
Parameter Value form once in this instance.
So, what will work would be [Enter a record#] Or [Enter another record#] Or
[Enter yet another record#] etc, etc.
Edward G said:dg
One thing you might try in the criteria row of the record number field is
[Enter a record#] Or [Enter a record#] Or [Enter a record#]
I tried this and it worked once (at least it worked once when there were
only two repetitions).
And then I couldn't get it to work again for anything. I had a similar
problem the other day with
a pair of Iif statements joined by AND. I would love to hear from anyone who
can offer an
explanation as to why a computer would produce different results for
identical actions. I recently upgraded
the memory on this machine. Could that be causing this sort of anomaly?
Anybody?
Ed
notdg said:Hi George, I am currently not getting the results. I have a parameter where
I "enter a staring record number" and "enter ending record number". Can the
parameter be design to prompt the user to enter many records number in any
sequences?
:
WHERE [MyFieldName] In(5, 7, 25, 30, 33, 99)
--
George Nicholson
Remove 'Junk' from return address.
How would I create a query utilizing parameters to produce recordsin
sequence? For example, query a table with 100 records, I would like the
information form record 5, 7, 25, 30, 33, and 99 to appear.