multiple inner joins getting syntax error

[ringram]

I am beating my head against a wall on this one.
The query below generates this error
"Syntax error (missing operator) in query expression '(Ebay_posting.id=cint(order_items.ebaynumber)) inner JOIN inventory ON (Ebay_posting.description=inventory.ID'."
I and a bit new to using joins but I cannot see the issue here.

SELECT  order_items.itemID,	order_items.order_id,
	 order_items.ebaynumber,
	 order_items.qty,
	 order_items.shipping_charged, 
	order_items.shipping_cost, 
	order_items.defaultedby, 
	order_items.defaulteddate, 
	order_items.org_customer, 
	order_items.mac, 
	order_items.itemtotal, 
	nz(order_items.itemtotal,0)+nz(order_items.shipping_charged) AS gross, 
	(nz(order_items.itemtotal,0)+nz(order_items.shipping_charged))-order_items.shipping_cost AS net, 
	Ebay_posting.price, 
	Ebay_posting.lots_of, 
	inventory.Inventoryid
FROM Ebay_posting inner JOIN order_items ON (Ebay_posting.id=cint(order_items.ebaynumber))
                  inner JOIN inventory   ON (Ebay_posting.description=inventory.ID);

I built this in steps and it worked until I added the parts in red.
Any Ideas?

[June7]

Why don't you use the Access query builder to get the correct syntax?

[ringram]

Why don't you use the Access query builder to get the correct syntax?

because of

 Ebay_posting inner JOIN order_items ON (Ebay_posting.id=cint(order_items.ebaynumber)) 

I cannot use access to display this query I have to execute and edit it via SQL view. I did an simpler version of the join letting access set the syntax
and here it is below and this worked as expected

SELECT Ebay_posting.description, Ebay_posting.ebay_item, inventory.description, inventory.Inventoryid
FROM Ebay_posting INNER JOIN  inventory ON inventory.[ID] = Ebay_posting.[description];

[June7]

Sorry, I don't understand why cannot use query designer.

[ringram]

I was missing some brackets.

SELECT order_items.itemID, order_items.order_id, order_items.ebaynumber, order_items.qty, order_items.shipping_charged, order_items.shipping_cost, order_items.defaultedby, order_items.defaulteddate, order_items.org_customer, order_items.mac, order_items.itemtotal, nz(order_items.itemtotal,0)+nz(order_items.shipping_charged) AS gross, (nz(order_items.itemtotal,0)+nz(order_items.shipping_charged))-order_items.shipping_cost AS net, Ebay_posting.price, Ebay_posting.lots_of
FROM ((Ebay_posting INNER JOIN order_items ON Ebay_posting.id=cint(order_items.ebaynumber)) inner JOIN inventory   ON (Ebay_posting.description=inventory.ID));

the reason I cant use access design view is that when I try to view it in design view I get
"Microsoft Access can't represent the join expressed Ebay_posting.id=cint(order_items.ebaynumber in design view"
and if i take cint() out the query give me mismatched in date in query.

[June7]

My suggestion was to use design view WITHOUT that additional table join. Use the designer to then add in the table and set the link.