Search results

Here it is Here it is ...

Thanks Great, thanks for the offer. Due to file size restrictions, would you accept this zipped xls data ?

Thanks Great, thanks for the offer. Stripped down and zipped mdb attached

STUCK!!!! OK, I am really stuck, and I need some help. Please find my problem here If it makes sense, I would appreciate a reponse from one of ypou experts. Cheers all

Ta Thanks for that I'll have a look at using cross-tab, its probably the only thing I didn't look at yesterday ;-) The field is updated using a simple 'update table' query ... [UPDATE [Tier 1 Accounts] SET [Tier 1 Accounts].RPA = "R1" WHERE ((([Tier 1 Accounts].[2003 Billed])>300000) AND...

OK, firstly I feel so dumb for needing to ask this ... but here goes .... I have 1 table - one field inside that table is dynamic depending on other fields in the table, but thats updated easily *one point to me* The dynamic field can be set to one of nine indicators (R1, R2, R3, P1, P2, P3...