Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Make Table Query

Status
Not open for further replies.
gregmw

gregmw

MIS
Jun 11, 2002
23
0
0
NZ
I have a make table query. I would like the user to be given an option to call the table what they like when the query is run. Is this possible without having to change the table name via the query each time?

Thanks
 
Sort by date Sort by votes
One way would be use a form to allow the user to provide a name; assemble the query out of the name provided and then call the query.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
106
Andrzejek
Andrzejek
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
166
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
174
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
161
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
174
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top