A
Amar
Sir,
I have two table PayMaster and Pay Details,.We don't
have any primary key between because of composite primary
key. So most the fields are unique key.
we have relation between two tables.
Now I am creating a report in VB, where i am showing
the report such that For each particular order, show all
the paydetails, but we want to show bal of each particular
order and these is present in paymaster.
Database structure is
PayMaster
OrdNo Text
CustId Text
PayMode Text
Amount Number
Bal Number
PayDetails
Payid Text
OrdNo Text
CustId Text
PayMode Text
Date Text
Amount Number
ChkNo Number
A sample report is over here
ordno custid paymode date amt chequeno
O00001 A00001 cash 11/03 10 -
O00001 A00001 cheque 11/03 100 1111312
Bal 200
O00002 A00001 cash 11/03 500 -
O00002 A00001 cash 11/03 100 -
Bal 10
Sir, how to do and how to create function in access 2000.
Pls give me the syntax
I have two table PayMaster and Pay Details,.We don't
have any primary key between because of composite primary
key. So most the fields are unique key.
we have relation between two tables.
Now I am creating a report in VB, where i am showing
the report such that For each particular order, show all
the paydetails, but we want to show bal of each particular
order and these is present in paymaster.
Database structure is
PayMaster
OrdNo Text
CustId Text
PayMode Text
Amount Number
Bal Number
PayDetails
Payid Text
OrdNo Text
CustId Text
PayMode Text
Date Text
Amount Number
ChkNo Number
A sample report is over here
ordno custid paymode date amt chequeno
O00001 A00001 cash 11/03 10 -
O00001 A00001 cheque 11/03 100 1111312
Bal 200
O00002 A00001 cash 11/03 500 -
O00002 A00001 cash 11/03 100 -
Bal 10
Sir, how to do and how to create function in access 2000.
Pls give me the syntax