Writing calculated data from form to table

[Keith Glover]

Hi Guys, I don't know Access very well but I know enough to generate a 2 dimensional database. The problem I have is that I have been asked to look at a travel agents database to create some additional letters. The problem is that they use a form which has an underlying data table called customers. When they create a record in the form all fields in the customers table are filled in except those on the form which derive their data by calculating two or more fields i.e Date Due is [Date of Travel]-70 (days), Balance Owing is [Cost]-[Deposit]. None of these derived fields fill in their corresponding fields in the customers data sheet.

I would welcome any ideas please. Thanks in anticipation

PompeyFC

 

[neileg]

Forms should be based on queries, not tables. You can add calculated fields to your query for DateDue BalanceOwing, etc. These fields are then available to show on your form.

You should not store this data in your table as you can easily calculate it anytime you need it.

 

[Keith Glover]

Thanks Neil

I am not sure I am completely up to speed on using Querys for Forms rather than Tables but I'll work on that one. Thanks a lot

Pompey FC

 

[neileg]

Anywhere you can use a table you can use a query. The form wizard allows you to choose tablkes or queries. It is good practice to use a query even if the data is simply a straight lift from the table as it makes subsequent modification so much easier. In any event, when you are viewing a table in Access, you aren't seeing the raw data anyway. All of the formatting done at a table level is effected by Access showing you a query based on the table!