Using Buttons to Open Subforms

They don't appear in the table or the form.

At first I thought it was the form, so I made sure all the ettings were for 2 decimal places, and and standard.

Then, I went back to the table to make sure that I had correctly specified my settings, and I checked the value in table form, discovering that the decimals aren't there either.

Thanks.
 
in the table set the field size to decimal and the format to general number. how bout now?
 
Also make sure your field size is set to Double not Long Integer.

Integer and Long Integer is for storing whole numbers.
 
It appears to work when I changed it to double.

Any idea why it didn't work when I had the field size as decimal?
 
If you search for Field Size Property in Access Help, it will give you criteria on using different properties.
 
Okay, here is the next question.

All the data entry in the form is working perfectly (thanks to the expert help I received).

One of the things I'd like to track, both in the form, and in a report, is the % change in some of the figures from the previous week.

How complicated is that going to be?

I have 33 different sites reporting info. I can code each week to the facility name and date (my ID field: ABC01-01-01).

But, for example, with the field OVERTIMEHOURS, how can I compare the change from week to week?

Thanks.
 
Is the previous week the previous record or are there records in between?
 
No, there are records inbetween.

I COULD have a separate table for each site, but that would been 33 tables, and the query to join them would be a nightmare!

Thanks.
 
Off the top of my head, I'm thinking you could use a query to pull the current and previous weeks record. Then run your calculation from that data.
 
You may want to post any new questions to a new topic so others searching the site will be able to locate them easier.

Thanks.
 
So, two queries. One to find the data and one to do the calculations?

I can work on that.

Thanks!
 

Users who are viewing this thread

Back
Top Bottom