Free Medisoft Support & Other - Courtesy Support Resource

For prospective & existing Walker Tek Solutions' clients. (Remember me for upgrades ~ Gavin)
It is currently Thu May 24, 2018 11:05 am

All times are UTC-05:00




Post new topic  Reply to topic  [ 1 post ] 
Author Message
PostPosted: Wed Sep 06, 2017 10:37 am 
Offline

Joined: Sat Oct 11, 2014 11:40 am
Posts: 155
Location: Boston, MA
I am trying to generate a report where the user enters a random date and it is matched to "Date Created" or "Date Modified" in the Transactions table. Using the built-in query designer, I can have the user enter the date twice during report generation. I would like the user to pick the date only once, and have that date matched to other dates in the Transactions Table.

Stated differently, how do I go about building a parameterized query where the parameter is not a field in the database? That is, gather user input for a new variable and use that to match specific fields in the database at run-time?


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 1 post ] 

All times are UTC-05:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Limited