If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Duane Hookum's Concatentate - trouble in Access 2007?
I have a database that I created in Access 2003; there are a few places where
I use the code from Duane Hookum's concatentae funcion in my database. The code has worked perfectly for well over a year in several instances, however suddenly it won't work anywhere. I get a run-time error - Syntax error (missing operator) in query expression - 'MailingID =' ... when I debug it, the following line of code is hightlighted: Set rs= db.OpenRecordset (PastStrSQL) I haven't changed any of my code, however we did move to Access 2007 recently. If the SQL doesn't appear to be the problem, I would appreciate any suggestions on where to troubleshoot. I really miss using this funtion. Thank you, Heather Here is a sample of the SQL of one of the queries that no longer works ... SELECT sysqryShiningStarHouseholdIDs.MailingID, Concatenate("SELECT LastName FROM sysqryShiningStars WHERE MailingID =" & [MailingID] & " ORDER BY LastName") AS LastNames, Concatenate("SELECT FirstName FROM sysqryShiningStars WHERE MailingID =" & [MailingID] & " ORDER BY FirstName") AS FirstNames, Concatenate("SELECT Age FROM sysqryShiningStars WHERE MailingID =" & [MailingID] & " ORDER BY FirstName") AS Age FROM sysqryShiningStarHouseholdIDs; SQL for sqryShiningStarHouseholdIDs: SELECT sysqryShiningStarDesignators.MailingID, First (sysqryShiningStarDesignators.ProfileCode) AS FirstOfProfileCode FROM sysqryShiningStarDesignators GROUP BY sysqryShiningStarDesignators.MailingID; SQL for sysqryShiningStarDesignators: SELECT tblMailingList.MailingID, tblDesignators.ProfileCode FROM tblMailingList RIGHT JOIN tblDesignators ON tblMailingList.MailingID = tblDesignators.MailingID WHERE (((tblDesignators.ProfileCode)="ShiningStar")); -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|