Search results

Thank you! I have a query with all the date already. MajP's solution was what I was after and was able to get rid of several queries and subs.

Thank you so much! That helped a bunch!

I have an employee database that I am making and need a little help. Right now I have separate queries for Vacation Eligible, Benefits Eligible, and Birthdays pulling this month and next month for a total of 6 queries. Each query has Employee Status, EmployeeID, Employee Name and the...

Thanks for your input.

I will have to give it some thought. I enter the sheets as they come in so Driver B might get theirs turned in before Driver A. I love what Access can do but at the same time I wish it could be as simple as Excel sometimes. Thank you again for all your help!

Thank you! The only issue I am seeing is that sometimes there is more than one driver for a truck on the same date so they turn in 2 sheets that is why it is pulling up a difference. Not sure how I would fix that or if it would even be possible.

I apologize, I did not realize the data would not be able to be seen.

Here is the Main Database

The table with the data is in that database under IFTA Sheet. Yes, it was a lot of work and my Access knowledge is fairly basic. It seemed easier for me to do a query for each truck once rather than having to supply a bunch of parameters each time.

I have seen that when I have tried to search for my answer but unsure how to use DLookup(). Could you possibly send me an example of what it might look like using the field names I have provided?

I have a database that I have created for my job to track daily fuel and mileage for 60+ pieces of equipment. On my main table I have RecordID, Quarter, Date, Branch, Truck #, Begining Odometer, Ending Odometer and a calculated field for Daily Total Miles. I then linked that database to a new...

I forgot to mention that during the setup I selected the ID column be hidden. So I actually have 3 columns and I would like to be able to search either of the remaining columns to autofill my field.

Hi all! I have a combo box with 2 columns, Item # and the Item Description. As of right now I have to type the Item # and it will autofill the text. I was wondering if there is a way if I don't have the Item # that I can search/type the description in the combo box field and it will...

I am probably do this all wrong, I kept getting an error. Do I need to put this exactly how it is right here or do I need to add my information somewhere? const cQuote="""" me!Control.DefaultValue = cQuote & me!Control.Value & cQuote

I apologize if this has been answered already. I have been searching all day for a solution. :banghead: This is my first time using Access so a lot of this goes over my head. I'm currently running Access2010. I have a form that I am using for when people take office supplies and we can...