F
FA
Hi Friends, I am using Word merge code by Albert D. Kallal in my
database and i want to dump a query result to word file. Its working
fine with the query that has no Where clause, but when i put a where
clause in the query it does not work it gives me error; " No Data was
created for this merge, make sure the sql is correct. sql was
"queryforword".
Here is my query,
SELECT dbo_SYS_INFO.SYS_NME, dbo_FINDG.FINDG_NO,
dbo_SYS_INFO.SYS_ID_CODE, dbo_FINDG.FINDG_NME
FROM dbo_SYS_INFO, dbo_FINDG
WHERE
(((dbo_SYS_INFO.SYS_ID_CODE)=[Forms]![frmSelectSystemName]![SYS_ID_CODE]))
GROUP BY dbo_SYS_INFO.SYS_NME, dbo_FINDG.FINDG_NO,
dbo_SYS_INFO.SYS_ID_CODE, dbo_FINDG.FINDG_NME;
When i take the Where clause out, it gives me the error mention above.
it is dumping all the results of this query but i want to dump the
select record according to "SYS_ID_CODE"
If anyone can help me please
Moe
database and i want to dump a query result to word file. Its working
fine with the query that has no Where clause, but when i put a where
clause in the query it does not work it gives me error; " No Data was
created for this merge, make sure the sql is correct. sql was
"queryforword".
Here is my query,
SELECT dbo_SYS_INFO.SYS_NME, dbo_FINDG.FINDG_NO,
dbo_SYS_INFO.SYS_ID_CODE, dbo_FINDG.FINDG_NME
FROM dbo_SYS_INFO, dbo_FINDG
WHERE
(((dbo_SYS_INFO.SYS_ID_CODE)=[Forms]![frmSelectSystemName]![SYS_ID_CODE]))
GROUP BY dbo_SYS_INFO.SYS_NME, dbo_FINDG.FINDG_NO,
dbo_SYS_INFO.SYS_ID_CODE, dbo_FINDG.FINDG_NME;
When i take the Where clause out, it gives me the error mention above.
it is dumping all the results of this query but i want to dump the
select record according to "SYS_ID_CODE"
If anyone can help me please
Moe