July is our annual ACUF campaign for donations to help offset the cost of the board. Please click the link below for more details.
Amazing Charts User Forum Donation Campaign


ACUF Campaign

July is our annual ACUF campaign for donations to help offset the cost of the board. Please click the link below for more details.

Most Recent Posts
Can someone please tell me what is going on here!
by Shrinkrap - 07/04/2025 9:19 AM
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
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
Posts: 52
Joined: July 2021
Newest Members
ozonr666, ESMI, It's me, Paradise Family, MedCode
4,595 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
2025 ACUF Annual July Contributions
Help fund this site.
ACUF Donation
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Who's Online Now
0 members (), 71 guests, and 35 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
Bert 10
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