Calculating Totals With Data From Access

I have done a fair amount of coding but very little in the way of maths type stuff

<code>
While Not objRSC.EOF
Response.Write "<tr><td>"
Response.Write objRSc("Item_Quantity") & "</td><td>"
Response.Write objRSc("Stock_item") & "</td><td>"
Response.Write objRSc("Stock_description") & "</td><td>"
Response.Write objRSc("Item_Price") & "</td></tr>"
objRSc.MoveNext
Wend
</code>

What I now want to do is to add all the Item_Prices together, .

View Replies


ADVERTISEMENT

VBasic Text Field (phone Number) Calculating Data Before Inserting Into Access

I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?

View Replies View Related

Grouping And Totals For Group

I am writing a report using ASP and am having trouble displaying the data in the way i want. I'm collecting turnovers for various companies and each of the companies has a county code. e.g. Yorkshire is defined as number 2.

I need to group the companies together by county and need to display a totals line for those members only and then on the following lines I want the next county and its companies.

I can group the counties together but the totals line I'm displaying appears after each companies rather than after the group of companies for a given county.

I use a do while loop to check that there is data in the database for each company. I tried putting the totals line outside the loop and that only shows 1 totals line for ALL companies.

View Replies View Related

Using Shopping Cart Totals

i have a basic asp page that acts as an online bookstore. on my cart page i am having trouble generating 3 numbers; a subtotal, a shipping total, and a final price. here is my code:

View Replies View Related

Getting Totals While Using Repeat Region

I have a database that displays its records on a webpage, The information displayed on the webpage is included in a repeat region so that the related records repeat down the page.

I want to add the totals of the displayed records at the end of the page. How do i do this. Im assuming that it goes outside the repeat region? Does anyone have any code or a walk through of how this is done?

View Replies View Related

Create Monthly Totals Based On Date Field

my question is regarding using ASP to loop through the results of a sql query and calculate a monthly total based on a date field.

I am using the following query to total the number of train rides for a given branch by day type (weekday, Sat., Sun.) and create a 3 month rolling avg. (to diminish large fluctuations in the data). I am using Oracle 9i to store the data.

Please see below for the database query, the query output, and the desired output using ASP to sum the rides for each month. Code:

View Replies View Related

Data Type Mismatch When GETting Data From An Access DB

We are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.

THE RESULTS:
(returns a blank page with only HTML Titles)

THE SCRIPT:
(you may notice this is a modified sample script): Code:

View Replies View Related

Calculating Age

I have a form setup to search for people between CageT1 and CageT2 but am unable to get it to work. Peoples birthdates are stored in Access in m_date_of_birth; age is not stored in the database. The code below is a test.asp page I created so that I could debug the problem; thats why all this page requests is a Response.Write(sql). Code:

View Replies View Related

Calculating Vat Tax

I'm having difficulty calculating vat 917.5%). I've written some basic asp to do this, but the result is far from correct. Can anyone spot what I've done wrong ?

<%
Session("price") = (Session("variable1"))+(Session("variable2"))+(Session("variable3"))
%>
<%
vat = Session("price") / 100 * 17.5
Session("total") = Session("pprice") + vat
Session("total") = FormatNumber(Session("total"), 2)
%>

For example, if my variables are:
variable1 = 165
variable2 = 50
variable3 = 25
When I write the session variable 'total' it comes out at: 1,944,654.38

If I run the vat calculation on just on variable, without adding them, the result is correct. So I guess I'm adding sesison variables incorrectly?

View Replies View Related

Calculating Time

Ok so I have 5 variables:

start = "8:00:00 AM"
lunchstart = "12:00:00 PM"
lunchend = "1:00:00 PM"
end = "5:00:00 PM"
totalhours = X

What I want to do Is calculate the total hours between start and end and subtract the total time spent on lunch. For example, using the variables above I have been trying for weeks to figure out how to make total hours = 8

View Replies View Related

Calculating The Score

I have set up a variable that if the answer is correct score =1 however im not sure how to total all the scores and i would also like to have it as a percentage. Code:

View Replies View Related

Calculating Median

I have a microsoft access database with one table. I am trying to extract a filtered list of records from the database using ASP. So far i am able to do this. My next step is to somehow calculate the median from this filtered list within ASP. Maybe using some VBscript or something?

View Replies View Related

Calculating Fields From DB In ASP

Let's say I have an Access DB with a table named proCount. In the table proCount, I have two fields named numOne and numTwo. In my ASP page I'd like to have a repeating region that lists all the records in the proCount table. Is there a way to have ASP calculate the sum of all the returned records for the field numOne and the field numTwo?

View Replies View Related

Calculating Probs

I need to get the sum of all fields where clientID = 'woteva'

so far i'm only doing this by bringing them up with the 'move nxt' but this then displays all the fields, where i just want to display the result without all the fields showing aswell? Code:

View Replies View Related

Calculating Percentages

I know this is more of a maths problem. But I'm not having a good day with it today. what I need to do is work out the percentage of closed job against the total jobs made? So

StrTotalJobs
StrClosedJobs

are the varables. What is the code I need to work it out?

View Replies View Related

Digits Calculating

when I calculate a Digits for example: 101.12 * 1.21 the resilt is 122.3552 This one should be 122.36 and if it is 122.3549 to be 122.35 How can I make this thing works?

View Replies View Related

Calculating Birthdates

I have birthdates in a field called CustomFieldDOB in a table called Vendor. The birthdays were entered with mixed formats, m/d/yy, mm/d/yy, m/dd/yy, m/d/yyyy, mm/d/yyyy, m/dd/yyyy, and with separators of / and -.

Total number of entries is 5600+ so manually changing each of these to one format would be VERY time consuming. In the end, I am trying to have our Intranet page show "Today's Birthdays". I am familiar with setting up a loop to display the Vendor names , I just don't know how to calculate variable formatted birthdates.

View Replies View Related

Calculating Minutes Between Dates

I need to calculate the number of elapsed minutes between two datetime variables. BUT, it needs to only include times between 8am and 5pm on weekdays.

So if the starting datetime is at 5:01pm, it doesn't start counting until 8am the next weekday morning.

Or, if the ending datetime is at 6:30am, the counting would stop at 5pm the previous weekday.

View Replies View Related

Calculating Time Difference

I am logging a time that people log in, stored as a short time. I want to be able to run a script which runs through my users database and checks all the users who are logged in, it checks the users last action time time against the current time and automatically logs any out any users who haven't had any activity in more than 30 minutes.

pseudo code as follows:

dim currentTime = now()
dim lastActionTime = rs("lastAction")
if(lastActionTime < currentTime - 30 minutes)
log the user out

Can anyone tell me how I code the time calculation to deduct 30 minutes from the current time?

View Replies View Related

Calculating Database Fields

At the moment in time I have a product database being displayed. I could do with including another column to the database which allows me to enter a specific quantity for that product line. All the quantitys fields need to be calculated to their specific product cost value.

Finally all the sub totals need to be calculated together to give a grand total, which will be displayed on another page.

View Replies View Related

Calculating Page Breaks

I am trying to modify an existing ASP application that produces forms with several 'blocks' of text that are contained within table cells and which have their own HTML id's.

These blocks must not be split over two pages. Is there a straightforward way of calculating the size of each block/table cell so that the blocks are not split and the form prints on the minimum number of pages? This is an intranet application, so we have a certain amount of control over browser settings, so margin settings etc are not a problem.

View Replies View Related

Calculating Average From An Array

I have an array like

array = "1,2,3|,2,4,6| ...)

There will be an unknown number a values between the | and an uknown total number of values. I need to get the average of the number between each of the |'s. Any ideas how to handle that?

View Replies View Related

Calculating Text Pixels

if there is a way in ASP, to calculate with of a string of text in pixels. The result is to be used to set table width so that texts don't get wrapped to second line.

View Replies View Related

Calculating, Calling & Printing Return Values

I have a problem with returning a value from an external function.....

My asp page is basically a list taken from a database. A date record is written from the DB, then all the recordslinked to that date are listed, then the next date, then the next series of records, i.e. Code:

View Replies View Related

I Am Having Problems With Calculating The Total Seconds From Two Date/times.

I need to get the number of seconds when subtracting two date/times.
With the code I am using below I subtract the two date/times and end
up with a total of days like "1.56".

Then when I multiply it to get
the number of seconds I am not getting an accurate number. I should
only have whole numbers of seconds with nothing past the decimal
point. I would like to be able to subtract the two date/times and get
the number of seconds without multiplying to get it. Is this possible?
Does anyone have a better more accurate way to do this? Code:

View Replies View Related

Asp+access Data

This is my query.i have a access database, hooked up to dreamweaver mx. inside the database are 3 tables. sun/moons/planets. the planets table is linked to the moons table. In the planets table are the fields:
planet name;
Text_1;
Text_2;
planetID;
Distance;
Pic_1;
Pic_2;
What i wish to do is from my index.asp page click on a link which then displays the planet and EITHER text_1 or Text_2, and seperately Pic_1 or Pic_2.

I have tried using random nos 1 or 2 but i dont know how to pull the number and access the right table/field

View Replies View Related

Access Data

i want to display DATA stored in Access DB by using ASP script.i can read data from access so that task is only to display data is a list like.i have a record of some users and i just want to display the users name in a list.how can i do this.

View Replies View Related

Access Data

i want 2 asked 2 howwe can acces the data from database using combo box.and how we can save the data to the database from combo box.

View Replies View Related

Data Access Via ASP

i am working on a interanet application for Inventory handling, i have a problem while submitting the data to server, the problem goes like this

Data base : Ms-Access
Front End : ASP

how to comit the data "say Invoice" to main database is two persons tries to make invoice at same time at different computers, How to maintain the series of Invoice unaffected, how to allocat Invoice number to them, and how to put a check that both of them can't make a invoice of same customer at a same time at different computers.

View Replies View Related

Use Asp To Access Data In Db2

is there anyone use asp to acess data in db2?

i am wondering if there's oledb provider for DB2? and where can i get it ? we use asp, not asp.net , therefore we can't install .NET framework , is there any other solution ?

or i can only do that through ODBC ??

View Replies View Related

MS Access Data

Im trying to write some asp code to copy MS Access Data into an Oracle database. I have one connection open to the access database but when I try and open the oracle connection it says that the ms access tables does not exist.

Basically what Im trying to do is get the data from a row in the Access db and insert it into a row in an oracle db.

View Replies View Related

Data Access Permissions

I am using winXP pro + IIS5.1 to develop my site offline.

My data is in a folder outside the web, and I am told "my IUSR account needs
to have read/write/modify NTFS permissions to the directory housing the
file"

I can find no info on how actually to do this. Can anyone explain?

View Replies View Related

Data Access With JavaScript

I'm attempting a login script where I first authenticate a user's login info for a valid connection. When I use a valid ID/Password everything works. When I use a bad user/password I get an error page stating the login failed.

I would prefer to redirect the user to another page on a failed login. This is the part that doesn't work. I'm new to ASP and JavaScript, but have done this kind of thing with PHP with no problems.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved