Using Buttons to Open Subforms

[JeepsR4Mud]

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.

 

[Pathetique]

in the table set the field size to decimal and the format to general number. how bout now?

 

[skwilliams]

Also make sure your field size is set to Double not Long Integer.

Integer and Long Integer is for storing whole numbers.

 

[JeepsR4Mud]

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?

 

[skwilliams]

If you search for Field Size Property in Access Help, it will give you criteria on using different properties.

 

[JeepsR4Mud]

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.

 

[skwilliams]

Is the previous week the previous record or are there records in between?

 

[JeepsR4Mud]

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.

 

[skwilliams]

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.

 

[skwilliams]

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.

 

[JeepsR4Mud]

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

I can work on that.

Thanks!