Sometimes it's so simple that we forget...
Thx Brian it worked of course.

Brett

> Your problem is the quotes in date add (quote within a quoted string)

rsIssuedata.Source = "SELECT * FROM issuedata WHERE submitdate Between Now
AND DateAdd('h', -13, Now) ORDER BY Tool" 
or
rsIssuedata.Source = "SELECT * FROM issuedata WHERE submitdate Between Now
AND DateAdd("""h""", -13, Now) ORDER BY Tool"
or
rsIssuedata.Source = "SELECT * FROM issuedata WHERE submitdate Between Now
AND DateAdd(" & chr(34) & "h" & chr(34) & ", -13, Now) ORDER BY Tool"

Should work.

Brian Freeman
Carnegie Technology and Bluewave Computing
(770) 916-0595 ext. 415
www.carnegie.com   / www.bluewave-computing.com