Search results

Hello All, I've got a query that is supposed to bring 2 tables together. I have the same date field in both tables that is linked together and then brings back a figure that relates to the date. I need a formula that says that if there is no date that matches then look to the most recent...

Hi, I want my query to find the cumulative forecast up until a best before date. This is fine if a forecast goes past the best before date as the query picks it out but if the forecast doesn't continue then it won't match them up. I need the IF statement to say that IF no forecast is...

Hola, As a bit of background, I work in Supply Chain and I'm editing a database that's an ex-employee's invention. I have a file thats imported in the database using a macro. The way I see the macro is that it does the following; Imports the new file into a temp file Deletes the current...

Hi, In my new job I've inherited an Access 2000 database that appears to have developed some issues while nobody was looking after it. For the first 18 weeks of our FY this report was running correctly but then for some reason started throwing out 2 errors. The first is when we run a...

Hi, I'm at a reasonably good level in Excel and other packages. Having started a new job I'm now needing to expand more into Access. I'm guessing I'll be using this site as a learning tool but also willing to help others out where I can. Thank you in advance for any help you may provide in...