Search results for query: *

my db is for equipment certification. I'm trying to figure out how to do the following: I have a date field when employees are certified on equipment. I want to create a variable date field for when their certification expires. 1 year (365 days) after the initial certification date. ie Cert date...

How do I generate a report that will display all 3 colums with results using a combo box? I only get the option of placing results in one of the colums?

I'm trying to set up a db for employee counseling that will have multiple choices for a field. example data field answer Work Attitude Below Average Above Gets along with peers Below Average Above Professionalism Below Average...

I'm trying to set up a db for employee counseling that will have multiple choices for a field. example data field answer Work Attitude Below Average Above Gets along with peers Below Average Above Professionalism Below Average...

I have a report that has two groups in it. I'm trying to get a report that will only print the total for a curency field for each group. The problem that I have is that if a group only has one record in it, they print one group after the other. If there is more than one record, blank lines are...

Thanks for the input everyone, someone has suggested a solution that works fine and I thought you may want to see it. In the criteria box, for your date in the query, type Between [Enter 1st date] and [Enter last date] or Between #1/1/02# and #12/02/02#

I have a report that has two groups in it. I' trying to get a report that will only print the total for a curency field for each group. The problem that I have is that if a group only has one record in it, they print one group after the other. ti there is more than one record, blank lines are...

I'M TRYING TO PERFORM A QUERY ON A (SHORT)DATE FIELD WITH AN INPUT MASK OF 99/99/0000;0;_. THIS IS WHAT I HAVE IN THE DATE FIELD AS CRITERIA >&quot;«Expr»&quot;=#12/1/2002# And <=#12/5/2002# I GET A DATA TYPE MISMATCH IN CRITERIA EXPRESSION ERROR HOW DO I PERFORM A QUERY USING A SHORT DATE...

THE QUERY IS PERFORMED IN A STANDARD QUERY USING THE SYSTEM DEFINED SHORT DATE. I AM ENTERING THE INFO IN THE CRITERIA SECTION OF THE DATE FIELD. THANKS, NETHROW

I'M TRYING TO PERFORM A QUERY ON A (SHORT)DATE FIELD WITH AN INPUT MASK OF 99/99/0000;0;_. THIS IS WHAT I HAVE IN THE DATE FIELD AS CRITERIA >&quot;«Expr»&quot;=#12/1/2002# And <=#12/5/2002# I GET A DATA TYPE MISMATCH IN CRITERIA EXPRESSION ERROR HOW DO I PERFORM A QUERY USING A SHORT DATE...

My table has several check boxes in it. In the query totals I have COUNT as my operator but it counts every record in my table, How do i get it to only count Boxes that are checked?

I'm new to access so please reply in detail. My data base is setup with several check boxes. How do I sum the values of these check boxes and display only the totals in a report? Can this be done without using a pivot table? Thanks, Nethrow