Error: Specified field refers to more than one table


S

Sue Compelling

Hi

I am creating a select query from two tables called Attempts and
CampaignProgression

I have the following expression:

CMD: ([campaign] & [datemth] & [dateday])

though an error message comes up saying "The specified field '[campaign]'
could refer to more than one table listed in the FROM clause of your SQL
statement'

My question is - how do I change my expression to tell access to use the
[campaign] field from the attempts table? (I did try ....
[Attemts]![Campaign] though it mumbled something about aggregate ...

TIA

Sue
 
Ad

Advertisements

L

Lord Kelvan

you use dot notation not the !

[attemts].[campaign]

that error releates to when you have the same field name in multiple
tables in your query

hope this helps

regards
kelvan
 
S

Sue Compelling

Really appreciate your help (and speed) my liege - that did the trick
 
S

Sue Compelling

Hi Kelvan - unfortunately I'm a newbie and can only use the query design. is
there a way that I can see these as SQL statements so I can post the 'entire
query'?
 
Ad

Advertisements

L

Lord Kelvan

Dont worry about it if it worked but to view sql click view in the
menu bar and then click sql view
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top