Need some general access help please.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I am fairly novice at access but i am trying to make a simple database
for my law firm.
This data base will be a way for me to calculate and total up client's usage
of postage and copies. So far i have made 2 tables, one with the client's
name and another with 3 fields, client, postage and copies. I have them
linked with the client field.

In my form i am trying to make a section for postage and copies, where i can
put in the amount of postage/copies, another field for the price of each, and
a total field that calculates postage multiplied by the price of each and
copies multiplied by the price of each.

I am stuck at getting the total of each item stored into the table so at the
end of the month i can pull up a report and charge the clients for the total
usage of copies and postage.

I can email a copy of my database if anyone is willing to help me out. It
would be much appreciated.

Thanks,
Zoltan
 
Zoltan said:
Hello, I am fairly novice at access but i am trying to make a simple database
for my law firm.
This data base will be a way for me to calculate and total up client's usage
of postage and copies. So far i have made 2 tables, one with the client's
name and another with 3 fields, client, postage and copies. I have them
linked with the client field.

In my form i am trying to make a section for postage and copies, where i can
put in the amount of postage/copies, another field for the price of each, and
a total field that calculates postage multiplied by the price of each and
copies multiplied by the price of each.

I am stuck at getting the total of each item stored into the table so at the
end of the month i can pull up a report and charge the clients for the total
usage of copies and postage.

I can email a copy of my database if anyone is willing to help me out. It
would be much appreciated.
Click to expand...

You need not and should not store this value. Just calculate it whenever
you need it. The simplest way is to create a query based on your table
that includes the calculation as an additional field. Then just use the
query anyplace you need to see that total.
 
thanks for the help, i created a query that calculates my postage price *
postage amount based on the 2 fields in my form. Now how do i get this query
to display its results in the form?
 
Zoltan said:
thanks for the help, i created a query that calculates my postage price *
postage amount based on the 2 fields in my form. Now how do i get this query
to display its results in the form?
Click to expand...

You misunderstood me.

You have a table with fields [postage price] and [postage amount] and your
form is currently bound to this table. You create a query *based on the
table* that calculates the extended cost using the fields from the table.

Now you bind your form to the query instead of the table. Then you can add
a control to your form bound to the extended cost field in the query and
your form will display it.
 
Back
Top