Run-time error 3079

[FredChamberlin]

Using Access 2013 I have the following queries:

qryVouchersNotRecieved:

SELECT dbo_FieldTrips.TripID AS VoucherNumber, dbo_FieldTrips.DepartureDate AS TripDate, dbo_FieldTrips.Status, dbo_FieldTrips.School AS Requestor, dbo_FieldTrips.Destination, dbo_FieldTrips.TripCategory, dbo_FieldTrips.TeamNumber, dbo_FieldTrips.ActivityTeamNumber
FROM dbo_FieldTrips INNER JOIN qryVouchersNoReport ON dbo_FieldTrips.TripID = qryVouchersNoReport.TripID
ORDER BY dbo_FieldTrips.DepartureDate;
 

AND

qryVouchersNoReport:

SELECT dbo_FieldTrips.TripID, CStr([dbo_FieldTrips].[TripID]) AS TripNumber
FROM dbo_FieldTrips
WHERE (((CStr([dbo_FieldTrips].[TripID])) Not In (SELECT dbo_VW_VoucherReport.VoucherNumber FROM dbo_VW_VoucherReport )));
 

Running the first query directly in Access produces the desired results. However, when I pass that query name in a DoCmd.OpenReport statement, although I fully qualify the DepartureDate field I get this error:

"The specified field dbo_FieldTrips.DepartureDate could refer to more than one table in the FROM clause of your SQL statement."

[Stephen08]

here the problem is with your field names. Don't use the same field names as outputs from a query & you will not have ambiguous join errors.

[FredChamberlin]

Thank you for taking the time to reply, but I do not understand. If any field is named the same it is TripID. I aliased that name in one of the queries but got the same result.

Note also that the error message referenced the DepartureDate field, which exists in only one of the tables. Further, the error message itself contains the table name, showing that I did in fact qualify it.