Recent content by davey4444

Hi, it seems to be working perfectly with my data so far - I'll run a few more checks but so far, so good. I've tried to take this query further by being selective on the Product description to only perform the calculation when that Product description contains the word "Box" Test: (SELECT...

This looks great - I'll try it tomorrow. Thanks!

Hi, thanks for your reply. I've attached a very small set of sample data, as you can see, the records in rows 1,3-6 are all the first time that this machine has produced that type of product on that shift on that day. The detail in row 2 is 0 because that machine has already produced that...

Hello. I have a db which shows the following columns - Machine Number | Shift Date | Shift Name | Product I want to add another column which will show "1" for the first record when each machine produces a certain product wildcard name (named "Box*") per shift (AM or PM). Therefore, it's not...

This is brilliant, thank you.

Sorry, I mean the difference in the total Quantity, Sales and Margin for each factory in each month in TBL_Sales vs the total for those values in TBL_Finance. The value in TBL_Finance will always be on one row per month per factory whereas TBL_Sales will show lots of values. In my first row of...

Hi there, I am using data from a sales and a finance system and essentially need to understand the difference between them and account for this "balancing" row. My data is as follows TBL_Sales Month, Product_Type, Factory, Quantity, Sales, Margin January, A, F123, 100, 1000, 10 January, A...

Thanks all, it worked perfectly using IIF once I'd figured out my joins.

Thanks for the quick reply, what you've said makes sense although I am slightly stuck in my Excel ways of thinking about things which doesn't help. I tried your example but it couldn't quite work, here's some sample data - TBL_Sales Factory, Customer_ID, Customer_Name, Volume London, 123...

Apologies if my terminology isn't quite correct - I'm just starting to use Access but hopefully this request will make sense. I have a table with sales in (TBL_Sales) as well as another (TBL_Key_Customers) which lists information about specific customers, in particular if they are part of a...