truncate and append records using ACCESS

[rsmith904]

I have variable length data that need data appended to the end of the record. I'm using a select statement. I got a syntax error when using:

SELECT trim(trailing from Global Address List.E-mail address) || '@usaid.gov', [Global Address List].First, [Global Address List].Last, [Global Address List].Company,
FROM [Global Address List]
WHERE ((([Global Address List].Company) Like "xxxx/IG/*" Or ([Global Address List].Company) Like "*RIG*"));

I would appreciate any help.

 

[Itshim]

If you are getting a syntax error from Access then this is not a PHP question, you might want to post in here forum701.

If the syntax error is coming from PHP, you will need to post your php code not just the SQL statement.