Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / July 2007

Tip: Looking for answers? Try searching our database.

Query in date range

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
purple - 24 Jul 2007 13:08 GMT
How will i pull query in date range (eg 10/07/2007 - 20/07/2007) from DB
using infopath query forms?
Clay Fox - 24 Jul 2007 13:38 GMT
This is difficult.  If it is a static date range you can edit the sql
statement under when you edit the data connection and put in a SQL Statement.
If it is dynamic in your form you would have to query all the data and then
use a filter to find the data within your date range.
Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

> How will i pull query in date range (eg 10/07/2007 - 20/07/2007) from DB
> using infopath query forms?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.