Question about the SELECT Command

[Sunwers]

Hello everyone,



I need some help with Access. I'm new to this program and I need to list all information about a customer (using that customer's number) from a Customer table. Here is the command I have:

SELECT Customer WHERE CustomerNum=453
GIVING Answer

This command need to create a new table named Answer that contains only one row in which the customer number is 453. I created a query and selected the customer table. Then I clicked on SQL view at the top left-hand side and enter this command... I also tried adding commas in between but it said I had a syntax error. What am I doing wrong?

Thanks in Avance

:-)

Sunwers

[pbaldy]

To my knowledge GIVING isn't valid SQL. Creating a new table would unusual, but look at a make table query if you really need to.