calculating date

I'm suppose to create a list of 20 clients and let 5 accounts be 90 days past due, 5 over 60 days, 5 over 30 days three of each of the accounts have a balance over $75. Then it asks me to create a total of all account balances so that the total amount of recievables can be known. The second part is calculate the number of days each balance has been outstanding.My question is this can you calculate dates in a table or can you only calculate in a query. I'm new at access so have patience with my question(s)

Bascially speaking, you store data in a table, you manipulate it in a query, display it in a form and print it in a report (there are variations on this but it will get you started). So you need a query that does the calculation.

Use Date() to get you the current date and use DateDiff() to calculate the difference between the invoice date and the current date.

So what you are saying create fields in the table for example:

client name balance due date
john ham $75.00 4/17/07
betty $100.00 5/13/07

Fill in the data in the table, then create queries to do the various calculations needed.

Yes.

By the way, it's bad practice to include spaces or punctuation in object names. So 'DueDate' is preferred to 'due date'.