Select in report

[ChristopherL]

Hi!
I am trying to select a few values for my report, can this be done in the report design view or do I have to make a query and take from that?

I am using access 02!

Pre-thanks!

EDIT: I want to leave out all the values that are 0!

 

[shadow9449]

Either way. You can either set the Report's record source to a saved query/table or you can write the query right there in design view.

SHADOW

 

[ChristopherL]

Either way. You can either set the Report's record source to a saved query/table or you can write the query right there in design view.

SHADOW

How do I write it right in the design view of the report?
I want to leave out 0 from SumOfMARKETVALUE

so

Select SumOfMARKETVALUE FROM USE_Secondary_Trades WHERE SumOfMARKETVALUE>0;

Where do I put it?
never used report tool before!