UltimateNeo
New member
- Local time
- Today, 23:45
- Joined
- Apr 29, 2024
- Messages
- 18
Hello, I am trying to add up records with the quantity of and then if the quantity is greater than 1 add that to the count. So the single record is counted as many times as the quantity says. If i have 12 records all with quantity 1 then that would be 12 and then if i had 1 record that had a quantity of 4 that would be counted 4 times making the total 16 not 13. I am trying to put this in a textbox on a from using dcount and dsum or dlookup to no avail.
in the query i am looking for a name from my combobox and a task from my textbox formula so it is filling in the criteria for the query and then displaying the result.
Any help with the totals is much appreciated
=DCount("*","Daily","[ID] = '" & [Forms]![CompletedStatsF]![cboinspector] & "' AND [Tasks] = 'Visual Inspection'") I have not got my current formula for doing the qty here. This is what i started with and tried a few things to no avail.
in the query i am looking for a name from my combobox and a task from my textbox formula so it is filling in the criteria for the query and then displaying the result.
Any help with the totals is much appreciated
=DCount("*","Daily","[ID] = '" & [Forms]![CompletedStatsF]![cboinspector] & "' AND [Tasks] = 'Visual Inspection'") I have not got my current formula for doing the qty here. This is what i started with and tried a few things to no avail.