|
| 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
May 13th, 2010, 03:12 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Is there anything wrong with the syntax
It gave me synatx error from clause?
SELECT GL Finance Credit Query.* FROM GL Finance Credit Query UNION ALL SELECT GL Finance Debit Query.* FROM GL Finance Debit Query; -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 
|
|
#2
May 13th, 2010, 03:29 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Is there anything wrong with the syntax
SELECT [GL Finance Credit Query].* FROM [GL Finance Credit Query]
UNION ALL SELECT [GL Finance Debit Query].* FROM [GL Finance Debit Query]; You must delimit the query names with square brackets because the query names contain spaces. -- Ken Snell http://www.accessmvp.com/KDSnell/ "Syphonics via AccessMonster.com" u25414@uwe wrote in message news:a7ebbe14e7f5d@uwe... It gave me synatx error from clause? SELECT GL Finance Credit Query.* FROM GL Finance Credit Query UNION ALL SELECT GL Finance Debit Query.* FROM GL Finance Debit Query; -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1
|
|
#3
May 13th, 2010, 07:25 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Is there anything wrong with the syntax
Thanks a lot its works!
Ken Snell wrote: SELECT [GL Finance Credit Query].* FROM [GL Finance Credit Query] UNION ALL SELECT [GL Finance Debit Query].* FROM [GL Finance Debit Query]; You must delimit the query names with square brackets because the query names contain spaces. It gave me synatx error from clause? SELECT GL Finance Credit Query.* FROM GL Finance Credit Query UNION ALL SELECT GL Finance Debit Query.* FROM GL Finance Debit Query; -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
