Sql Start And End Date Query (1 Viewer)

David92595 · Feb 8, 2012

I need to run a query using a sql 2008 R2, with an access 2007 front end. The query needs to allow me to set parameters for a start date and an end date. Any suggestions?

David92595

mdlueck · Feb 9, 2012

David92595 said:
Any suggestions?

With what part of it?

tehNellie · Feb 9, 2012

Create a stored procedure with two parameters StartDate and EndDate perhaps.

MSAccessRookie · Feb 9, 2012

David92595 said:
I need to run a query using a sql 2008 R2, with an access 2007 front end. The query needs to allow me to set parameters for a start date and an end date. Any suggestions?

David92595

It sounds like you should be able to use a Basic MS Access parameter Query in this case. The following link provides examples of parameter Queries, along with explanations. See if it helps you to resolve the issue on your own, and get back with any questions.

http://office.microsoft.com/en-us/a...ers-with-queries-and-reports-HA001117077.aspx

mdlueck · Feb 9, 2012

tehNellie said:
Create a stored procedure with two parameters StartDate and EndDate perhaps.

Yes, the OP could do that. I have an example of that here:

"Using VBA ADO objects to execute a Stored Procedure"
http://www.access-programmers.co.uk/forums/showthread.php?t=216860#post1104120

Usually I use an adoRS object and run the query in Pass-Through mode to SELECT records, and SP's to INSERT / UPDATE data.

"Client/Server Architecture"
http://www.access-programmers.co.uk/forums/showpost.php?p=1110794&postcount=5

I think we have enough collective ideas. Now to hear from the OP I think is next.

Sql Start And End Date Query (1 Viewer)

David92595

Registered User.

mdlueck

Sr. Application Developer

tehNellie

Registered User.

MSAccessRookie

AWF VIP

mdlueck

Sr. Application Developer

Similar threads

Users who are viewing this thread