Dear boss:
I have a small problem:
I am programming with Access2000 VB6 ADO, output a customer-set-fledged statement
The desired format is as follows:
Customer Number: 12345 Customer Name Zhang 3
Setting number 00000001 Date: 2005/01/01 Price ¥ 5 Number of 10 ¥ 50
Setting number 00000002 Date: 2005/01/02 single price ¥ 15 Number 20 ¥ 300
Amount: 350
Customer number 23456. . .
. . .
The table used is Customer and OrderMaster
The fields include:
Customerid, Customername, OrderId ORDERDATE, Price, ORDERNUM, TOTAL..
My specified data source is: set rstrpt.source = "Select Customer.customerid, Customer.customerName, Ordermaster.Price, Ordermaster.Number, Ordermaster.total" & _
"From customer inner join ordermaster" & _
"On custom000.customerid = Ordermaster.customerid"
"Where ordermaster.customerid = customer.customerid"
SQL's syntax should be not wrong, compile is passed,
I made a group packet header in Data Report and put the customer ID and customer name.
Put the amount of the amount in the patch
But always show "report part and data source do not match"
I didn't use the data environment to "drag", I don't think it is faster, I don't know where it is wrong. Please enlighten your prawn. Thank you ~~! !
