Home Forums Discussions General Discussion Data mining

>>> The advanced function is very easy to use, simply click the button, a box opens and you add criteria to the box over and over until you are done, then start search.
For example: to find all of your diabetic patients, you must search for 250.00 and 250.02 and 250.42 and etc. You get the idea.

You should all learn how to use MS Access' powerful native query language (which is not all that hard) to look up stuff directly on your AC tables. That is one topic which can and should be discussed in the AC get-together.

The SQL queries for lasix/furosemide is:

"SELECT ListMEDS.* FROM ListMEDS WHERE (((ListMEDS.MedName)=Left("Lasix",5) Or (ListMEDS.MedName)=Left("furos",5)));"

The SQL queries for the ICD diagnosis codes for diabetes would look something like this:

"SELECT superbill.* FROM superbill WHERE (((superbill.ICD1) Like "250*")) OR (((superbill.ICD2) Like "250*")) OR (((superbill.ICD3) Like "250*")) OR (((superbill.ICD4) Like "250*"));"

These look somewhat complicated, but there are MS Access wizards to help you put them together. Then again, there is always this community server board where those of us in the know and who like this stuff can help you out.