By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,401 Members | 793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,401 IT Pros & Developers. It's quick & easy.

Report including only days with value > 0

P: n/a
I have a table with rainfall logged on 15 minute intervals. I want to
make a report that shows only those DAYS when there is actually
rainfall, ie if a particular day has any rainfall at all I want to
print all the records for that day.

Can I do this just with a report? Can I do it with a report based on a
query? Do I need to have an intermediate table/query that includes
daily totals?

Any suggestions welcome. Thanks!

Rebecca

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can use a query or the report's Filter property or both.

Query example:

SELECT day, sum(rainfall) as rain
FROM table_name
GROUP BY day
HAVING sum(rainfall) > 0

Report Filter (using the above query without the HAVING clause):

Filter: rain > 0
FilterOn: Yes

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQgkW34echKqOuFEgEQIblACeN0n42IaXA6ndlr/X3A6vh9byW6EAnRlu
0Cfv2wrdTvp/y3N+3QuA1E0T
=lZHH
-----END PGP SIGNATURE-----
ri**********@gmail.com wrote:
I have a table with rainfall logged on 15 minute intervals. I want to
make a report that shows only those DAYS when there is actually
rainfall, ie if a particular day has any rainfall at all I want to
print all the records for that day.

Can I do this just with a report? Can I do it with a report based on a
query? Do I need to have an intermediate table/query that includes
daily totals?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.