FrontPage 2000 and Formatting Tables Connected to an Access Database

[Chris Sergent]

I have connected an Access Database to a FrontPage asp and
don't know how to format the numbers.

My number field could be [applications] in a table called
[tblCases] and the name of the query is [qryTotalCase].

If the number is 1716 I want it to display as 1,716

Any ideas how I make this happen?

Also, I would like to override the date format. The date
is displayed as 01-01-2004 for January 2004.

I want it to show January 2004.

Any help would be greatly appreciated.

Thanks.

 

[Jim Buyens]

-----Original Message-----

I have connected an Access Database to a FrontPage asp
and don't know how to format the numbers.

My number field could be [applications] in a table called
[tblCases] and the name of the query is [qryTotalCase].

If the number is 1716 I want it to display as 1,716

Any ideas how I make this happen?

FrontPage has no control over number formats. Therefore,
you have to format the field in SQL. For example, instead
of

SELECT [applications] FROM [tblCases]

code

SELECT Format([applications],"#,##0") AS fmtapps
FROM [tblCases]

and then display the fmtapps field in the DRW.

Also, I would like to override the date format. The date
is displayed as 01-01-2004 for January 2004.

I want it to show January 2004.

In that case, code something like:

SELECT Format([applications],"#,##0") AS fmtapps,
Format([appdate],"mmmm\,yyyy") AS fmtdate
FROM [tblCases]

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Chris Sergent]

Jim,
This worked well. Made the edits in Access 2000 and the
format in the results through FrontPage 2000 were what I
was looking for.
Chris
Thanks

-----Original Message-----

-----Original Message-----
I have connected an Access Database to a FrontPage asp
and don't know how to format the numbers.

My number field could be [applications] in a table called
[tblCases] and the name of the query is [qryTotalCase].

If the number is 1716 I want it to display as 1,716

Any ideas how I make this happen?

FrontPage has no control over number formats. Therefore,
you have to format the field in SQL. For example, instead
of

SELECT [applications] FROM [tblCases]

code

SELECT Format([applications],"#,##0") AS fmtapps
FROM [tblCases]

and then display the fmtapps field in the DRW.

Also, I would like to override the date format. The date
is displayed as 01-01-2004 for January 2004.

I want it to show January 2004.

In that case, code something like:

SELECT Format([applications],"#,##0") AS fmtapps,
Format([appdate],"mmmm\,yyyy") AS fmtdate
FROM [tblCases]

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

.