query\adding rows

  • Thread starter Thread starter Frank Murray
  • Start date Start date
F

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
 
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');
 
-----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
Click to expand...
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.
 
Back
Top