If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
This probably seems very elementary
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. -- Thanks from a frustrated accountant |
#2
|
|||
|
|||
This probably seems very elementary
|
#3
|
|||
|
|||
This probably seems very elementary
On Fri, 11 Nov 2005 08:42:03 -0800, AccessNewbie
wrote: 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. 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] |
#4
|
|||
|
|||
This probably seems very elementary
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! -- Regards Jeff Boyce Office/Access MVP "AccessNewbie" wrote in message ... 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. -- Thanks from a frustrated accountant |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Looking for a form used by elementary school admins . . . | Endlessly Searching | General Discussions | 1 | March 30th, 2005 08:11 AM |
licensing issue | Mike | General Discussions | 3 | September 8th, 2004 06:30 AM |
Need help making chart using data from two columns? Elementary.... | Andy_CYXU | Charts and Charting | 1 | January 5th, 2004 01:15 AM |