By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

sql server dates in access

P: 2

I'm trying to reference a date in a text field on a form from an MS Access query which is using a sql server table. In my query I have the standard [Forms]![frmMain]![txtDate] in my criteria. It's not yeilding results due to having to use the # as a date delimiter. I can type the date and the delimiter in my query and it works fine. I've tried "#" & [Forms]![frmMain]![txtDate] & "#" and several other variations but with no results. Is there a solution? Any help would be greatly appreciated!

Aug 28 '06 #1
Share this Question
Share on Google+
1 Reply

P: 2
Never mind. I found the solution. I needed to change the format of the text box on the form to Date.
Aug 28 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.