Database Results Math

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible through FP2003 to get database results (counts) and use the
results to do math equations.

Or would i need to learn, VB and ASP programming?.


Al....
 
You need to learn VBScript...

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Cheers Thomas

just one more question

What i'm looking to do is pull results from one table as a count say count1,
then pull results from another table (possibly another .mdb file) as a count
say count2, then pull results form another table as a count say count3.
count4 would be count1 - count2

then show count4, count2, count3

OK to the question.
would it make more sence to do this within Access assuming it's possibe to
put the results of more than one query in the one table, or would it be
easier to do with an asp page?.

Any other advice would be helpful.


Al....
 
1. If you want to use more than one Access table or database at the same time, you will have to
learn to hand code.

2. When you use Access on the web, you are not using the Access Application, so many of the features
of the application or not available to you when you access the database via ASP, etc., so yes you
will need to learn to hand code.

3. Learning to hand code will open up a world of options that are really not available when you let
a application generate your code for you.

4. You might want to consider having a single table with your counts, but that does require that the
table be updated when records are added/update, etc. in your other tables.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Agree w. Thomas - learn to hand code your ASP

FYI
when using the wizard you can get a record count After each DBRW is displayed using
<%=fp_iCount %>
but in your example you need to run at least 2-3 DBRW on the page to get 2-3 counts from 2-3 tables

After the first one use
<%count1=fp_iCount %>
After the second one use
<%count2=fp_iCount %>
After the third one use
<%count3=fp_iCount %>
Then your math is simply
<%count4 = abs(count1-count2) %>
and you display them using say
<p>Count 4 = <%=count4%>, Count 2 = <%=count2%>, Count 3 = <%=count3%></p>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Cheers Thomas
|
| just one more question
|
| What i'm looking to do is pull results from one table as a count say count1,
| then pull results from another table (possibly another .mdb file) as a count
| say count2, then pull results form another table as a count say count3.
| count4 would be count1 - count2
|
| then show count4, count2, count3
|
| OK to the question.
| would it make more sence to do this within Access assuming it's possibe to
| put the results of more than one query in the one table, or would it be
| easier to do with an asp page?.
|
| Any other advice would be helpful.
|
|
| Al....
|
| "Thomas A. Rowe" wrote:
|
| > You need to learn VBScript...
| >
| > --
| > ==============================================
| > Thomas A. Rowe (Microsoft MVP - FrontPage)
| > ==============================================
| > If you feel your current issue is a results of installing
| > a Service Pack or security update, please contact
| > Microsoft Product Support Services:
| > http://support.microsoft.com
| > If the problem can be shown to have been caused by a
| > security update, then there is usually no charge for the call.
| > ==============================================
| >
| > | > > Is it possible through FP2003 to get database results (counts) and use the
| > > results to do math equations.
| > >
| > > Or would i need to learn, VB and ASP programming?.
| > >
| > >
| > > Al....
| >
| >
| >
 
Back
Top