Most Recent Posts
Archiving Old Data Solution
by JamesNT - 06/28/2025 12:06 AM
Need Advice regarding Data Archiving
by JamesNT - 06/28/2025 12:06 AM
Prescription Drug Monitoring Program
by Bert - 06/26/2025 8:25 AM
AI?
by Bert - 06/25/2025 7:52 AM
PRINTING SCHEDULE
by Raj1 - 06/24/2025 9:54 AM
AC Version 12.3
by beagle - 06/15/2025 8:57 PM
A Tale of Woe: Only Partial Backups
by JamesNT - 06/12/2025 3:00 PM
Member Spotlight
barcafan1990
barcafan1990
Brandon, FL
Posts: 272
Joined: June 2012
Newest Members
ESMI, It's me, Paradise Family, MedCode, MZ Medical Billi
4,594 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
#65897 06/24/2015 3:55 AM
Joined: Jun 2015
Posts: 5
PaulT Offline OP
Member
OP Offline
Member
Joined: Jun 2015
Posts: 5
I am trying to pull a list of medication prescribed within the last 30 days.
I do not want to name a medication, but rather obtain a list of every medication prescribed within a time frame.
Does anyone know if this is possible.

Thank you in advance.

Paul

PaulT #65904 06/24/2015 11:20 PM
Joined: Dec 2009
Posts: 1,201
Likes: 8
Member
Offline
Member
Joined: Dec 2009
Posts: 1,201
Likes: 8
If no reports are available, I can write a query for you.

JamesNT


James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net
PaulT #65907 06/25/2015 10:00 AM
Joined: Jun 2015
Posts: 5
PaulT Offline OP
Member
OP Offline
Member
Joined: Jun 2015
Posts: 5
JamesNT.

I have looked and looked and tried several combinations. Each time I have to search by a specific med. I do not see any wildcards for "all" leaving blank does not work neither.
I just want to see what medications have been prescribed in the last 30 days.


Let me know if you can help.
Thank YOU SOO much.

PaulT #65912 06/25/2015 2:13 PM
Joined: Dec 2009
Posts: 1,201
Likes: 8
Member
Offline
Member
Joined: Dec 2009
Posts: 1,201
Likes: 8
Paul,

Send me a PM with some contact info, please.

JamesNT


James Summerlin
My personal site: http://www.dataintegrationsolutions.net
james@dataintegrationsolutions.net
PaulT #65914 06/26/2015 12:14 PM
Joined: Jun 2015
Posts: 6
Member
Offline
Member
Joined: Jun 2015
Posts: 6
Try-
Medications:Refill date: >= (enter your starting date) --add to search
Medication: medication name(all): starts with (%) --add to search
At the bottom L of screen mark the box show all query

This worked for me-hope this is what you are looking for

PaulT #65935 07/01/2015 10:44 AM
Joined: Jun 2015
Posts: 5
PaulT Offline OP
Member
OP Offline
Member
Joined: Jun 2015
Posts: 5
That worked awesome. Thank you so much.
All query thing is what i had not done before.

Once again Thank you.


PaulT #65948 07/02/2015 12:28 PM
Joined: Jun 2015
Posts: 6
Member
Offline
Member
Joined: Jun 2015
Posts: 6
I am glad that worked, as my name implies-I am floundering my way through AC along with everyone else.
Flounder


Moderated by  ChrisFNP, DocGene, JBS, Wendell365 

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Who's Online Now
0 members (), 45 guests, and 34 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
Bert 10
imcffp 3
beagle 3
ESMI 2
Top Posters
Bert 12,884
JBS 2,986
Wendell365 2,366
Sandeep 2,316
ryanjo 2,084
Leslie 2,002
Wayne 1,889
This board is dedicated to the memory of Michael "Indy" Astleford. February 6, 1961 -- April 16, 2019




SiteLock
Powered by UBB.threads™ PHP Forum Software 7.7.5