How do you use simple formulas in access?

A

Andrew Dale

Before I start please can any replies be put as simple as possible as I am
not too good with access. Cheers.

----------------------------------------------------------------------------------------------

I have a database with two tables. Cars and Bookings. In the cars database I
want to multiply the "Price" field by the "Days Hired" field from the
Bookings table. So I need to know how to multipliy bewteen 2 fields from
different tables.

This is to go into a report to produce an invoice.

*Just in case you need to know, the values from the "Price" field are from a
lookup table (Group Prices).*

----------------------------------------------------------------------------------------------

My second problem is that I need to produce a stats page with the most
rented cars.

So basically I need to findw hich model comes up the most times in the
"Bookings" table.

I assume I will need a similar formula to Excel's COUNT.
 
D

david epsom dot com dot au

On the report, click on a text field and display the properties
sheet. In the "Control Source" property, type
= [price] * [days hired]

Note: the "=" character is the first character you type. Spaces
" " are not required.

You can also put calculated fields into queries, type
Cost: [price] * [days hired]


To do this, the report or query must include both tables.
On the report, display the report properties field, select
the "record source" property, and click on the ellipsis "...".

In the query design window, select "view", "show tables",
and select both tables.

If you have defined a relationship between the two tables,
they will be automatically connected. If not, draw a connection
between the related fields in the two tables.


After you have done this, ask again about the "count".

(david)
 
Top