Search results

Thanks.....I was afraid it was going to have to be that way.

I have time sheets from the past I need to enter but have found that some years the time punch minutes are given as if an hour equals 100 minutes not 60. Other years the minutes are given correctly. How do I format this field so that if I type 3.75 it will convert to 3.45 hours? Will I have to...

It does appear to be the same problem.

We are pulling straight out of the query. It is easier for the comparison we are doing to view it in the datasheet view. I need to build it into the query itself.

Got It!!! Thank you so much!

I have a query where names are intered as a parameter but would like to use a drop down pick list to insure names are spelled correctly. Is there a way I can do this? :confused:

I have a database that tells me a name and what room was used among other data. I need to count how many times each room was used. As a newbie in Access I have been unable to solve this query. Could someone please help as to what I need to do to get an acurate count of numbers of times room was...