In a query "can't represent join expression in design view"

[Guest]

A2003, using the wizard to create a summary query I get a message "...can't
represent the join expression in design view...". The datasheet view looks
fine but I can't get to the design view. Instead it shows me SQL editor which
includes the following:
FROM PARTY INNER JOIN PASSENGER ON ([PARTY].[PartyName]
=[PASSENGER].[PartyName]) AND ((([PARTY].[TourDate] =[PASSENGER].[TourDate])
AND ([PARTY].[TourID] =[PASSENGER].[TourID])) AND ([PARTY].[VehicleID]
=[PASSENGER].[VehicleID]))

Any ideas ?

TIA,
Charlie

 

[James Hahn]

This is the error for 97 and 2000 -perhaps it's the same in 2003. It's worth
a try.
http://support.microsoft.com/?kbid=207868
ACC2000: "Microsoft Access Can't Represent the Join Expression" Error
Message in Query Design