Field Names In a Query

[Nathan Bloom]

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

[MacDermott]

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