By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,399 Members | 960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,399 IT Pros & Developers. It's quick & easy.

Counting Field changes

P: n/a
As new Records are added I need to in a Query, count the number of
occurrences of several specific Fields that have change from the
previous record.
As a reference point, each Record is unique for Date and Time so if
the next Record is added to the DB, I want to know if Field 'x' has
changed in value from the entry in the previous Record.

Thank you,

Bill Howard
Tufts-New England Medical Center

Aug 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ben
On Aug 15, 5:31 am, BillH <whow...@tufts-nemc.orgwrote:
As new Records are added I need to in a Query, count the number of
occurrences of several specific Fields that have change from the
previous record.
As a reference point, each Record is unique for Date and Time so if
the next Record is added to the DB, I want to know if Field 'x' has
changed in value from the entry in the previous Record.

Thank you,

Bill Howard
Tufts-New England Medical Center
Use one query to find the last row (excluding the one just entered)
using the max function. Then use another query with a max function to
find the record just entered. Now you can compare the two queries to
find if field x changed.

Aug 15 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.