This probably seems very elementary

A

AccessNewbie

I need to create a query whereby when I run it I get a prompt to input
anything I want, in this case a date. The field doesn't refer to any field
in the tables I'm using, it's just sort of a "wild card". I know in the
criteria area I can put in [date] and i'll be prompted for the date. What
do I put in for "field" if I'm not really refering to a field. I can put in
Date: [date] and it works but then it prompts me twice for the same data when
I run the query.

Hope I stated my problem somewhat clearly.
 
T

Tom Lake

[email protected]...
I need to create a query whereby when I run it I get a prompt to input
anything I want, in this case a date. The field doesn't refer to any
field
in the tables I'm using, it's just sort of a "wild card". I know in the
criteria area I can put in [date] and i'll be prompted for the date.
What
do I put in for "field" if I'm not really refering to a field. I can put
in
Date: [date] and it works but then it prompts me twice for the same data
when
I run the query.

Hope I stated my problem somewhat clearly.
Click to expand...

Have you tried using a different field name?

DummyDate:[date]

Tom Lake
 
J

John Vinson

I need to create a query whereby when I run it I get a prompt to input
anything I want, in this case a date. The field doesn't refer to any field
in the tables I'm using, it's just sort of a "wild card". I know in the
criteria area I can put in [date] and i'll be prompted for the date. What
do I put in for "field" if I'm not really refering to a field. I can put in
Date: [date] and it works but then it prompts me twice for the same data when
I run the query.

Hope I stated my problem somewhat clearly.
Click to expand...

It SOUNDS like you're asking Access to find something, but not telling
it where to look. Am I misunderstanding? Suppose you have 23 tables
totalling 248 fields, a dozen of them date fields. What do you want -
to put in a date, and have it intuit which table and which field you
want to search? That *could* be done, but with a great deal of effort!

Step back a bit. What are you trying to accomplish, in a real-world
sense?

John W. Vinson[MVP]
 
J

Jeff Boyce

I can't tell if you are trying to design a database, or if you are trying to
query an existing database -- the phrase that has me puzzled is "... input
anything I want".

You find that you get much more out of Access if you are much more specific
about what you want it to do.

Try posting back with a description of what you are trying to accomplish.
Consider describing it as you would tell an 80-year old grandmother - no
tech-talk!
 
Top