Search results

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

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

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