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

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

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