what field to include in access from excel table?

Harrold

Registered User.
Local time
Today, 16:33
Joined
Mar 17, 2011
Messages
72
Hi

Attached is a file with the raw data i designed and pivot table is the info i required.

Can someone please advise me which filed should be included in table? Based on employee's request, the repayment amount for the whole instalment can be different for each month and the amount is agreed before inputting.

Hence i am a bit confused which one shall show in table and which one shall treated as calculated field by using query.

Thanks in advance
 

Attachments

Users who are viewing this thread

Back
Top Bottom