Passing Variables to a Report Recordsource

R

Ryan Langton

Do I need to do this using a stored procedure?
I need to generate a report based on values from global variables
(varStartDate and varEndDate). Whenever I try to use these variables in the
report recordsource query I am getting errors that they cannot be found.

I have not used stored procedures before.
 
A

aaron.kempf

variables like that; i always just store them in a table; and then it
is easy to bind these to the correct fields using subqueries.

i just think that it's more efficient to store all the logic on the
server than pass variables around and things like that

-aaron
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Incorporating the User Profile location into a document template path 1
Stored procedure as row source for a combo box 4
Access ADP Form and Stored Procedure as RecordSource Options 2
Report Based on Dates 7
VBA word change keys 0
Tagging Misspell Words with "##" 0
Forms and Recordsource Options 6

Top