Interfacing with a stored procedure

A

Ana

Hi,

I created a stored procedure to list the paid orders for a determinate
period (SELL_DATE --- BETWEEN @Date_Start AND Date_End) and by SALESMAN
(@Salesman).

I would like to use a Form which will allow me to select the SALESMAN, the
Start and End date. Then with a command bottom write a 1 in a bit column
(COMMISSIONS_PAID) based on my selected period.

TIA

Ana



Access XP -> MS SQL2K
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

More date issues 4
Problem with dates 0
Report with only todays events 2
SQL statement in a form 1
Running a stored procedure from Access form 1
Problem generating report using stored procedure 1
Stored Procedure Date Parameter Conversion 4
Subform Using a Stored Procedure RecordSource with Optional Parameters 0

Top