Help with doing calculations on query

[Teo]

i'm having 2 huge issues with this database in access i am making. its' a
boat rental database. and i'm trying to create a query that will calculate
the cost of the database based on the number of days the person had the
boat. so basically i would use the field names of day rented and day
returned. so the difference between those days times the cost of renting the
boat per day.so basically how do i create this calculation in the query.

the other issue i have is when i create a form using wizard, if the field
names are long it just makes the form look messy, is there a way to autosize
all of them so i don't have to fix each and every long field to fit on every
form?

Thanks much in advance,

Teo

 

[Roxie Aho]

1. Try Expr1: DateDiff("d",[Start],[Stop])
2. Go to the Format properties, select all the controls
you want to resize and type in the size you want.
2. In Access 2000 and later (don't remember if it's
available in Access 97), once you've selected the
controls, use Size on the Format menu.
2. I know three ways to select a group of controls.
First, hold down the shift key and click on each control
you want. Second, if if works with your form design, is
to click and drag in the vertical or horizontal ruler.
Third, hold the left mouse button down and draw a box
around the controls you want.
Roxie Aho

 

[John Vinson]

i'm having 2 huge issues with this database in access i am making. its' a
boat rental database. and i'm trying to create a query that will calculate
the cost of the database based on the number of days the person had the
boat. so basically i would use the field names of day rented and day
returned. so the difference between those days times the cost of renting the
boat per day.so basically how do i create this calculation in the query.

the other issue i have is when i create a form using wizard, if the field
names are long it just makes the form look messy, is there a way to autosize
all of them so i don't have to fix each and every long field to fit on every
form?

Thanks much in advance,

Teo

Answered in microsoft.public.access. Please DON'T MULTIPOST! If you
want to post your message to more than one newsgroup, select them
carefully and put the two or three (no more!) newsgroup names on the
Newsgroups line so that the same message goes to all of them. This
helps the volunteers who can see if the question has already been
answered.