https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/9875.aspxSat, 03 Jun 2006 04:04:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:9875trufooser0https://www.infopathdev.com:443/forums/thread/9875.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=9875i also figured this one out after playing for a while. create a table in access. this table will have two fields and store one record, the begin and end date. next create a query in access that finds the records falling in between the two dates.<br /><br />however, in order to use this query feature, i had to create a new form in infopath with the new table as the main data connection. but since i will not be submitting any data, its just for retrieval and viewing, it doesnt matter.https://www.infopathdev.com:443/forums/thread/5637.aspxThu, 01 Jun 2006 16:37:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5637trufooser0https://www.infopathdev.com:443/forums/thread/5637.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5637looking for a way to bring up records that fall in a certain date range. i have multiple fields with dates in them, and i want this query to check every field with a date, if the date falls within the range, to return just that part of the record.