Re: Make Table Query question
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 08 Feb 2006 11:07:31 -0700
On Wed, 8 Feb 2006 08:26:32 -0800, Ron <Ron@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I want to create a query that will continually prompt the user for a value to
be entered and then store those results in either a fixed table or display
them in an
on-the-fly results query display (haven't decided which one would be better).
The latter. A Select Query lets you do everything needed for a report
- running a MakeTable query adds a lot of overhead (system tables,
indexes, etc.) and is very, very rarely needed in a production
database.
1) Is there an easy way to make the query continually prompt for a value to
be entered? If so, then how? And how would the user be able to opt out of
it and view the results of all entered values?
Are these criteria to be used in searching for existing records? or is
the user entering new data to be reported? What's the context?
The values to be entered are 5 digit Job #'s with all their associated
versions
(eg) Job #; 12345 with possible versions of 1, 2, 3, 4, 5.
I'm sorry but that makes no sense whatsoever. What table contains Job
#? Are there existing records that you want the user to select, or do
you want the user to manually or automatically create new job numbers?
Is there any other information associated with these job numbers?
Thanks in advance for helping to shed some light on this.
Hope you can do the same by shedding a bit more light on your
requirements - I'm still in the fog here!
John W. Vinson[MVP]
.
- Prev by Date: Re: Name order streamlining
- Next by Date: Re: Help with Update Query - VBA error
- Previous by thread: Re: Make Table Query question
- Next by thread: Re: Make Table Query question
- Index(es):
Relevant Pages
|
