Obtain records using parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
Click to expand...
 
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






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.
Click to expand...
Click to expand...
Click to expand...
 
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






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.


How would I create a query utilizing parameters to produce records
Click to expand...
Click to expand...
not
in
Click to expand...
Click to expand...
 
Thank you

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






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?


:

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
Click to expand...
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top