Search results

Spoke too Soon Looks like I spoke too soon...when I try to run the report for an individual month, it does not give me the counts I need for that month, but instead gives me a total count of everything entered thus far. How can I make this only give me a count for the month I am looking for...

Thanks for the help Wayne, Thanks for your help. It turns out I was not too far off track. I slightly modified one of my queries for the individual fields to include a piece of your response and it worked. I am going to include what I did here in case anyone else is having a similar problem...

I am somewhat new to Access and I have a problem. I would like to input a starting date and an ending date and have my query give me a count of records for a few fields for work done between those dates. This is like a monthly report kind of thing. I have created independant queries that give me...

I have a form that users enter information in that updates a block of records. I would like to clear all the fields after the query runs and updates the records so that another block of records can be updated without having to close the form or erase the fields one by one. Can anyone help with this?

jwindon...What you gave me ALMOST did the trick. I had to tweak it a little but it updats every field perfectly except one. I have a checkbox field that designated the records as ACTIVE or in other words, in use. The unbound field I setup for that does not transfer the value to the...

You said in your response that you did not understand why I wanted to do it THAT way? Is there something easier? I work for an engineering firm that assigns numbers to individual project sheets. Those numbers are my unique record numbers in my database. So when I am adding a new project, which...

OK the best way to describe what I want to do is Step by step I want to create a Form that a user can populate with information for a new job. This form should have all the fields that are contained in a Master Table. The user then puts in a starting record number and an ending record number...