Use INDIRECT function It basically lets you use it in VLOOKUP to point to a cell which can have a formula to generate the filename... "mdhodgson" wrote: Hello, I need a vlookup pathname to be found in a cell. Is this possible? for instance: =vlookup(a2, " value found in another cell " , 2,false). The folder, tab, cells are always the same. The only varience is the workbook
Hello all, I have a report question. I have the assignment to check if the numbers on the quarterly reports add up to the year end report. Sounds simple enough right? the problem is is that the data comes in in the format: Revenue Q1, 2000 Q2, 2000 Q3, 3000 Q4, 4000 Year 5000 I want to design a report that is like: Revenue Q1 2000 Q2 2000 Q3 3000 Q4 4000
Instead of running DoCmd.RunSql sqlString try CurrentDB.execute sqlstring This should avoid confirmation of the actions you are trying to perform. Keep in mind though that if the sql-statement doesn't run correctly the data isn't getting inserted. See if that helps. -- Maurice Ausum "Timothy Reza" wrote: I have a series of tables that I am using to get data from and dynamically
Albania , greece ,bulgaria , hungary , Ireland , poland , portugal all have 220 volt supplies , the old check republic still runs some areas at 120 volts The EU have 'standardised' all voltages within the EU at 230 volts however they allow a -10 %% to a +6%% varience to accomadate all the countries at present that means the voltages can be as low as 207 volts or as high as 243.8 All
