Search results

Hi wondering if anyone can help me unpick where this mismatch is occuring? I am trying to unpick an access database that someone else has built :banghead: The SQL for the qry is: SELECT 2014 AS FinancialYr, qry_Union_ExportW1.CostCentre, qry_Union_ExportW1.Subjective...

Yes, thats the right formula. Ah-i thought it would still put the formula in, even if it was a 'dodgy' formula. I will try your suggestion when i get to work tomorrow. Thanks very much!! :)

Ah just realised i typed formula wrong. It should start =if(isna... However that shouldnt affect it-i go back into the spreadsheet fter the code has run and there is no formula at all in the cell-its an empty cell?!

Hey Wondering if anyone can tellme why this isnt working? I'm trying to update cell"BT14" within a worksheet called"Master Costing"with a lookup formula. The code appears to run but when I open the file, there is nothing in the cell. V annoying: Sub FormulaCorrection() Dim LastColumn As...

Hi bob, I tried the code exactly as you put it and did the getdateval and it runs the query but it doesn't bring back any data - the column is blank :( Any ideas?

Hello - thanks for the responses - much appreciated. I had done the same formula as Alan and it still says too complex. Just tried Bob's code and it processes but the result is a blank. Am I supposed to change the code so it identifies where the "2012" is as the start? If so - where do I...

Hello, I'm relavtively new to databases but after a steep learning curve (being left with many databases created by my old manager with no instructions on use) I'm getting there. Got a problem at the minute though and hoping someone can help. Been :banghead: for the last 60-90mins! What I...