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 3 2787
"Gord" <x1******@telus .netwrote in message
news:vKxhk.1175 $%b7.696@edtnps 82...
>
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
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
"Gord" <x1******@telus .netwrote in message
news:vKxhk.1175 $%b7.696@edtnps 82...
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: mike newman |
last post by:
I am trying to output a recordset that I have to Excel XP?
I don't know how to do it. I have the Office 10 COM
Object library reference, and I just need to know how to
take my recordset, locate the excel file, and move the
contents of the recordset to a worksheet.
Any help would be greatly appreciated.
|
by: PinkGuava |
last post by:
Hi,
I have a T-SQL stored procedure that returns both output parameters
and a recordset. How do I retrieve them in my ASP script? As far as I
know, the ADO Command object can be used to retrieve the output
parameters, but will I be able to retrieve the recordset using the
Command object as well? Or do I have to use the Recordset object?
Example of stored procedure:
|
by: sumGirl |
last post by:
Hi all. I have a stored procedure on my sql server that returns a
simple informtation about that tim a database was backed up. I owuld
like to create an HTA that operator types can look at to make sure
that the backups finished, can someone help me do this?
The stored procedure in called sp_lastback and the output looks like
this:
database days since backup timestamp of backup
dbase1 0 2004-10-14 00:41:21.000
|
by: Axel |
last post by:
Hi,
I am currently creating an ASP page that returns a recordset of search
result based on multiple keywords. The where string is dynamically
built on the server page and that part work quite well. However I want
to also return the number of records in the recordset and I can not
manage to get any output parameter working. Even if I assign SELECT
@mycount=100 (or SET @mycount=100) in the SP the only value set in
mycount is always NULL. ...
|
by: stjulian |
last post by:
If inside a stored procedure, there a SELECT statement to return a recordset
and another SELECT to set the value of an output parameter (as in SELECT
@OutValue = Name FROM table WHERE pkid=5), would 2 execute statements be
needed to return the OUTPUT parameter?
Like this?
adocmd.CommandTimeout = 120
adocmd.ActiveConnection = conn
| |
by: Phlazar |
last post by:
I have created a 'Intelligent' search stored procedure that accepts two input parameters SearchFor and SearchIn and an OUTPUT parameter @Result
Basically it starts by looking for a match for the SearchFor and if more than 1 is found, returns a recordset of the matches so the user can select a SearchFor category, at the same time the OUTPUT parameter is set to let the calling script know what is being returned.
Likewise it does the same for...
|
by: Mike Lester |
last post by:
I have a need for a stored procedure to return a recordset AND an output parameter that contains the count of records in the recordset.
I can get either but not both. (ie. if there is a select then there is no output parameter)
The stored procedure is:
ALTER PROCEDURE test
(
@Msgs nvarchar(150) OUTPUT
)
|
by: BSB |
last post by:
Hi,
I generate a "Find Duplicate" query for one table that will return some records
I want to capture those records in my VB code.....
This is my code...pls guide me how to proceed....
***************************************************************************************
adocmd.CommandText = sQueryName
adocmd.CommandType = adCmdStoredProc
|
by: Mike P |
last post by:
I am trying to return an output parameter to my code on executing a
stored procedure. In Query Analyzer, it works with no problem, but when
I run my ASP code below, the output parameter never seems to return
anything. Can anybody help?
Dim cmdNewCampaign, rsNewCampaign, intNumber
Const adCmdStoredProc = &H0004
Const adParamInput = &H0001
Const adParamOutput = &H0002
Const adVarChar = 200
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |