Running Query in SQL

W

weircolin

Hi

I've been stck witht his thing for hours and I know it's something
really simple!

I have a query and in SQL view I have the following

INSERT INTO Atendee ( Person, Event )
SELECT FirstName+' '+LastName AS Person,
[eventgenerate.form].cboselectevent AS Event
FROM [Members Names];

It comes up to say

"'add new event query' is not a valid name. Make sure that it does
not include invalid characters or punctuation and that it is not too
long."

Now, if I remove the section [eventgenerate.form].cboselectevent and
replace it with a value, say 1, the query works fine, no issues. So
I'm guessing my syntax is wrong or something.

Can anyone help me with this? As I say, I'm pretty sure it's
something simple but it's really getting to me and it's the last thing
I need to do to make the DB complete!

Cheers

Colin
 
T

tina

try

INSERT INTO Atendee ( Person, Event )
SELECT FirstName+' '+LastName AS Person,
[Forms]![eventgenerate]![cboselectevent] AS Event
FROM [Members Names];

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top