|
-
Jun 11th, 2007, 06:18 PM
#1
Thread Starter
Addicted Member
DataReport Problem
I have 2 table in my access database
Table 1 = tblCustomer
have these fields:
Customer_Number
Visit_ID
Admition
Lap
Minor
Altra
Dressing
Discount
FNA
Table 2 = tblVisits
have these fields:
VisitID
Customer_Number (same as the one in table 1)
Date
Total
Paied
Closed
Doc_Clear
now I want to make DataReport to put all fields in table 1 in text boxes in the report and get Total and Paied from table 2 for each customer number in the report
I mean all data in table 1 + total and paied fields from table 2
i tried this query:
"SELECT b.*, v.* FROM tblBreakDown b INNER JOIN tblVisits ON b.Customer_Number = v.Customer_Number"
is it correct ?
and how to make the report what code should be ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|