Avoid Prompt message - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Avoid Prompt message

Author

Topic

Jay7
Starting Member

2 Posts

Posted - 2004-04-29 : 21:09:49

Hi there,

I have very simple query. In sql view it is like this.

SELECT DatePart('yyyy',[ResponseDate]) AS [Year], Count(*) AS Cases
FROM dbo_Response_Master_Incident
WHERE (((dbo_Response_Master_Incident.Response_Date)>=#7/1/2003# And (dbo_Response_Master_Incident.Response_Date)<#7/2/2003#));

It's counting number of cases by year with the specified date supplied. How can I avoid the prompt message.

Thank you very much.

Regards

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2004-04-29 : 23:59:04

Assuming you mean the prompt asking for 'ResponseDate'? You need to insert the underscore between 'Response' and 'Date'.

FYI - If Access can't resolve the contents of square brackets as a field or table name, it will assume it's a user-entered parameter and act accordingly.

Jay7
Starting Member

2 Posts

Posted - 2004-04-30 : 01:53:34

Thanks Mate.

It works now. I missed the under score.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources