Help with Access Query

[Marsonk]

I'm pretty new to access and I’m trying to write a query. This is what I have so far:

SELECT orders.*, Cart.*, products.pname, products.pDescription, products.pSection
FROM (Orders INNER JOIN Cart ON orders.ordSessionID=Cart.cartSessionID) INNER JOIN Products ON products.pID=cart.CartProdID
WHERE orders.ordAuthNumber<>' ' And orders.ordAuthNumber<>'Email Only' And Orders.ordAuthNumber<>'manual auth';

This gives me the results that I want but I would like this to output to a new table automatically. Also every time it runs to replace that table with the new info from this query. PLEASE HELP ANYONE!!!

 

[yippie_ky_yay]

Hey Marsonk,

Select "Query", "Make-Table Query". Afterwards, Access should prompt you wether or not you would like to replace the table.

-Sean

 

[Marsonk]

Thanks

Man that was right in my face! Thanks a lot!!