Search results

Hello, I'm very green with Access so please be patient with me. In my table, the Account column should be a 9 digit number. However, when I download the data from another application if any account has a prefix zero, it drops off, left me with 8 digit. When I try to match the account in two...

I am trying to create a query and my data source is from a "1st" query. My new query consists of two fields (Account number & Account Name) and I want to use this two fields as a combo box for my form layout. My issues is that one of the field from the "1st" query is the "Date" field and it...

I have the following columns in a query. I want to create another query using the data from this original query. My goal is to find the latest time for each endpoint for each company. There are two deadlines..a 9:30 AM and a 9:50 AM so any time after 9:50 would be considered "Late", any time...

Thank you for viewing my post. Please see attachment. I have a historical data table and I'm trying to create a form that based on my selection of dates it will return a summary for each category. When I created a query it's not in a nice format and when I created in form i'm not able to...

Greetings- Thank you for viewing my question. I hope you can assist:) I have an Excel spreadsheet that certain cells contain data that I would like to import to Access database. I know how to import/link features but I don't know how do I get it to go to a specific column. How can I map that...

This is my first project using Access so take it easy on me. I'm trying to convert the Excel application to Access since I think Access is more flexible/powerful. I'm not sure if this requires programming (VBA-over my head) or just need some complex formulas to get the mission accomplished...