PrinceHairy
New Member
- Joined
- Apr 28, 2015
- Messages
- 10
Hi all,
I have the following databases (a sample) and am trying to obtain a summary query from these:
Sales:
<tbody>
</tbody>
Inventory:
<tbody>
</tbody>
This is what my query should look like:
<tbody>
</tbody>
However, I suspect because I'm trying to obtain the sum of some calculated fields, it's outputting some astronomical values:
<tbody>
</tbody>
I suspect the way to fix this would be via using a SQL query instead of the query design - any ideas?
I have the following databases (a sample) and am trying to obtain a summary query from these:
Sales:
Date | Product | Colour | Qty. Sold |
16/03/14 | Ball | Yellow | 4 |
17/03/14 | Racket | White | 3 |
19/03/14 | Racket | Blue | 7 |
20/03/14 | Ball | Red | 5 |
20/03/14 | Racket | White | 1 |
22/03/14 | Ball | Red | 1 |
<tbody>
</tbody>
Inventory:
Product | Colour | SOH as at end of trade 31/12/2013 |
Ball | Yellow | 7 |
Ball | Red | 6 |
Racket | White | 4 |
Racket | Blue | 8 |
<tbody>
</tbody>
This is what my query should look like:
Product | SOH at end of 2013 | Quantity Sold | Current SOH |
Ball | 13 | 10 | 3 |
Racket | 12 | 11 | 1 |
<tbody>
</tbody>
However, I suspect because I'm trying to obtain the sum of some calculated fields, it's outputting some astronomical values:
Product | SOH at end of 2013 | Quantity Sold | Current SOH |
Ball | 78 | 42 | 36 |
Racket | 72 | 42 | 30 |
<tbody>
</tbody>
I suspect the way to fix this would be via using a SQL query instead of the query design - any ideas?