Running Query in SQL

  • Thread starter Thread starter weircolin
  • Start date Start date
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
 
try

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

hth
 
Back
Top