VBA-Access/SQL Help

[troussis]

Hi All,

I have a problem with some code to try and get data from an access database. I know nothing about SQL and have only been learning VBA for the past year. Basically what I am trying to do is open a connection to an access database I have on my computer, go to a table and pull out information. I need be able to pull data based the 2 dates the user will input. Here is what I have so far, but it doesn't seem to return any data, only the headers. Any help would be greatly appreciated.

I have attached the code I have so far for reference. Thanks in advance.

[JosephP]

you may try

Please Login or Register  to view this content.

[troussis]

you may try

Please Login or Register  to view this content.

That was it!!! That worked perfectly. Thank you for the help. What makes this different from not including the pound sign? I'm curious to know.

[sakmsb]

That was it!!! That worked perfectly. Thank you for the help. What makes this different from not including the pound sign? I'm curious to know.

# is the syntax for enclosing dates in Access, like single or double quotes in SQL/MySQL