Search results

Thank you all.

Thank you for your reply. The setting is on Text and the Account is a 9-digit number. It's not a SSN or TIN (I don't know what TIN is). Thank you, AccessNewby

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...

Thank you both:)

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...

Thank you for your suggestion. It took me forever to understand what you were saying but I got it now. thanks.

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...

I've just revised my form. Please see attachment, it makes much more sense this time. Ideally, I would like to form to have two columns (one column for Volume and one column for dollar amount) for some reason the cells were not aligned correctly on the form. parameters for Begin date and End...

Thank you for your reply. Please see the attachment. I'm very close to having what I want. I created a parameter query, where it allows me to select the start date and the end date, and i'm in the process of creating a form for this query. I don't know what I need to do to get the numbers to...

Thank you for your assistance. I was looking for something a little different where a user can select a date parameters and it would calculate the sum within that date range. Thank you again. :)

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...

Sorry for the late reply, I was under the weather. Thank you RAK and Matt for your suggestions. I'll give it a run. Attached are an Access and Excel files. I am trying to find the most efficient way of transferring cells C2, C3, C4, C5 and c13, C14, c15, c16 from Excel to Access FedReceipt...

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...

Mich..Please do not work over Christmas holiday on my account. Enjoy your Christmas with your friends and families:) My project is not that urgent. I'm trying to study Access and VBA online as much as possible so don't inconvenience anyone. Anytime you need R&R and in Atlanta..you can stay...

I attached a blank DB for you but don't you need to keep the Historical table in there for the Summary info? I'll trust you since I don't know what I'm doing. Thank you for your time:) AccessNewby:

Unfortunately these offices are not in the same building nor on the same server. Can I create a form template that links to the Historical data so when I copy and paste the information from these offices to the template it would transfer over to the Historical table? What is a "delimiter"...

Thank you Mick for taking time out to assist me. The data is sent in a text file in a table and all the offices use the same format. Please see attachment. The only data that I need to extract from this text file is the volume and amount (A & B) and the date. How can this data be imported...

Thank you so much for taking your time to reply. I don't think I explained my objective clearly in my previous post so let me try again. I just created my first table called Historical data (see attached). Each weekday, I get numerous emails from different offices reporting their volume...

Please review attachment. Tab 1 (Form A) is a System data form and Tab 2 (Form B) is a Office data form (there are 7 different offices). The objective is to be able to copy and paste these forms to a template, where the data will automatically be added into a summary sheet based on volume and...

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...