From access to SQL

M

MUSIWA

I have a report with multiple subreports. It worked fine in access with just
linking the contactID and the visitdate which is the same for all the sub
reports. Problem is when I try it in SQL I get an error like abnormal access.
Each sub report works fine by itself including the main report. but it wont
work together. All the subreports have a table associated with them and I use
the same contactid and visitdate to select the correct contact and visit. Am
I missing something in SQL? HELP!
 
Top