Can You Use SQL Max() Function Based on Variable From Form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

I'm wondering if it is possible to execute a SQL query at runtime, from a
Form, and to alter the query programmatically based on a value (variable)
passed from the Form to the query. I am looking to obtain a max value of a
number based that is related to the variable that will (hopefully) be passed
from the Form to the query at runtime.

Thanks,

Cindy

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200711/1

.

Quantcast