Link to home
Start Free TrialLog in
Avatar of Murphy1992
Murphy1992

asked on

Access 2010 - Data Not Linked

Using Access 2010 with Windows 7.

I am a total novice with Access.

I have created a table to collect receipt information - RECEIPT.  i.e. date, autonumbering, amount, cust name, tran type, job no., charge reason, surcharge and total amount.

I have some data that can either be extracted via ODBC to Pervasive database or via data linked to existing 2010 Excel spreadsheet.
The only linkage between the two table can be the job no.  That said there is no Job number info within the RECEIPT table until the user selects the assigned Job no.  With this selection I'd like the cust name and xs value to be displayed.

For some reason when the job number is selected neither the name or the xs value is displayed.

I'm positive a super basic problem but I appreciate some assistance.

I would also like to convert total value to words - e.g. $425 - FOUR HUNDRED AND TWENTY FIVE DOLLARS ONLY appreciate thoughts on this too.

Thanks
SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murphy1992
Murphy1992

ASKER

Thanks, will give both a try and let you know before I close out question.