opopanax666
Registered User.
- Local time
- Today, 00:57
- Joined
- Nov 2, 2006
- Messages
- 44
Hi everybody,
I guess the problem will take longer to explain than the solution:
Setting: I have a table listing all our products (tblProducten) and their default amount per package. For most this is "1", but some are "16" in a package...
This table is linked to a table listing our production (tblGeproduceerd), and every entry receives a code...
A third table (tblBestellingen) is used to keep track of the products (codes) sent to the shops. For most products, which default amount is "1", their code appears only once, but for the "16"-products their code can appear more than once (well, 16 times max.
)...
Problem: I want a query with all produced "codes" (tblGeproduceerd.*), where the default amount is shown, and also how many times the codes is present in "tblBestellingen", so I can have a calculated field that shows "default" minus "sent", so that when this is "0", the code is "closed" (with an update query). It's the "how many times the codes is present" that's bugging me. Do I use Count, Dcount,... and in what way
Or is there some other way to get the same result, but with a different logic?
Any feedback would be appreciated!
I guess the problem will take longer to explain than the solution:
Setting: I have a table listing all our products (tblProducten) and their default amount per package. For most this is "1", but some are "16" in a package...
This table is linked to a table listing our production (tblGeproduceerd), and every entry receives a code...
A third table (tblBestellingen) is used to keep track of the products (codes) sent to the shops. For most products, which default amount is "1", their code appears only once, but for the "16"-products their code can appear more than once (well, 16 times max.
)...Problem: I want a query with all produced "codes" (tblGeproduceerd.*), where the default amount is shown, and also how many times the codes is present in "tblBestellingen", so I can have a calculated field that shows "default" minus "sent", so that when this is "0", the code is "closed" (with an update query). It's the "how many times the codes is present" that's bugging me. Do I use Count, Dcount,... and in what way
Or is there some other way to get the same result, but with a different logic?
Any feedback would be appreciated!
