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...