Recent content by ShogunPatch

Minty I don't really follow the code but it looks like it seems to be working (I need to find time to manually slice and dice my data in Excel to double check); so thanks for that. Now I just need to work out how to cross reference the output... :confused:

Hhmmm... It may be simple, but I've tried what you suggest and it doesn't work. This implies one of two obvious conclusions: I'm too dim to understand your simple instructions (not impossible) In providing my simplified example I haven't properly reflected the reality of how my data is...

Well actually, I'm not doing either. The data in my table is uploaded from a set of accounts provided by a client which includes both component parts and totals (and various subtotals, etc). I just receive the accounts in PDF, convert the whole lot to Excel and then upload it into the...

D'oh!! OK, I worked out how to attach a sample table in Excel...

Sorry, my example above does read very clearly as I haven't worked out how to layout tables...

Hi Tieval, thanks for showing interest in my question. I imagine there is probably a way to paste table extracts into here but I haven't worked out what that is yet, so in the interest of expediency I've written out a sample below, which I hope clarifies what I mean. My source table currently...

Access newbie here; please be patient (and gentle!). I have a working but clunky spreadsheet which I am trying to rebuild as a database. In one of my tables I have the following fields (amongst others): ID, Schedule, Label, Value, Denominator The Denominator field contains a Schedule and...

Hi there I'm Patch, from London (UK - not Ontario!). I'm somewhat of an Access newbie: although I first dabbled with Access97 many, many years ago, teaching myself from a book I've not really used it much since. I'm pretty good at, and have built a number of 'systems' with, MS Excel but some...