Search results

Sorry to bring up an old thread but it seemed more relevant than starting a new one.... mainly add my 2p, as I worked with a few different ideas and came up with this little function: Public Sub acU_RelinkTables(ByVal OldBasePath As String, ByVal NewBasePath As String) 'v1.00 2013-12-04 14:13...

now solved, see other thread linked above It was caused by a table relationship, multiplying the sum result for each Category by the number of times that Category appeared in the lookup table

I couldn't find a suitable upload site, so sorry, I've cross-posted to another forum that allows attachments, you might have to register there to view the attachments. www .utteraccess.com/ forum/Crosstab-Sums-Incorrect-t2012120.html

Tricky... the base data is about 800MB :-) I'll try screenshots, need to find a reliable upload service from work..... proxy annoyance... hang fire a few mins

Well, I've ruled out the order of Row Headings... makes no difference, still totals incorrectly

If I've read this correctly, I think the short answer is no.... I'm a little confused by how you expect to police this, unles it's only you who will be accessing the confidential information? If so, I guess you just don't want to work out which query to use? The long answer is yes, as per...

*solved* Crosstab query problem: Sum is actually Sum*Count? (Access 2010) My source data (from Cognos) shows separate Charge Code entries on each row, Grouped By Shipment, Invoice, Account Number and Charge Code. I first use an aggregate query that groups the Charge Codes amounts by Shipment...

I'm having very similar issues trying to automate in VBA (Office 2010, not SP1, installed around April this year, so that's my first thing to try). In my case I run a macro on Workbook.Open that updates all pivots, then on Workbook.Close saves the workbook as an .xlsm to a temp folder, then...

Greetings all, some of you may recognise my username from Stackoverflow or other such places... I'm here mainly to tell Galaxiom that I've had the same issue with saving Excel 2010 files. Not exactly Access related but still. I'm a moderate-to-heavy Access user, all basic stuff though, my...