By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

Output from DAO recordset

P: n/a
Me again,

I'm new to Access and am self teaching from a couple of books, so bear with
me. (I've got a little experience with Visual Basic)

As I understand so far, if I want to perform a bunch of calculations on a
set of records (not calculated fields, but doing calculations from records
to record) using Visual Basic I would first create a DAO.recordset object
with the records I want to play around with.

Assuming I've got the first part right how do I go about outputting the
results of my calculations?

I'll use a rough example to explain:

I've got a table (or query) of three records with field headers A B C & D
sitting nicely in a DAO recordset. Using VB I add the values of records 1
and 2 of field B and then divide by the contents of the third record in
field D (crazy I know, but this is just to illustrate that I'm generating
some brand new data that I want to display). I then want to display an
output of the contents of record 3, fields A B & C and then the results of
my calculations in a fourth column. I might also want to create completely
brand new field headings as well for this new 'record'.

Would I create a blank recordset to use in code in which to pass this info
into? If so, how do you create a blank recordset that doesn't refer to any
existing object? To what object would I most likely output my info to?
(I'm assuming a report. If so, can I create a 'blank' report and manually
set the field headings?

This may be an awful lot to answer on in complete detail but if I could at
least get a general direction to study on would be appreciated. I'm trying
to make a database for my own purposes and would like to actually start
creating something useful without having to 'hit the books' for months
before I could accomplish something meaningful. In time I hope to educate
myself a lot more on Access but it would be nice to get something going in
the meantime.

Thanks,

Gord
Jul 23 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Gord" <x1******@telus.netwrote in message
news:vKxhk.1175$%b7.696@edtnps82...
>
I've got a table (or query) of three records with field headers A B C & D
sitting nicely in a DAO recordset. Using VB I add the values of records 1
and 2 of field B and then divide by the contents of the third record in
field D (crazy I know, but this is just to illustrate that I'm generating
some brand new data that I want to display). I then want to display an
output of the contents of record 3, fields A B & C and then the results of
my calculations in a fourth column. I might also want to create
completely brand new field headings as well for this new 'record'.
You can do it using a calculated field in a query and have your code in a
function. Pass your parameters to the function from the query.

MyCalcField: MyFunction(A,B,C)

But you could do the calc in the query without using any code so I'm not
sure what you'd achieve.

Keith.
www.keithwilby.com

Jul 23 '08 #2

P: n/a
Since it sounds like you're going for a report as the final
destination it makes sense to base that report on a table.

In addition to you calculations your code can
1) empty the table
2) Insert the calculation results as new records (or record)
3) Display the report

Another approach is to tag the calculations, usally by date, and just
keep appending to the report table. that way you'll have an ongoing
history of each run. In that case modify 3 above to apply the
appropriate filter.

hth,

Tim Mills-Groninger

On Jul 22, 10:40*pm, "Gord" <x1gor...@telus.netwrote:
Me again,

I'm new to Access and am self teaching from a couple of books, so bear with
me. *(I've got a little experience with Visual Basic)

As I understand so far, if I want to perform a bunch of calculations on a
set of records (not calculated fields, but doing calculations from records
to record) using Visual Basic I would first create a DAO.recordset object
with the records I want to play around with.

Assuming I've got the first part right how do I go about outputting the
results of my calculations?

I'll use a rough example to explain:

I've got a table (or query) of three records with field headers A B C & D
sitting nicely in a DAO recordset. *Using VB I add the values of records 1
and 2 of field B and then divide by the contents of the third record in
field D *(crazy I know, but this is just to illustrate that I'm generating
some brand new data that I want to display). *I then want to display an
output of the contents of record 3, fields A B & C and then the results of
my calculations in a fourth column. *I might also want to create completely
brand new field headings as well for this new 'record'.

Would I create a blank recordset to use in code in which to pass this info
into? *If so, how do you create a blank recordset that doesn't refer toany
existing object? *To what object would I most likely output my info to?
(I'm assuming a report. *If so, can I create a 'blank' report and manually
set the field headings?

This may be an awful lot to answer on in complete detail but if I could at
least get a general direction to study on would be appreciated. *I'm trying
to make a database for my own purposes and would like to actually start
creating something useful without having to 'hit the books' for months
before I could accomplish something meaningful. *In time I hope to educate
myself a lot more on Access but it would be nice to get something going in
the meantime.

Thanks,

Gord
Jul 23 '08 #3

P: n/a

"Gord" <x1******@telus.netwrote in message
news:vKxhk.1175$%b7.696@edtnps82...
Me again,

I'm new to Access and am self teaching from a couple of books, so bear
with
me. (I've got a little experience with Visual Basic)

As I understand so far, if I want to perform a bunch of calculations on a
set of records (not calculated fields, but doing calculations from records
to record) using Visual Basic I would first create a DAO.recordset object
with the records I want to play around with.

Assuming I've got the first part right how do I go about outputting the
results of my calculations?

I'll use a rough example to explain:

I've got a table (or query) of three records with field headers A B C & D
sitting nicely in a DAO recordset. Using VB I add the values of records 1
and 2 of field B and then divide by the contents of the third record in
field D (crazy I know, but this is just to illustrate that I'm generating
some brand new data that I want to display). I then want to display an
output of the contents of record 3, fields A B & C and then the results of
my calculations in a fourth column. I might also want to create
completely
brand new field headings as well for this new 'record'.

Would I create a blank recordset to use in code in which to pass this info
into? If so, how do you create a blank recordset that doesn't refer to
any
existing object? To what object would I most likely output my info to?
(I'm assuming a report. If so, can I create a 'blank' report and manually
set the field headings?

This may be an awful lot to answer on in complete detail but if I could at
least get a general direction to study on would be appreciated. I'm
trying
to make a database for my own purposes and would like to actually start
creating something useful without having to 'hit the books' for months
before I could accomplish something meaningful. In time I hope to educate
myself a lot more on Access but it would be nice to get something going in
the meantime.

Thanks,

Gord

You should be able to bind you query or table to a report, then group by
whatever field you use to select record 1 and 2. Display your calculation in
the group footer. If grouping will not work look into sub reports. As for
field headings use the On-Format event of the section to change headings
based on the data.
Jul 23 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.