Data Source

  • Thread starter Thread starter JJ
  • Start date Start date
J

JJ

Hi All,

I was wondering what you are all using to connect your code behind data
to a report? Basically the methods u are using to provide data to a report
other than a stored procedure, table or query.


Thanks,

JJ
 
Well, according to the Help file for the RecordSource property of a report:

"The RecordSource property setting can be a table name,
a query name, or an SQL statement. "

Some of the MVP/gurus may have found other methods, but I think the above
would cover most situations.
 
But this is just my point I don't think the recordsource: Table/View/Query
works for doing calculations on database very well.

For instance I have to take values from a record from last months end and
subtract them from another record this month end and give the results in
access report. How would u go about writing this?

Or another example
I have to traverse a months worth of records and subtract the previous day
from todays value and give results in report.
How would you go about doing this?

I am resorting to using recordsets in code behind a form in order to do
calcs. I don't believe Sql handles this well.

JJ
 
Back
Top