Recent content by CHaythorne

Okay no problem, I've copied it to my laptop to take home now and I'll strip it down in a few hours and send it on. Email or is there a way to post it on here? Many thanks.

It's 175mb so I doubt it or did you mean a screenshot?

I've tried using the following and it has doesn't return what's required. Q_Residual_ShelfLife_Positive: DMax("[W/E]","T_ODP_CumulativeForecast","[W/E]<=#" & [Q_Residual_ShelfLife_Positive].[W/E Despatch Date] & "#") It seems to return a random date. With regards to a unique entry, I...

You've made me think about this a little bit deeper now and you're right the dates do occur more than once as it's by sales channel (e.g commercial, internet, retail etc.) but there's a column at the end of each row that's adding all of these together so no matter which occurence of the date it...

Hi, Apologies for the delay. Yes Billmeye, that's correct. Basically every item has a forecast and every item has a best before date. I have one table with the products and best before dates in and I have another table that creates a forecast by week with a column that creates a...

Thank you for that. There's always a date present they just sometimes don't match up as the forecast may finish before the best before date of the product. In this situation I wan't it to look for the last forecast that was present and take that away. Apologies if that isn't very clear...

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

Apologies again. I think you're right, something that I see everyday isn't that easy to convey to the outside world. All of our stock has a best before date. What we're trying to see is if there is enough forecast to consum the stock that we have. This will help us establish if there's any 'at...

Apologies for this not being clearer. I'm only just getting my head around it myself. I have two tables one with stock, the other that creates a cumulative forecast up until the forecast ends. This query is combining the two so that I can get stock and take the forecast off to see what stock...

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, Thank you for your help on this, I managed to solve the problem. I followed your advice and re-made the query and created the table. While I was doing this I noticed that some of the original data wasn't present in the table. This meant it was dividing numbers by 0. Could this have...

Thank you both for your help. I'll give this a shot later on. Cheers.

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