I have a form displaying in datasheet view. The form uses a query as it's record source. But I have one issue... there are fields displaying numbers that repeat and I don't want them to repeat because I have totals turned on and those totals are being effected by the number of times the number appears for that particular item.
Please see that attachment to understand my issue.
Using this example you can see that record M1640 has a scheduled quantity of 1,600 but that number need to either appear only once OR the "Total" number needs to include it only once.
So the "Total" I'm looking for should be 2,000... not 3,600.
Can this be done?