By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,087 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Field Names In a Query

P: n/a
Hi,

I would like to design an append query that will recieve the table name at
runtime. For Example:

INSERT INTO [Forms]]![fArchiveRecord]![[TableName]
SELECT tPerformance.*
FROM tPerformance;

However, I am not sure if this can be done. As the syntax is incorrect as
Access balks at it when I try and save it. If it is possible to construct
such a query, if anyone could provide me with the proper syntax, I would be
very appreciative of your help.

Thanks in advance of any help offered.
Nathan Bloom
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
AFAIK, you cannot create and save a query like this.
However, you can write code which will create and execute this query "on the
fly".

HTH
- Turtle

"Nathan Bloom" <na*******@earthlink.net> wrote in message
news:V%***************@newsread4.news.pas.earthlin k.net...
Hi,

I would like to design an append query that will recieve the table name at
runtime. For Example:

INSERT INTO [Forms]]![fArchiveRecord]![[TableName]
SELECT tPerformance.*
FROM tPerformance;

However, I am not sure if this can be done. As the syntax is incorrect as
Access balks at it when I try and save it. If it is possible to construct
such a query, if anyone could provide me with the proper syntax, I would be very appreciative of your help.

Thanks in advance of any help offered.
Nathan Bloom

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.