Displaying fields with zero values

  • Thread starter Thread starter mabi
  • Start date Start date
M

mabi

Hello all-

I have a query which returns a list of players and their
statistics. The query works as desired in Access. In
Frontpage, however, when a player has all zero's for his
totals the player name field is blank on the actual web
page.


Player G G A P

tj 3 1 2 3
rv 2 0 1 1
0 0 0 0

Any guidance would be appreciated ...
 
Not enough information. What kind of data are you storing? What does your
query look like?

--
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
-----Original Message-----
Not enough information. What kind of data are you storing? What does your
query look like?

--
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
Click to expand...

Sorry about that ...

The data is statistics from a sports team. The table
(000_skaters) resides in a database on my site.

The query:
SELECT [000_skaters].Player, First([000_skaters].POS) AS
FirstOfPOS, Sum([000_skaters].GMS) AS SumOfGMS, Sum
([000_skaters].GLS) AS SumOfGLS, Sum([000_skaters].AST) AS
SumOfAST, Sum([000_skaters].GLS)+Sum([000_skaters].AST) AS
PTS,
GROUP BY [000_skaters].Player, [000_skaters].TM HAVING
((([000_skaters].TM)='CP'))
ORDER BY Sum([000_skaters].GLS)+SUM([000_skaters].AST)
DESC, Sum([000_skaters].GMS) DESC, [000_skaters].Player
ASC ;
 
Back
Top