Data Management & Storage/Experts

Recent Answers

2012-03-25 Systems Analysis:

Have you ever shopped at a Stop and Shop supermarket? They have a similar system to what you describe. The wands store the scanned barcodes and store them. The shopper scans each item and places it directly

2012-03-09 Calculated fields:

You don't need to use a calculated field for this, but you can. See my blog for an article on how to use calculated fields.    You need to understand how Access stores date/time values. They are stored

2012-03-07 totals in queries:

Create a Group By query that groups by Medication and Sums the doses. That will give you a total by medication. If you want to group by med and further by patient you can do that.     Hope this helps,

2012-03-07 totals in queries:

You would need to have a table that records each dose given to each patient. You would then have another query that subtracts those transactions from the balance at the start of the year. Group that by

More Answers in Category Data Management & Storage