Error: Specified field refers to more than one table

[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

 

[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

 

[Sue Compelling]

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

 

[Lord Kelvan]

as a note can you paste your entire query

 

[Lord Kelvan]

your welcome my follower ^_^

 

[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'?

 

[Lord Kelvan]

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