Hi,
In Such Cases, You have to Create a SQL Query like :
Say In NewTable, (SNO 1 to 10) , You are saving in Field1, Field2, Field3
and For Table2 You are Saving in Field4 , Field5 , Field6 (SNo 11 To 15)
and you need to display Field1 or Field4 (depending on SNo) ...
For that you have 2 approaches.. Change SQL Query Accordingly..
Some thing like this :
Select A.SNo, A.Field1 As FldX, A.Field2 As FldY, A.Field3 As FldZ From NewTable A Where SNO <=10
UNION ALL
Select B.SNo , B.Field4 As FldX, B.Field5 As FldY, B.Field6 As FldZ From NewTable B Where SNO > 10
Note : In above Query, you need to have Same Field Type for Field1 and Field4..
2 Method:
Select SNo, Trim(Field1 & Field4) As FldX, Trim(Field2 & Field5) As FldY,
Trim(Field3 & Field6) As FldZ From NewTable Order By SNo
In Above Query, If both the fields are different, you can use Explicit Conversions..
Say Field1 Is Text and Field4 is Numeric, then you can give this in access:
Select SNo, Trim(Field1 & Cstr(Field4)) As FldX, Trim(Field2 & Field5) As FldY,
Trim(Field3 & Field6) As FldZ From NewTable Order By SNo
Now Design the DataReport on FldX, FldY, FldZ.
These Kind of Reports are done a Lot More Easier in Crystal Reports (All Versions). Just Place Fields One above the other, and Suppress Blank Values For Numeric Fields..
Regards
Veena