Search results

Hello, I was wondering if there was a way to create an automated report that would detect and identify incorrect formulas in a column. For example, I have a column about 300 rows long that should have the exact same formula except for the first variable. I have about 20 of these rows, and...

Thanks Brian! I will let you know how it works out.

Hello, I have zero knowledge about macros or even where to start with them, so I am hoping that this problem can be solved within the set of available Excel functions. I have 300 sales reps. Each one has been in there position for a different length of time. I want to sum there monthly...

Vonnie: If you open the table instead, you can use the gotorecord method with the docmd object

Hello All: I have a command button that prints a report to a pdf file. rather than having to rename the file each time, I want to pickup a field from the report and have it used as the file name. Is this possible? Yes...I am a novice.

Rich: I thought VLOOKUP needed a sorted lookup column as well, though I have seen several examples where it as worked without being sorted. Good point on being able to use any column with the INDEX / MATCH. Thanks for the reply!

I have used both these functions extensivley, but I cannnot see a benefit of using one over the other. Does anyone know the relative strengths and weaknesses of these two lookup options?

Brian: My expectation is that the reference would be relative. For example, if I sort a group of records that use the vlookup function, the reference to the source cell will change. With SUMIF and SUMPRODUCT it will act like an absolute reference. One way around it is to sort only the...

I have found that, if I am compiling data using the SUMIF or SUMPRODUCT functions, and I sort my records, the function continues to reference the original cell reference. For example, if I use a referenced cell to fill the CRITERIA requirement, it will continue to use this same cell even after...

When I do a find and replace, the excel window flashes or cycles as the replacement are made. Does anyone have an idea why? It can be a real time sink as it can take 5 or 10 second to complete.

I wasn't sure how inline insert, so I attached.

I tried a union query between the twelve monthly tables...ended up with a non-responsive Access and a 'page-file' error. Then I tried appending each monthly table to a single table and got an 'invalid function' error...database had 2 gig. The approach I am taking now is to link to the tables...

WayPay: I tried all of your suggestions, but my computer (I guess) can't handle it!

Good Gawd! Its been running for twenty minutes! Is this to be expected?

I am thinking one table because (supposedly) we never delete customer information. I could append each month reducing duplication and space. Thanks for your help, by the way. It certainly has me thinking.

Thanks Len. I will certainly give this a go, once I have a moment. I have concerns about a single table approach as there are already 65,000 customer records at the end of 2006. In a single month there are 100,000 invoices. Do you think Access can handle it?

Hello, I have 36 Access databases containing 2 tables each. One table contains invoice information the other the customer information. There is one Access database file (.mdb) for each month starting in 2006. The two table are identical in structure across the months. The customer table...