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!

QUERYING LINKED TABLES

Status
Not open for further replies.
journeyman

journeyman

Programmer
Aug 29, 2002
5
0
0
GB
My problem is that the 3 tables I need to run the query on includes one which I have renamed using an autonumber.

If I try to refer to this table as "Table" & autonumber
in a SQL statement the quotation marks throw up an 'expected end of statement' error.

Any ideas?!?
 
Status
Not open for further replies.

Similar threads

raywood1
  • Locked
  • Question
Reducing a Massive Linked Table
Replies
4
Views
111
dhookom
dhookom
JayRo71
  • Locked
  • Question
Importing only unique records from excel tables 1
Replies
10
Views
174
SkipVought
S
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
111
SkipVought
S
03Explorer
  • Locked
  • Question
Refreshing a linked table (housed on MS SQL Server) now breaks
Replies
3
Views
91
dhookom
dhookom
puforee
  • Locked
  • Question
Best way to setup tables for multible related data sets
Replies
1
Views
69
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top