Need Some help

[jdoathout]

I had to make a Dbase for a coding Class to calculate the E/M Code for given medical services. Access switches worked perfectly, but there were a few limitations. Because of this I had to break up the one Main Query into separate queries. 16 in total.

Because their have calculated fields I can't seem to rebind them back into the one.

What I need to do is take the sub query data and display [History Level] [Exam Status] [Medical Decision Making] [CPT Code Value] From the 16 Type and [Location Queries] on the [E/M Audit Form] Under the tab [Code Calculator].

Any Help would be greatly appreciated.
Thanks in Advanced
Joe

PS I have no VBA Training, trying to get the VA to get me some as it would definitely benefit me.

 

[jdoathout]

I think I have to be more specific. The system needs to display the right data given those fields meeting the criteria set forth in the queries. The queries should only return a non null value if the conditions are met and then displayed by Name and Case ID as 1 individual can have multiple case IDs.

 

[jdoathout]

While not exactly how I envisioned it to work, I solved the problem myself. I reintroduced the Switches as separate code in the query by subcategory. I then placed them on the form and made the border and back ground transparent and laid them over top over each other to produce what I had envisioned.

The only short coming I need to address is MDM Levels. Will be discussing this with a coding expert in the coming weeks.