including two?

  • Thread starter Thread starter SlimJim
  • Start date Start date
S

SlimJim

Sorry for lack of a better subject line, but I didn't know
how to classify this question.

I want to ask the query to prompt the user to enter the
part number (has text in it too) for the first one then
the second one. There will only be the need to enter two
every time.

To give you an example here are the part numbers,
e.g. SP01e, SP01w, SP02n, SP02s, etc.

Thanks,

SlimJim
 
In the criteria portion of the query, under the part number column, enter
something like [Enter Part Number].

When the query is executed, there will be a prompt that says "Enter Part
Number" and give the use a place to type the number.

If you have two fields like this, put that type of prompt (with the square
brackets around it) in the criteria field for each one.
 
Sorry for lack of a better subject line, but I didn't know
how to classify this question.

I want to ask the query to prompt the user to enter the
part number (has text in it too) for the first one then
the second one. There will only be the need to enter two
every time.

To give you an example here are the part numbers,
e.g. SP01e, SP01w, SP02n, SP02s, etc.

Thanks,

SlimJim
Click to expand...

If the user must enter two criteria, then give them two prompts. What
do you intend to do with the two part numbers that they enter? What's
the context?
 
thanks Larry. What I'm looking for is to be able to
enter two part numbers so the report will show the
listing for those two. It will always be two part
numbers. The difference is the last digit. Can this
work? If I added another column in my query to match the
first one wouldn't the same field show up on the report?
I want them to show up under the same heading.

thanks,

Jim

-----Original Message-----
In the criteria portion of the query, under the part number column, enter
something like [Enter Part Number].

When the query is executed, there will be a prompt that says "Enter Part
Number" and give the use a place to type the number.

If you have two fields like this, put that type of prompt (with the square
brackets around it) in the criteria field for each one.

Sorry for lack of a better subject line, but I didn't know
how to classify this question.

I want to ask the query to prompt the user to enter the
part number (has text in it too) for the first one then
the second one. There will only be the need to enter two
every time.

To give you an example here are the part numbers,
e.g. SP01e, SP01w, SP02n, SP02s, etc.

Thanks,

SlimJim
Click to expand...


.
Click to expand...
 
ok, how do I do that?

Jim
-----Original Message-----


If the user must enter two criteria, then give them two prompts. What
do you intend to do with the two part numbers that they enter? What's
the context?


.
Click to expand...
 
We have two part numbers that need to be in a report. I
need to be able to enter any two part numbers when the
query runs.
 
We have two part numbers that need to be in a report. I
need to be able to enter any two part numbers when the
query runs.
Click to expand...

[Enter Part Number 1] OR [Enter Part Number 2]

as a criterion under the part number field.

Remember this: YOU can see your table. YOU know what a partnumber is
in your system. YOU know what you mean by "enter any two part numbers"
and how you want them to search the table.

I do not. If you don't give me useful information such as the
structure of your table, then I must make a guess as I did above. That
guess might or might not be helpful. If I were telepathic, I could do
better, but I'm not.

Hope this helped. If not... please, post some more description?
 
I'm sorry I didn't give you any more information
previously. This database holds a maintenance log for the
school zone flashers for the city. There are always two
lights associated with each flasher. Each of these
flashers have a unique number, such as SP04w. The w stands
for west end. The other flasher that is associated with
this location is SP04e with the e representing the east
end. I would like the employee to be able to just enter
the first 4 digits, like SP04, and it would show the
complete maintenance history at that location, both east
and west.

The other locations are just alike this one. The naming
convention stayed the same, except we use "n" or "s" to
represent north or south end provided that is how they are
positioned.

Hope this helps!

Thanks for helping!

Jim

-----Original Message-----
We have two part numbers that need to be in a report. I
need to be able to enter any two part numbers when the
query runs.
Click to expand...

[Enter Part Number 1] OR [Enter Part Number 2]

as a criterion under the part number field.

Remember this: YOU can see your table. YOU know what a partnumber is
in your system. YOU know what you mean by "enter any two part numbers"
and how you want them to search the table.

I do not. If you don't give me useful information such as the
structure of your table, then I must make a guess as I did above. That
guess might or might not be helpful. If I were telepathic, I could do
better, but I'm not.

Hope this helped. If not... please, post some more description?


.
Click to expand...
 
I'm sorry I didn't give you any more information
previously. This database holds a maintenance log for the
school zone flashers for the city. There are always two
lights associated with each flasher. Each of these
flashers have a unique number, such as SP04w. The w stands
for west end. The other flasher that is associated with
this location is SP04e with the e representing the east
end. I would like the employee to be able to just enter
the first 4 digits, like SP04, and it would show the
complete maintenance history at that location, both east
and west.
Click to expand...

Thank you. That little bit of "inside information" does indeed help;
especially since your original post said
I want to ask the query to prompt the user to enter the
part number (has text in it too) for the first one then
the second one. There will only be the need to enter two
every time.
Click to expand...

and it seems that this is NOT what you in fact wanted to happen;
you're now saying you want the user to just enter the first 4 digits,
not "enter two every time".

Two suggestions:

- If the parts always come in pairs, use TWO FIELDS - one containing
"SPO4" and the other "e" or "w".

- If you want to work with the table as it is, you can use a
criterion of

LIKE [Enter part number:] & "*"

This will return all part numbers starting with SPO4 if that's what
the user types at the prompt.
 
BINGO!! That's exactly what I wanted John! Thanks for
being patient with me. I'll try to include more
information the next time I need help.

thanks again,

Jim

-----Original Message-----
I'm sorry I didn't give you any more information
previously. This database holds a maintenance log for the
school zone flashers for the city. There are always two
lights associated with each flasher. Each of these
flashers have a unique number, such as SP04w. The w stands
for west end. The other flasher that is associated with
this location is SP04e with the e representing the east
end. I would like the employee to be able to just enter
the first 4 digits, like SP04, and it would show the
complete maintenance history at that location, both east
and west.
Click to expand...

Thank you. That little bit of "inside information" does indeed help;
especially since your original post said
I want to ask the query to prompt the user to enter the
part number (has text in it too) for the first one then
the second one. There will only be the need to enter two
every time.
Click to expand...

and it seems that this is NOT what you in fact wanted to happen;
you're now saying you want the user to just enter the first 4 digits,
not "enter two every time".

Two suggestions:

- If the parts always come in pairs, use TWO FIELDS - one containing
"SPO4" and the other "e" or "w".

- If you want to work with the table as it is, you can use a
criterion of

LIKE [Enter part number:] & "*"

This will return all part numbers starting with SPO4 if that's what
the user types at the prompt.


.
Click to expand...
 
Back
Top