Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Sorting and Grouping field in my report. With in that grouping I
have =Count([StoreNumber]) that gives me a total for each grouping. Is there
any way I can sort the report by the result of the Count number?
 
Create a separate totals query that is similar to your report's record
source. Group the new query by StoreNumber and calculate the count. You can
then add this query to your report's record source and join the StoreNumber
fields. This allows you to place the Count in your report's record source.
 
Can not get the query to calculate the count by group.

Duane Hookom said:
Create a separate totals query that is similar to your report's record
source. Group the new query by StoreNumber and calculate the count. You can
then add this query to your report's record source and join the StoreNumber
fields. This allows you to place the Count in your report's record source.

--
Duane Hookom
MS Access MVP


Richardb said:
I have a Sorting and Grouping field in my report. With in that grouping I
have =Count([StoreNumber]) that gives me a total for each grouping. Is
there
any way I can sort the report by the result of the Count number?
Click to expand...
Click to expand...
 
Share your table structure and your sql view of your group by query.
Your report's record source would be nice also.

--
Duane Hookom
MS Access MVP


Richardb said:
Can not get the query to calculate the count by group.

Duane Hookom said:
Create a separate totals query that is similar to your report's record
source. Group the new query by StoreNumber and calculate the count. You
can
then add this query to your report's record source and join the
StoreNumber
fields. This allows you to place the Count in your report's record
source.

--
Duane Hookom
MS Access MVP


Richardb said:
I have a Sorting and Grouping field in my report. With in that grouping
I
have =Count([StoreNumber]) that gives me a total for each grouping. Is
there
any way I can sort the report by the result of the Count number?
Click to expand...
Click to expand...
Click to expand...
 
This is a lot of info to put in a post. Is there an easy way to post?

Duane Hookom said:
Share your table structure and your sql view of your group by query.
Your report's record source would be nice also.

--
Duane Hookom
MS Access MVP


Richardb said:
Can not get the query to calculate the count by group.

Duane Hookom said:
Create a separate totals query that is similar to your report's record
source. Group the new query by StoreNumber and calculate the count. You
can
then add this query to your report's record source and join the
StoreNumber
fields. This allows you to place the Count in your report's record
source.

--
Duane Hookom
MS Access MVP


I have a Sorting and Grouping field in my report. With in that grouping
I
have =Count([StoreNumber]) that gives me a total for each grouping. Is
there
any way I can sort the report by the result of the Count number?
Click to expand...
Click to expand...
Click to expand...
 
You can view the sql of your group by query and paste it in a reply. Your
earlier reply doesn't provide:
- what you tried
- what the results were
- how you attempted to trouble-shoot
- your SQL view of any query
You are the only one who can see your application and attempt to make
changes. If you don't provide a minimal of required information, no one can
provide assistance other than WAGs.

--
Duane Hookom
MS Access MVP
--

Richardb said:
This is a lot of info to put in a post. Is there an easy way to post?

Duane Hookom said:
Share your table structure and your sql view of your group by query.
Your report's record source would be nice also.

--
Duane Hookom
MS Access MVP


Richardb said:
Can not get the query to calculate the count by group.

:

Create a separate totals query that is similar to your report's record
source. Group the new query by StoreNumber and calculate the count.
You
can
then add this query to your report's record source and join the
StoreNumber
fields. This allows you to place the Count in your report's record
source.

--
Duane Hookom
MS Access MVP


I have a Sorting and Grouping field in my report. With in that
grouping
I
have =Count([StoreNumber]) that gives me a total for each grouping.
Is
there
any way I can sort the report by the result of the Count number?
Click to expand...
Click to expand...
Click to expand...
 
Duane,

Here is the SQL:

SELECT master_tabl_D27L_baydetails_information.StoreNumber,
master_tabl_D27L_baydetails_information.BayNumber,
master_tabl_D27L_baydetails_information.Class,
master_tabl_D27L_baydetails_information.[Sub Class 1],
master_tabl_D27L_baydetails_information.BayHeight,
master_tabl_D27L_baydetails_information.BayDepth,
master_tabl_D27L_baydetails_information.BeamWidth,
master_tabl_D27L_baydetails_information.[2-0],
master_tabl_D27L_baydetails_information.[2-5],
master_tabl_D27L_baydetails_information.[3-0],
master_tabl_D27L_baydetails_information.[3-5],
master_tabl_D27L_baydetails_information.[4-0],
master_tabl_D27L_baydetails_information.[5-0],
master_tabl_D27L_baydetails_information.[5-5],
master_tabl_D27L_baydetails_information.[6-0]
FROM master_tabl_D27L_baydetails_information
WHERE (((master_tabl_D27L_baydetails_information.Class)="20 CEILING FANS"))
ORDER BY master_tabl_D27L_baydetails_information.StoreNumber,
master_tabl_D27L_baydetails_information.BayNumber;


My report has the count in the Store number footer which is working. This
statement is: =Count([StoreNumber])

I would like to store the report by this resulting number.

Sorry for any confusion on my part in sending the proper info. I hope this
helps and if I am not understanding I apologize.

Richard

Duane Hookom said:
You can view the sql of your group by query and paste it in a reply. Your
earlier reply doesn't provide:
- what you tried
- what the results were
- how you attempted to trouble-shoot
- your SQL view of any query
You are the only one who can see your application and attempt to make
changes. If you don't provide a minimal of required information, no one can
provide assistance other than WAGs.

--
Duane Hookom
MS Access MVP
--

Richardb said:
This is a lot of info to put in a post. Is there an easy way to post?

Duane Hookom said:
Share your table structure and your sql view of your group by query.
Your report's record source would be nice also.

--
Duane Hookom
MS Access MVP


Can not get the query to calculate the count by group.

:

Create a separate totals query that is similar to your report's record
source. Group the new query by StoreNumber and calculate the count.
You
can
then add this query to your report's record source and join the
StoreNumber
fields. This allows you to place the Count in your report's record
source.

--
Duane Hookom
MS Access MVP


I have a Sorting and Grouping field in my report. With in that
grouping
I
have =Count([StoreNumber]) that gives me a total for each grouping.
Is
there
any way I can sort the report by the result of the Count number?
Click to expand...
Click to expand...
Click to expand...
 
I don't see any SQL from the group by query that I suggested. I might be
something like
SELECT StoreNumber, Count(*) as NumOf
FROM master_tabl_D27L_baydetails_information
Group By StoreNumber;
You can save this query and add it to your query below. Join the StoreNumber
fields.

I don't understand your table structure. It seems a bit un-normalized.

--
Duane Hookom
MS Access MVP


Richardb said:
Duane,

Here is the SQL:

SELECT master_tabl_D27L_baydetails_information.StoreNumber,
master_tabl_D27L_baydetails_information.BayNumber,
master_tabl_D27L_baydetails_information.Class,
master_tabl_D27L_baydetails_information.[Sub Class 1],
master_tabl_D27L_baydetails_information.BayHeight,
master_tabl_D27L_baydetails_information.BayDepth,
master_tabl_D27L_baydetails_information.BeamWidth,
master_tabl_D27L_baydetails_information.[2-0],
master_tabl_D27L_baydetails_information.[2-5],
master_tabl_D27L_baydetails_information.[3-0],
master_tabl_D27L_baydetails_information.[3-5],
master_tabl_D27L_baydetails_information.[4-0],
master_tabl_D27L_baydetails_information.[5-0],
master_tabl_D27L_baydetails_information.[5-5],
master_tabl_D27L_baydetails_information.[6-0]
FROM master_tabl_D27L_baydetails_information
WHERE (((master_tabl_D27L_baydetails_information.Class)="20 CEILING
FANS"))
ORDER BY master_tabl_D27L_baydetails_information.StoreNumber,
master_tabl_D27L_baydetails_information.BayNumber;


My report has the count in the Store number footer which is working. This
statement is: =Count([StoreNumber])

I would like to store the report by this resulting number.

Sorry for any confusion on my part in sending the proper info. I hope
this
helps and if I am not understanding I apologize.

Richard

Duane Hookom said:
You can view the sql of your group by query and paste it in a reply. Your
earlier reply doesn't provide:
- what you tried
- what the results were
- how you attempted to trouble-shoot
- your SQL view of any query
You are the only one who can see your application and attempt to make
changes. If you don't provide a minimal of required information, no one
can
provide assistance other than WAGs.

--
Duane Hookom
MS Access MVP
--

Richardb said:
This is a lot of info to put in a post. Is there an easy way to post?

:

Share your table structure and your sql view of your group by query.
Your report's record source would be nice also.

--
Duane Hookom
MS Access MVP


Can not get the query to calculate the count by group.

:

Create a separate totals query that is similar to your report's
record
source. Group the new query by StoreNumber and calculate the count.
You
can
then add this query to your report's record source and join the
StoreNumber
fields. This allows you to place the Count in your report's record
source.

--
Duane Hookom
MS Access MVP


I have a Sorting and Grouping field in my report. With in that
grouping
I
have =Count([StoreNumber]) that gives me a total for each
grouping.
Is
there
any way I can sort the report by the result of the Count number?
Click to expand...
Click to expand...
Click to expand...
 
Duane,

Thanks for your help. I think you have me going in the right direction.

Richard

Duane Hookom said:
Create a separate totals query that is similar to your report's record
source. Group the new query by StoreNumber and calculate the count. You can
then add this query to your report's record source and join the StoreNumber
fields. This allows you to place the Count in your report's record source.

--
Duane Hookom
MS Access MVP


Richardb said:
I have a Sorting and Grouping field in my report. With in that grouping I
have =Count([StoreNumber]) that gives me a total for each grouping. Is
there
any way I can sort the report by the result of the Count number?
Click to expand...
Click to expand...
 
Back
Top