illusionek
Registered User.
- Local time
- Yesterday, 22:56
- Joined
- Dec 31, 2013
- Messages
- 92
I knew I was missing a simple trick here It worked like a charm.
I have done a subquery and applied iif statment and it worked!
On a different note, I ended up with a query where I make all these various calculations like OpeningStock, ClosingStock, PlannedProduction etc so in total have quite few columns with calculations.
It looks a lot like Excel now when I run this query, so I was wondering if I go wrong somewhere along the line or this is normal. I understand I should not store calculations in queries but was wondering if I should make one query per calculation or it is fine to keep all of them in one query?
I have done a subquery and applied iif statment and it worked!
On a different note, I ended up with a query where I make all these various calculations like OpeningStock, ClosingStock, PlannedProduction etc so in total have quite few columns with calculations.
It looks a lot like Excel now when I run this query, so I was wondering if I go wrong somewhere along the line or this is normal. I understand I should not store calculations in queries but was wondering if I should make one query per calculation or it is fine to keep all of them in one query?