Hi,
I was wondering if it is possible to join more than two tables inside a query. Im getting an error and I assume it is becaue im trying to join multiple tables.

It works in SQL using:

'Select USERCARD.HOLDID, MASTPLU.LOYALTY_POINTS, CHIPTRAN.PLQTY from CHIPTRAN
inner join USERCARD on USERCARD.SERIALNO = CHIPTRAN.SERIALNO
inner join MASTPLU on CHIPTRAN.MASTLINE = MASTPLU.MASTLINE
inner join MAC on MAC.MACID = CHIPTRAN.MACID
where... '

Any ideas???

I don't know what my own record is for multiple joins within a query...but it's a lot more than two! What is the error you are getting.

The error is:

Syntax error (missing operator) in query expression 'USERCARD.SERIALNO = CHIPTRAN.SERIALNO
inner join MASTPLU on CHIPTRAN.MASTLINE = MASTPLU.MASTLINE
inner join MAC on MAC.MACID = CHIPTRAN.MACID
where...'

Can you post the SQL for your entire Access query?

Why not create the joins in QBE view and let Access generate the SQL rather than searching for the syntax error?