Search results

I have three fields in a form. "Starting Miles", "Ending Miles", and "Total Miles" I want the "Total Miles" field to automatically calculate the difference between Starting/Ending miles fields. So if starting miles is 2000 and ending miles is 2200 I want the total miles to list 200. Thanks.

Thanks pbaldy. I have just modified the database so that all D.O.B fields in the database contain atleast 6-digits (e.g. 71562 is 071562, or mmddyy) How would I go about applying the format I need (07/15/62) to each record at this point? Thanks again.

I have an old table that has many, many records. One of the columns lists the Date of Birth. Here's my problem: Users have entered data into this column as "71462" This representing July 14, 1962. Is there a way to automatically format all data in this column so that it is more palatable -...

Odin, thanks again, worked perfectly. Here is my final question! How would I be able to round the number to the nearest fourth of an hour? For example: If I enter "4:30 PM" as arrival time, and "4:50 PM" as departure, it automatically lists ".33" as the hours. Although this is correct, we...

Thank you odin! That worked perfectly. I have one quick question though. How can I limit the number of numbers listed in the Hours field? For instance, I put 3:00 PM as arrival and 4:20 PM as departure, and it lists 1.33333333333 as the hours. I just want to display 1.33. Thanks a ton.

Hi guys. Could someone tell me how I would go about adding a form field in my form that will automate a number based on two other form fields? To be specific, I have a form that requests Employees add in their arrival time and departure time for a particular job. For instance, If they add 4:00...

I checked - It's not. I should say that the page is not entirely blank, the template I created in design view is there, its just that there is no data being shown.

Hello, I am new to this forum and have a problem. I have a simple one table/one report database in Access. When I view the report, all data shows up on every page except there is one in the middle that is completely blank - I looked at my table to ensure that I didn't leave any empty rows, and...