T
tektrader78
hi everyone,
Ive got a problem in access after migrating data from excel sheets
that were in a flat format.
I have a table called tblstatus that has over 10 status and counting.
Another table that has each account number having 10 status fields and
a respective date column.
The last table of course is for general information on the acount.
I would like to know how to setup a qry or how to run a report that
can pull the current status of any given account if say they are on
the third status, say pending.
When i pull a status it drags all the accounts and its difficult to
know the current status unlike the old method.
any input will be greatly appreciated.
Old database format:
| acct# | status | newdate | pendingdate | paiddate |etc
0001 new 1/1/03 1/1/03 1/1/03
0002 pending 1/1/03 1/1/03 1/1/03
0003 paid 1/1/03 1/1/03 1/1/03
In the old format, the status was manually changed to its current
status.
Ive got a problem in access after migrating data from excel sheets
that were in a flat format.
I have a table called tblstatus that has over 10 status and counting.
Another table that has each account number having 10 status fields and
a respective date column.
The last table of course is for general information on the acount.
I would like to know how to setup a qry or how to run a report that
can pull the current status of any given account if say they are on
the third status, say pending.
When i pull a status it drags all the accounts and its difficult to
know the current status unlike the old method.
any input will be greatly appreciated.
Old database format:
| acct# | status | newdate | pendingdate | paiddate |etc
0001 new 1/1/03 1/1/03 1/1/03
0002 pending 1/1/03 1/1/03 1/1/03
0003 paid 1/1/03 1/1/03 1/1/03
In the old format, the status was manually changed to its current
status.