help creating & sorting from Query to Report

[Feprincess]

I'm using my query to create a report but I don't want to display all the fields.
I'm trying to sort, but when I choose the fields that I want sorted the values show as zero.
I have to sort by four fields each based on the previous one, but when I try to sort them ascending (in query) the fields are blank, but when I sort descending it works?
Asumming that I get it to work; how would I sort within the prior?
Thanks.

 

[jmh944911]

I'm using my query to create a report but I don't want to display all the fields.
I'm trying to sort, but when I choose the fields that I want sorted the values show as zero.
I have to sort by four fields each based on the previous one, but when I try to sort them ascending (in query) the fields are blank, but when I sort descending it works?
Asumming that I get it to work; how would I sort within the prior?
Thanks.

You should identify if your issue is with the data in the table or the query getting the data for you. I imagine that you have some data that is not anticipated in one or more of the columns.(zeros or nulls) as such your query sort flattens that data.

say your table is this

a 0 z 1
_ 0 z 1
b 0 a 9
b 0 a 8

(_ = null)

if you were query the table and sort all clmns left to right accend
_ 0 z 1
a 0 z 1
b 0 a 8
b 0 a 9

So then your report groups by the first clm, you have a null record as a group header, zeros for 2nd column sort... Those kinds of things generally make it a mess. I would review all the possible values for each column in your table. Ensure your comfort with the data you seek via query.

 

[Feprincess]

Can I make a report based on a Table and a query or is it one or the other?