Show a row with 0 values?

[hello101]

Hello,

I'm running a Select query that is not showing a specific row. That's because all the values are eqaul to 0 in that row. However i want it to show the 0 values because i'm exporting the data to Excel. how do i do i make show the entire row with 0s.
Thank you in adance..

 

[smedvid]

Difficult to answer... is your WHERE condition keeping the single row from apearing? Consider using the NZ() Function if you have Nulls and want a zero to appear. Another approach is to create a UNION Query and add a Select statement which displays the missing data... htwh??

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[JoeAtWork]

Showing us your SQL SELECT statement would be the fastest way for one of us being able to help you.

It is most likely that your WHERE clause is filtering out the row with the zeroes.