Multiple Record Query

[Guest]

I have a column in my table called Record #. I need to perform queries on a
regular basis which include specific Record #'s. So I may need to select
over 200 specific record numbers in a query. This is turning into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111 Or 12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record #])=1291 Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or ([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or ([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or ([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or ([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or ([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or ([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or ([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or ([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or ([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or ([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or ([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or ([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or ([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or ([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or ([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or ([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or ([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or ([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or ([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or ([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or ([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or ([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or ([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or ([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or ([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or ([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or ([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought about
creating a new column in my table called TEMP and making it a Yes/No field
and checking the fields of the records I need and doing the query that way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Tom Ellison]

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would doubtless find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how many?
How is this list delivered to you? Do you get it in an email or other
electronic document? Is it just hand-written? This may factor into what is
a good answer to the question.

A possibility is to have a temporary table of these numbers, perhaps with a
key to having multiple sets of them. If re-usability is an issue, this
would be excellent. You could "keep" the list and use it again later to
requery the same set. If the set comes to you in any electronic form, this
would also be useful. The query would eliminate any reference to a literal
list of Record #s, and just JOIN to the table with the list desired.

Your proposed solution is workable, but I'm not sure it would be optimal.
It would also definitely be a "single user" solution, since the checks are
recorded in one list. Two users creating two distinct lists simultaneously
would interfere with one another.

Tom Ellison

I have a column in my table called Record #. I need to perform queries on
a
regular basis which include specific Record #'s. So I may need to select
over 200 specific record numbers in a query. This is turning into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111 Or 12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record #])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or ([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or ([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or ([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or ([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or ([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or ([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or ([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or ([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or ([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or ([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or ([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or ([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or ([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or ([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or ([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or ([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or ([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or ([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or ([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or ([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or ([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or ([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or ([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or ([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or ([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or ([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or ([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought about
creating a new column in my table called TEMP and making it a Yes/No field
and checking the fields of the records I need and doing the query that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Duane Hookom]

That's truly "ugly". Consider creating a two field table

tblQueryRecords
QryCode RecordNum
A 1404
A 1289
A 125
.....
B 123
B 1400
B 2312

Now join this table to your [Gift Cards] table in your query on [Record #]
and [RecordNum]. Set the criteria under QryCode to "A" to get all the
records for "A".

This allows you to maintain your list of records and create multiple subsets
of the records.

--
Duane Hookom
MS Access MVP
--

I have a column in my table called Record #. I need to perform queries on
a
regular basis which include specific Record #'s. So I may need to select
over 200 specific record numbers in a query. This is turning into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111 Or 12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record #])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or ([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or ([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or ([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or ([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or ([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or ([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or ([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or ([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or ([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or ([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or ([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or ([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or ([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or ([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or ([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or ([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or ([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or ([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or ([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or ([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or ([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or ([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or ([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or ([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or ([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or ([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or ([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought about
creating a new column in my table called TEMP and making it a Yes/No field
and checking the fields of the records I need and doing the query that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Guest]

Hi Tom. Right now my DB has over 1500 records but this number will grow. I
can manage using the IN method with the record numbers separated by commas,
but is there a maximum? When using the nightmare OR method, there was a
limit. The list is delivered to me via e-mail and I can easily convert it to
comma separated and paste it into the SQL query window. Is there a way to
accomplish this in design view rather than going into SQL View?

Yes, re-usability is the issue and your solution seems workable. I just
need exact syntax because I'm really not an expert. I get by with a little
help from my friends!

Thanks Tom. I'll play around but I'll wait to hear back from you.

Christine

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would doubtless find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how many?
How is this list delivered to you? Do you get it in an email or other
electronic document? Is it just hand-written? This may factor into what is
a good answer to the question.

A possibility is to have a temporary table of these numbers, perhaps with a
key to having multiple sets of them. If re-usability is an issue, this
would be excellent. You could "keep" the list and use it again later to
requery the same set. If the set comes to you in any electronic form, this
would also be useful. The query would eliminate any reference to a literal
list of Record #s, and just JOIN to the table with the list desired.

Your proposed solution is workable, but I'm not sure it would be optimal.
It would also definitely be a "single user" solution, since the checks are
recorded in one list. Two users creating two distinct lists simultaneously
would interfere with one another.

Tom Ellison

I have a column in my table called Record #. I need to perform queries on
a
regular basis which include specific Record #'s. So I may need to select
over 200 specific record numbers in a query. This is turning into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111 Or 12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record #])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or ([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or ([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or ([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or ([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or ([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or ([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or ([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or ([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or ([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or ([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or ([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or ([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or ([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or ([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or ([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or ([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or ([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or ([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or ([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or ([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or ([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or ([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or ([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or ([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or ([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or ([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or ([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought about
creating a new column in my table called TEMP and making it a Yes/No field
and checking the fields of the records I need and doing the query that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Guest]

Hey - it worked PERFECTLY in SQL View so no need to go any further. I'm so
thrilled that this works and so grateful for your help! Thanks to all who
responded!

Cheers,
Christine

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would doubtless find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how many?
How is this list delivered to you? Do you get it in an email or other
electronic document? Is it just hand-written? This may factor into what is
a good answer to the question.

A possibility is to have a temporary table of these numbers, perhaps with a
key to having multiple sets of them. If re-usability is an issue, this
would be excellent. You could "keep" the list and use it again later to
requery the same set. If the set comes to you in any electronic form, this
would also be useful. The query would eliminate any reference to a literal
list of Record #s, and just JOIN to the table with the list desired.

Your proposed solution is workable, but I'm not sure it would be optimal.
It would also definitely be a "single user" solution, since the checks are
recorded in one list. Two users creating two distinct lists simultaneously
would interfere with one another.

Tom Ellison

I have a column in my table called Record #. I need to perform queries on
a
regular basis which include specific Record #'s. So I may need to select
over 200 specific record numbers in a query. This is turning into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111 Or 12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record #])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or ([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or ([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or ([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or ([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or ([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or ([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or ([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or ([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or ([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or ([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or ([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or ([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or ([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or ([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or ([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or ([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or ([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or ([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or ([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or ([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or ([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or ([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or ([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or ([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or ([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or ([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or ([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought about
creating a new column in my table called TEMP and making it a Yes/No field
and checking the fields of the records I need and doing the query that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Tom Ellison]

Dear Christine:

Well, you're welcome. Thanks for gushing! It really does make me feel
good. I believe I know how you feel.

Tom Ellison

Hey - it worked PERFECTLY in SQL View so no need to go any further. I'm
so
thrilled that this works and so grateful for your help! Thanks to all who
responded!

Cheers,
Christine

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would doubtless
find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how many?
How is this list delivered to you? Do you get it in an email or other
electronic document? Is it just hand-written? This may factor into what
is
a good answer to the question.

A possibility is to have a temporary table of these numbers, perhaps with
a
key to having multiple sets of them. If re-usability is an issue, this
would be excellent. You could "keep" the list and use it again later to
requery the same set. If the set comes to you in any electronic form,
this
would also be useful. The query would eliminate any reference to a
literal
list of Record #s, and just JOIN to the table with the list desired.

Your proposed solution is workable, but I'm not sure it would be optimal.
It would also definitely be a "single user" solution, since the checks
are
recorded in one list. Two users creating two distinct lists
simultaneously
would interfere with one another.

Tom Ellison


message

I have a column in my table called Record #. I need to perform queries
on
a
regular basis which include specific Record #'s. So I may need to
select
over 200 specific record numbers in a query. This is turning into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111 Or
12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record
#])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or
([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or ([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or ([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or ([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or ([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or ([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or ([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or ([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or ([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or ([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or ([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or ([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or ([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or ([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or ([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or ([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or ([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or ([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or ([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or ([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or ([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or ([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or ([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or ([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or ([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or ([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or ([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought about
creating a new column in my table called TEMP and making it a Yes/No
field
and checking the fields of the records I need and doing the query that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Guest]

I know. When someone gives you a simple solution to something I spent an
hour typing in manually (and I did!!!) it is exhilarating! You deserve the
gush!

Can I ask another question? OK, so I've got this query. I have a QTY
column and I want to reduce each number in the QTY column by one...so if the
QTY column is 6 I would want it to be 5, etc. Is there a simple way to do
that?

Dear Christine:

Well, you're welcome. Thanks for gushing! It really does make me feel
good. I believe I know how you feel.

Tom Ellison

Hey - it worked PERFECTLY in SQL View so no need to go any further. I'm
so
thrilled that this works and so grateful for your help! Thanks to all who
responded!

Cheers,
Christine

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would doubtless
find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how many?
How is this list delivered to you? Do you get it in an email or other
electronic document? Is it just hand-written? This may factor into what
is
a good answer to the question.

A possibility is to have a temporary table of these numbers, perhaps with
a
key to having multiple sets of them. If re-usability is an issue, this
would be excellent. You could "keep" the list and use it again later to
requery the same set. If the set comes to you in any electronic form,
this
would also be useful. The query would eliminate any reference to a
literal
list of Record #s, and just JOIN to the table with the list desired.

Your proposed solution is workable, but I'm not sure it would be optimal.
It would also definitely be a "single user" solution, since the checks
are
recorded in one list. Two users creating two distinct lists
simultaneously
would interfere with one another.

Tom Ellison


message
I have a column in my table called Record #. I need to perform queries
on
a
regular basis which include specific Record #'s. So I may need to
select
over 200 specific record numbers in a query. This is turning into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111 Or
12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record
#])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or
([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or ([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or ([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or ([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or ([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or ([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or ([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or ([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or ([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or ([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or ([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or ([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or ([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or ([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or ([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or ([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or ([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or ([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or ([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or ([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or ([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or ([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or ([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or ([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or ([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or ([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or ([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought about
creating a new column in my table called TEMP and making it a Yes/No
field
and checking the fields of the records I need and doing the query that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Tom Ellison]

Dear Christine:

First, backup the stuff. If you go making wholesale changes to the data and
anything goes wrong, you'll be awfully glad to have had a backup.

Perhaps something like this:

UPDATE YourTable
SET QTY = QTY - 1

Check the table name and column name I used to illustrate this. Put in the
real names.

You can add criteria to this so it doesn't reduce the quantity by 1 where
the quantity is already 0, for example.

Tom Ellison

I know. When someone gives you a simple solution to something I spent an
hour typing in manually (and I did!!!) it is exhilarating! You deserve
the
gush!

Can I ask another question? OK, so I've got this query. I have a QTY
column and I want to reduce each number in the QTY column by one...so if
the
QTY column is 6 I would want it to be 5, etc. Is there a simple way to do
that?

Dear Christine:

Well, you're welcome. Thanks for gushing! It really does make me feel
good. I believe I know how you feel.

Tom Ellison


message

Hey - it worked PERFECTLY in SQL View so no need to go any further.
I'm
so
thrilled that this works and so grateful for your help! Thanks to all
who
responded!

Cheers,
Christine

:

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would doubtless
find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how
many?
How is this list delivered to you? Do you get it in an email or other
electronic document? Is it just hand-written? This may factor into
what
is
a good answer to the question.

A possibility is to have a temporary table of these numbers, perhaps
with
a
key to having multiple sets of them. If re-usability is an issue,
this
would be excellent. You could "keep" the list and use it again later
to
requery the same set. If the set comes to you in any electronic form,
this
would also be useful. The query would eliminate any reference to a
literal
list of Record #s, and just JOIN to the table with the list desired.

Your proposed solution is workable, but I'm not sure it would be
optimal.
It would also definitely be a "single user" solution, since the checks
are
recorded in one list. Two users creating two distinct lists
simultaneously
would interfere with one another.

Tom Ellison


message
I have a column in my table called Record #. I need to perform
queries
on
a
regular basis which include specific Record #'s. So I may need to
select
over 200 specific record numbers in a query. This is turning into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111 Or
12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record
#])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or
([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or ([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or ([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or ([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or ([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or ([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or ([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or ([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or ([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or ([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or ([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or ([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or ([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or ([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or ([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or ([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or ([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or ([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or ([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or ([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or ([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or ([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or ([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or ([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or ([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or ([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or ([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought
about
creating a new column in my table called TEMP and making it a Yes/No
field
and checking the fields of the records I need and doing the query
that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Guest]

Can I do it on a query instead of the table? Like:

UPDATE QueryName
SET QTY = QTY - 1

And if so, how do I run this command? In the SQL window?

Dear Christine:

First, backup the stuff. If you go making wholesale changes to the data and
anything goes wrong, you'll be awfully glad to have had a backup.

Perhaps something like this:

UPDATE YourTable
SET QTY = QTY - 1

Check the table name and column name I used to illustrate this. Put in the
real names.

You can add criteria to this so it doesn't reduce the quantity by 1 where
the quantity is already 0, for example.

Tom Ellison

I know. When someone gives you a simple solution to something I spent an
hour typing in manually (and I did!!!) it is exhilarating! You deserve
the
gush!

Can I ask another question? OK, so I've got this query. I have a QTY
column and I want to reduce each number in the QTY column by one...so if
the
QTY column is 6 I would want it to be 5, etc. Is there a simple way to do
that?

Dear Christine:

Well, you're welcome. Thanks for gushing! It really does make me feel
good. I believe I know how you feel.

Tom Ellison


message
Hey - it worked PERFECTLY in SQL View so no need to go any further.
I'm
so
thrilled that this works and so grateful for your help! Thanks to all
who
responded!

Cheers,
Christine

:

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would doubtless
find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how
many?
How is this list delivered to you? Do you get it in an email or other
electronic document? Is it just hand-written? This may factor into
what
is
a good answer to the question.

A possibility is to have a temporary table of these numbers, perhaps
with
a
key to having multiple sets of them. If re-usability is an issue,
this
would be excellent. You could "keep" the list and use it again later
to
requery the same set. If the set comes to you in any electronic form,
this
would also be useful. The query would eliminate any reference to a
literal
list of Record #s, and just JOIN to the table with the list desired.

Your proposed solution is workable, but I'm not sure it would be
optimal.
It would also definitely be a "single user" solution, since the checks
are
recorded in one list. Two users creating two distinct lists
simultaneously
would interfere with one another.

Tom Ellison


message
I have a column in my table called Record #. I need to perform
queries
on
a
regular basis which include specific Record #'s. So I may need to
select
over 200 specific record numbers in a query. This is turning into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111 Or
12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record
#])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or
([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or ([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or ([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or ([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or ([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or ([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or ([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or ([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or ([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or ([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or ([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or ([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or ([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or ([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or ([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or ([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or ([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or ([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or ([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or ([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or ([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or ([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or ([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or ([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or ([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or ([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or ([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought
about
creating a new column in my table called TEMP and making it a Yes/No
field
and checking the fields of the records I need and doing the query
that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Tom Ellison]

Dear Christine:

I'm not sure what Access would do. The query would certainly have to be
updatable or I'm sure it would not.

There is a table where this data exists, right? Are you wanting to update
only some of the rows in that table, which are already filtered in the
query? Perhaps you could filter the update query similarly and achieve the
result.

I've never run into a situation where I wanted to do an UPDATE through a
query. Now that you mention it, it seems possible this might come up under
certain circumstances. Sorry to plead ignorance. Make the backup and try
it, I guess. Nothing to lose!

Tom Ellison

Can I do it on a query instead of the table? Like:

UPDATE QueryName
SET QTY = QTY - 1

And if so, how do I run this command? In the SQL window?

Dear Christine:

First, backup the stuff. If you go making wholesale changes to the data
and
anything goes wrong, you'll be awfully glad to have had a backup.

Perhaps something like this:

UPDATE YourTable
SET QTY = QTY - 1

Check the table name and column name I used to illustrate this. Put in
the
real names.

You can add criteria to this so it doesn't reduce the quantity by 1 where
the quantity is already 0, for example.

Tom Ellison


message

I know. When someone gives you a simple solution to something I spent
an
hour typing in manually (and I did!!!) it is exhilarating! You deserve
the
gush!

Can I ask another question? OK, so I've got this query. I have a QTY
column and I want to reduce each number in the QTY column by one...so
if
the
QTY column is 6 I would want it to be 5, etc. Is there a simple way to
do
that?


:

Dear Christine:

Well, you're welcome. Thanks for gushing! It really does make me
feel
good. I believe I know how you feel.

Tom Ellison


message
Hey - it worked PERFECTLY in SQL View so no need to go any further.
I'm
so
thrilled that this works and so grateful for your help! Thanks to
all
who
responded!

Cheers,
Christine

:

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would
doubtless
find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how
many?
How is this list delivered to you? Do you get it in an email or
other
electronic document? Is it just hand-written? This may factor
into
what
is
a good answer to the question.

A possibility is to have a temporary table of these numbers,
perhaps
with
a
key to having multiple sets of them. If re-usability is an issue,
this
would be excellent. You could "keep" the list and use it again
later
to
requery the same set. If the set comes to you in any electronic
form,
this
would also be useful. The query would eliminate any reference to a
literal
list of Record #s, and just JOIN to the table with the list
desired.

Your proposed solution is workable, but I'm not sure it would be
optimal.
It would also definitely be a "single user" solution, since the
checks
are
recorded in one list. Two users creating two distinct lists
simultaneously
would interfere with one another.

Tom Ellison


message
I have a column in my table called Record #. I need to perform
queries
on
a
regular basis which include specific Record #'s. So I may need
to
select
over 200 specific record numbers in a query. This is turning
into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111
Or
12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record
#])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or
([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or
([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or
([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or
([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or
([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or
([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or
([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or
([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or
([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or
([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or
([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or
([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or
([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or
([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or
([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or
([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or
([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or
([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or
([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or
([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or
([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or
([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or
([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or
([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or
([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or
([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or
([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought
about
creating a new column in my table called TEMP and making it a
Yes/No
field
and checking the fields of the records I need and doing the query
that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Guest]

Yes, there is a table, but I only want to update the records in the query. I
will give it a try and let you know the results. Backup first! Thanks Tom

Dear Christine:

I'm not sure what Access would do. The query would certainly have to be
updatable or I'm sure it would not.

There is a table where this data exists, right? Are you wanting to update
only some of the rows in that table, which are already filtered in the
query? Perhaps you could filter the update query similarly and achieve the
result.

I've never run into a situation where I wanted to do an UPDATE through a
query. Now that you mention it, it seems possible this might come up under
certain circumstances. Sorry to plead ignorance. Make the backup and try
it, I guess. Nothing to lose!

Tom Ellison

Can I do it on a query instead of the table? Like:

UPDATE QueryName
SET QTY = QTY - 1

And if so, how do I run this command? In the SQL window?

Dear Christine:

First, backup the stuff. If you go making wholesale changes to the data
and
anything goes wrong, you'll be awfully glad to have had a backup.

Perhaps something like this:

UPDATE YourTable
SET QTY = QTY - 1

Check the table name and column name I used to illustrate this. Put in
the
real names.

You can add criteria to this so it doesn't reduce the quantity by 1 where
the quantity is already 0, for example.

Tom Ellison


message
I know. When someone gives you a simple solution to something I spent
an
hour typing in manually (and I did!!!) it is exhilarating! You deserve
the
gush!

Can I ask another question? OK, so I've got this query. I have a QTY
column and I want to reduce each number in the QTY column by one...so
if
the
QTY column is 6 I would want it to be 5, etc. Is there a simple way to
do
that?


:

Dear Christine:

Well, you're welcome. Thanks for gushing! It really does make me
feel
good. I believe I know how you feel.

Tom Ellison


message
Hey - it worked PERFECTLY in SQL View so no need to go any further.
I'm
so
thrilled that this works and so grateful for your help! Thanks to
all
who
responded!

Cheers,
Christine

:

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would
doubtless
find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how
many?
How is this list delivered to you? Do you get it in an email or
other
electronic document? Is it just hand-written? This may factor
into
what
is
a good answer to the question.

A possibility is to have a temporary table of these numbers,
perhaps
with
a
key to having multiple sets of them. If re-usability is an issue,
this
would be excellent. You could "keep" the list and use it again
later
to
requery the same set. If the set comes to you in any electronic
form,
this
would also be useful. The query would eliminate any reference to a
literal
list of Record #s, and just JOIN to the table with the list
desired.

Your proposed solution is workable, but I'm not sure it would be
optimal.
It would also definitely be a "single user" solution, since the
checks
are
recorded in one list. Two users creating two distinct lists
simultaneously
would interfere with one another.

Tom Ellison


message
I have a column in my table called Record #. I need to perform
queries
on
a
regular basis which include specific Record #'s. So I may need
to
select
over 200 specific record numbers in a query. This is turning
into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111
Or
12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record
#])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or
([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or
([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or
([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or
([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or
([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or
([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or
([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or
([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or
([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or
([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or
([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or
([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or
([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or
([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or
([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or
([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or
([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or
([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or
([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or
([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or
([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or
([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or
([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or
([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or
([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or
([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or
([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought
about
creating a new column in my table called TEMP and making it a
Yes/No
field
and checking the fields of the records I need and doing the query
that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Guest]

OK - I'm stuck. How do I execute it? When I go into the SQL View it already
has the query criteria. How do I add:

UPDATE QueryName
SET QTY = QTY - 1

It won't let me add it to the end of the query. I know, I'm dumb at this!
Is there a Query Analyzer like in SQL?

Yes, there is a table, but I only want to update the records in the query. I
will give it a try and let you know the results. Backup first! Thanks Tom

Dear Christine:

I'm not sure what Access would do. The query would certainly have to be
updatable or I'm sure it would not.

There is a table where this data exists, right? Are you wanting to update
only some of the rows in that table, which are already filtered in the
query? Perhaps you could filter the update query similarly and achieve the
result.

I've never run into a situation where I wanted to do an UPDATE through a
query. Now that you mention it, it seems possible this might come up under
certain circumstances. Sorry to plead ignorance. Make the backup and try
it, I guess. Nothing to lose!

Tom Ellison

Can I do it on a query instead of the table? Like:

UPDATE QueryName
SET QTY = QTY - 1

And if so, how do I run this command? In the SQL window?


:

Dear Christine:

First, backup the stuff. If you go making wholesale changes to the data
and
anything goes wrong, you'll be awfully glad to have had a backup.

Perhaps something like this:

UPDATE YourTable
SET QTY = QTY - 1

Check the table name and column name I used to illustrate this. Put in
the
real names.

You can add criteria to this so it doesn't reduce the quantity by 1 where
the quantity is already 0, for example.

Tom Ellison


message
I know. When someone gives you a simple solution to something I spent
an
hour typing in manually (and I did!!!) it is exhilarating! You deserve
the
gush!

Can I ask another question? OK, so I've got this query. I have a QTY
column and I want to reduce each number in the QTY column by one...so
if
the
QTY column is 6 I would want it to be 5, etc. Is there a simple way to
do
that?


:

Dear Christine:

Well, you're welcome. Thanks for gushing! It really does make me
feel
good. I believe I know how you feel.

Tom Ellison


message
Hey - it worked PERFECTLY in SQL View so no need to go any further.
I'm
so
thrilled that this works and so grateful for your help! Thanks to
all
who
responded!

Cheers,
Christine

:

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would
doubtless
find
this to be an improvement, but likely not the solution you want.

You need to select 200 or more record numbers out of a list of how
many?
How is this list delivered to you? Do you get it in an email or
other
electronic document? Is it just hand-written? This may factor
into
what
is
a good answer to the question.

A possibility is to have a temporary table of these numbers,
perhaps
with
a
key to having multiple sets of them. If re-usability is an issue,
this
would be excellent. You could "keep" the list and use it again
later
to
requery the same set. If the set comes to you in any electronic
form,
this
would also be useful. The query would eliminate any reference to a
literal
list of Record #s, and just JOIN to the table with the list
desired.

Your proposed solution is workable, but I'm not sure it would be
optimal.
It would also definitely be a "single user" solution, since the
checks
are
recorded in one list. Two users creating two distinct lists
simultaneously
would interfere with one another.

Tom Ellison


message
I have a column in my table called Record #. I need to perform
queries
on
a
regular basis which include specific Record #'s. So I may need
to
select
over 200 specific record numbers in a query. This is turning
into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or 111
Or
12...

and on and on! The SQL query window looks something like this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift Cards].[Record
#])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record #])=526 Or
([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or
([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or
([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or
([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or
([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or ([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or
([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or
([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or
([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or
([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or
([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or ([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or ([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or ([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or ([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or
([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or
([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or ([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or
([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or
([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or ([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or
([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or
([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or ([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or
([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or
([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or
([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or ([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or
([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or
([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or
([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or
([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or ([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or ([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or ([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or ([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or
([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or ([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or ([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or ([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or
([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or
([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or
([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or ([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or ([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or ([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I thought
about
creating a new column in my table called TEMP and making it a
Yes/No
field
and checking the fields of the records I need and doing the query
that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Tom Ellison]

Dear Christine:

If you're writing an MDB, select queries in the database window, and click
New. Choose Design View. Don't enter anything yet. Click the SQL icon at
the upper left. If there's any text in there, delete it. Paste in what I
sent.

If you're writing an ADP and are familiar with QA, by all means use that.

Tom Ellison

OK - I'm stuck. How do I execute it? When I go into the SQL View it
already
has the query criteria. How do I add:

UPDATE QueryName
SET QTY = QTY - 1

It won't let me add it to the end of the query. I know, I'm dumb at this!
Is there a Query Analyzer like in SQL?

Yes, there is a table, but I only want to update the records in the
query. I
will give it a try and let you know the results. Backup first! Thanks
Tom

Dear Christine:

I'm not sure what Access would do. The query would certainly have to
be
updatable or I'm sure it would not.

There is a table where this data exists, right? Are you wanting to
update
only some of the rows in that table, which are already filtered in the
query? Perhaps you could filter the update query similarly and achieve
the
result.

I've never run into a situation where I wanted to do an UPDATE through
a
query. Now that you mention it, it seems possible this might come up
under
certain circumstances. Sorry to plead ignorance. Make the backup and
try
it, I guess. Nothing to lose!

Tom Ellison


message
Can I do it on a query instead of the table? Like:

UPDATE QueryName
SET QTY = QTY - 1

And if so, how do I run this command? In the SQL window?


:

Dear Christine:

First, backup the stuff. If you go making wholesale changes to the
data
and
anything goes wrong, you'll be awfully glad to have had a backup.

Perhaps something like this:

UPDATE YourTable
SET QTY = QTY - 1

Check the table name and column name I used to illustrate this. Put
in
the
real names.

You can add criteria to this so it doesn't reduce the quantity by 1
where
the quantity is already 0, for example.

Tom Ellison


message
I know. When someone gives you a simple solution to something I
spent
an
hour typing in manually (and I did!!!) it is exhilarating! You
deserve
the
gush!

Can I ask another question? OK, so I've got this query. I have a
QTY
column and I want to reduce each number in the QTY column by
one...so
if
the
QTY column is 6 I would want it to be 5, etc. Is there a simple
way to
do
that?


:

Dear Christine:

Well, you're welcome. Thanks for gushing! It really does make
me
feel
good. I believe I know how you feel.

Tom Ellison


in
message
Hey - it worked PERFECTLY in SQL View so no need to go any
further.
I'm
so
thrilled that this works and so grateful for your help! Thanks
to
all
who
responded!

Cheers,
Christine

:

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would
doubtless
find
this to be an improvement, but likely not the solution you
want.

You need to select 200 or more record numbers out of a list of
how
many?
How is this list delivered to you? Do you get it in an email
or
other
electronic document? Is it just hand-written? This may
factor
into
what
is
a good answer to the question.

A possibility is to have a temporary table of these numbers,
perhaps
with
a
key to having multiple sets of them. If re-usability is an
issue,
this
would be excellent. You could "keep" the list and use it
again
later
to
requery the same set. If the set comes to you in any
electronic
form,
this
would also be useful. The query would eliminate any reference
to a
literal
list of Record #s, and just JOIN to the table with the list
desired.

Your proposed solution is workable, but I'm not sure it would
be
optimal.
It would also definitely be a "single user" solution, since
the
checks
are
recorded in one list. Two users creating two distinct lists
simultaneously
would interfere with one another.

Tom Ellison


"Christine Lisi" <[email protected]>
wrote in
message
I have a column in my table called Record #. I need to
perform
queries
on
a
regular basis which include specific Record #'s. So I may
need
to
select
over 200 specific record numbers in a query. This is
turning
into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or
111
Or
12...

and on and on! The SQL query window looks something like
this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift
Cards].[Record
#])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record
#])=526 Or
([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or
([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or
([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or
([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or
([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or
([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or
([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or
([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or
([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or
([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or
([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or
([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or
([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or
([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or
([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or
([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or
([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or
([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or
([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or
([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or
([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or
([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or
([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or
([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or
([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or
([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or
([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or
([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or
([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or
([Gift
Cards].[Record #])=945 Or ([Gift Cards].[Record #])=1041 Or
([Gift
Cards].[Record #])=1040 Or ([Gift Cards].[Record #])=233 Or
([Gift
Cards].[Record #])=986 Or ([Gift Cards].[Record #])=927 Or
([Gift
Cards].[Record #])=830 Or ([Gift Cards].[Record #])=829 Or
([Gift
Cards].[Record #])=951 Or ([Gift Cards].[Record #])=950 Or
([Gift
Cards].[Record #])=894 Or ([Gift Cards].[Record #])=936 Or
([Gift
Cards].[Record #])=832 Or ([Gift Cards].[Record #])=1282 Or
([Gift
Cards].[Record #])=791 Or ([Gift Cards].[Record #])=792 Or
([Gift
Cards].[Record #])=793 Or ([Gift Cards].[Record #])=794 Or
([Gift
Cards].[Record #])=797 Or ([Gift Cards].[Record #])=235 Or
([Gift
Cards].[Record #])=1421 Or ([Gift Cards].[Record #])=1054 Or
([Gift
Cards].[Record #])=1212 Or ([Gift Cards].[Record #])=940 Or
([Gift
Cards].[Record #])=941 Or ([Gift Cards].[Record #])=1057 Or
([Gift
Cards].[Record #])=896 Or ([Gift Cards].[Record #])=416 Or
([Gift
Cards].[Record #])=912 Or ([Gift Cards].[Record #])=407 Or
([Gift
Cards].[Record #])=406 Or ([Gift Cards].[Record #])=408 Or
([Gift
Cards].[Record #])=886 Or ([Gift Cards].[Record #])=885))

There has got to be an easier way to accomplish this. I
thought
about
creating a new column in my table called TEMP and making it
a
Yes/No
field
and checking the fields of the records I need and doing the
query
that
way,
but this will not work because I need to save these queries.

Can anyone help?

 

[Guest]

That worked Tom! I used:

UPDATE [query name] SET QTY = QTY - 1;

You're the best! GUSH, GUSH!

Have a great day. You deserve it!!

Christine

Dear Christine:

If you're writing an MDB, select queries in the database window, and click
New. Choose Design View. Don't enter anything yet. Click the SQL icon at
the upper left. If there's any text in there, delete it. Paste in what I
sent.

If you're writing an ADP and are familiar with QA, by all means use that.

Tom Ellison

OK - I'm stuck. How do I execute it? When I go into the SQL View it
already
has the query criteria. How do I add:

UPDATE QueryName
SET QTY = QTY - 1

It won't let me add it to the end of the query. I know, I'm dumb at this!
Is there a Query Analyzer like in SQL?

Yes, there is a table, but I only want to update the records in the
query. I
will give it a try and let you know the results. Backup first! Thanks
Tom

:

Dear Christine:

I'm not sure what Access would do. The query would certainly have to
be
updatable or I'm sure it would not.

There is a table where this data exists, right? Are you wanting to
update
only some of the rows in that table, which are already filtered in the
query? Perhaps you could filter the update query similarly and achieve
the
result.

I've never run into a situation where I wanted to do an UPDATE through
a
query. Now that you mention it, it seems possible this might come up
under
certain circumstances. Sorry to plead ignorance. Make the backup and
try
it, I guess. Nothing to lose!

Tom Ellison


message
Can I do it on a query instead of the table? Like:

UPDATE QueryName
SET QTY = QTY - 1

And if so, how do I run this command? In the SQL window?


:

Dear Christine:

First, backup the stuff. If you go making wholesale changes to the
data
and
anything goes wrong, you'll be awfully glad to have had a backup.

Perhaps something like this:

UPDATE YourTable
SET QTY = QTY - 1

Check the table name and column name I used to illustrate this. Put
in
the
real names.

You can add criteria to this so it doesn't reduce the quantity by 1
where
the quantity is already 0, for example.

Tom Ellison


message
I know. When someone gives you a simple solution to something I
spent
an
hour typing in manually (and I did!!!) it is exhilarating! You
deserve
the
gush!

Can I ask another question? OK, so I've got this query. I have a
QTY
column and I want to reduce each number in the QTY column by
one...so
if
the
QTY column is 6 I would want it to be 5, etc. Is there a simple
way to
do
that?


:

Dear Christine:

Well, you're welcome. Thanks for gushing! It really does make
me
feel
good. I believe I know how you feel.

Tom Ellison


in
message
Hey - it worked PERFECTLY in SQL View so no need to go any
further.
I'm
so
thrilled that this works and so grateful for your help! Thanks
to
all
who
responded!

Cheers,
Christine

:

Dear Christine:

You are in an awkward position indeed.

The query you have can be improved slightly with this form:

WHERE [Gift Cards].[Record #] IN (1404, 1291, 525, 526)

I won't go on and on with the long list you had. You would
doubtless
find
this to be an improvement, but likely not the solution you
want.

You need to select 200 or more record numbers out of a list of
how
many?
How is this list delivered to you? Do you get it in an email
or
other
electronic document? Is it just hand-written? This may
factor
into
what
is
a good answer to the question.

A possibility is to have a temporary table of these numbers,
perhaps
with
a
key to having multiple sets of them. If re-usability is an
issue,
this
would be excellent. You could "keep" the list and use it
again
later
to
requery the same set. If the set comes to you in any
electronic
form,
this
would also be useful. The query would eliminate any reference
to a
literal
list of Record #s, and just JOIN to the table with the list
desired.

Your proposed solution is workable, but I'm not sure it would
be
optimal.
It would also definitely be a "single user" solution, since
the
checks
are
recorded in one list. Two users creating two distinct lists
simultaneously
would interfere with one another.

Tom Ellison


"Christine Lisi" <[email protected]>
wrote in
message
I have a column in my table called Record #. I need to
perform
queries
on
a
regular basis which include specific Record #'s. So I may
need
to
select
over 200 specific record numbers in a query. This is
turning
into a
nightmare. Firstly, in design view I'm manually typing:

1404 Or 1289 Or 125 Or 284 Or 3329 Or 243 Or 3087 Or 235 Or
111
Or
12...

and on and on! The SQL query window looks something like
this:

WHERE ((([Gift Cards].[Record #])=1404 Or ([Gift
Cards].[Record
#])=1291
Or
([Gift Cards].[Record #])=525 Or ([Gift Cards].[Record
#])=526 Or
([Gift
Cards].[Record #])=1362 Or ([Gift Cards].[Record #])=1178 Or
([Gift
Cards].[Record #])=1182 Or ([Gift Cards].[Record #])=1174 Or
([Gift
Cards].[Record #])=1180 Or ([Gift Cards].[Record #])=1183 Or
([Gift
Cards].[Record #])=1179 Or ([Gift Cards].[Record #])=1181 Or
([Gift
Cards].[Record #])=353 Or ([Gift Cards].[Record #])=819 Or
([Gift
Cards].[Record #])=818 Or ([Gift Cards].[Record #])=1171 Or
([Gift
Cards].[Record #])=1173 Or ([Gift Cards].[Record #])=1172 Or
([Gift
Cards].[Record #])=690 Or ([Gift Cards].[Record #])=1210 Or
([Gift
Cards].[Record #])=1211 Or ([Gift Cards].[Record #])=1209 Or
([Gift
Cards].[Record #])=1121 Or ([Gift Cards].[Record #])=1002 Or
([Gift
Cards].[Record #])=966 Or ([Gift Cards].[Record #])=826 Or
([Gift
Cards].[Record #])=660 Or ([Gift Cards].[Record #])=661 Or
([Gift
Cards].[Record #])=943 Or ([Gift Cards].[Record #])=740 Or
([Gift
Cards].[Record #])=948 Or ([Gift Cards].[Record #])=542 Or
([Gift
Cards].[Record #])=1039 Or ([Gift Cards].[Record #])=699 Or
([Gift
Cards].[Record #])=1059 Or ([Gift Cards].[Record #])=1112 Or
([Gift
Cards].[Record #])=543 Or ([Gift Cards].[Record #])=713 Or
([Gift
Cards].[Record #])=1111 Or ([Gift Cards].[Record #])=1060 Or
([Gift
Cards].[Record #])=1113 Or ([Gift Cards].[Record #])=405 Or
([Gift
Cards].[Record #])=997 Or ([Gift Cards].[Record #])=504 Or
([Gift
Cards].[Record #])=1225 Or ([Gift Cards].[Record #])=1105 Or
([Gift
Cards].[Record #])=1107 Or ([Gift Cards].[Record #])=1106 Or
([Gift
Cards].[Record #])=958 Or ([Gift Cards].[Record #])=808 Or
([Gift
Cards].[Record #])=807 Or ([Gift Cards].[Record #])=1259 Or
([Gift
Cards].[Record #])=1119 Or ([Gift Cards].[Record #])=608 Or
([Gift
Cards].[Record #])=1055 Or ([Gift Cards].[Record #])=607 Or
([Gift
Cards].[Record #])=828 Or ([Gift Cards].[Record #])=824 Or
([Gift
Cards].[Record #])=1151 Or ([Gift Cards].[Record #])=1050 Or
([Gift
Cards].[Record #])=1287 Or ([Gift Cards].[Record #])=232 Or