query\adding rows

[Frank Murray]

Hello,

I have a simple question, but the task is not presenting itself simply.
I want to (through a query) add a row to an existing table.

I have tried "Insert Into" statements with spaces instead of any customary
data, but get back nothing but syntax errors.

Any assistance is appreciated. Thanks in advance.

fjm

 

[Dan Artuso]

Hi,
The question is fairly vague so I can only give you
samples. These are directly from Help:

INSERT INTO Customers SELECT * FROM NewCustomers;

INSERT INTO Employees (FirstName,LastName, Title) VALUES ('Harry', 'Washington', 'Trainee');

 

[tina]

-----Original Message-----
Hello,

I have a simple question, but the task is not presenting itself simply.
I want to (through a query) add a row to an existing table.

I have tried "Insert Into" statements with spaces instead of any customary
data, but get back nothing but syntax errors.

Any assistance is appreciated. Thanks in advance.

fjm


.
you day you've tried the "Insert Into" statement with

spaces instead of any customary data. why spaces instead
of data? are you trying to add a BLANK record to a table,
one with no data in any field? if so, the short answer is:
you can't.