--Tally records--- in one line 1

[lmcate2]

i am new to reports...
I have a database report that I will like to show the following:

1 - 14 A RECORDS
15 - 27 B RECORDS
28 - 40 C RECORDS
41 - 50 D RECORDS


Thanks,

SM

 

[lupins46]

You will have to provide more info.
What are your input records?
What does your example mean?

 

[lmcate2]

What I mean is that records is a fieldname, The value in this field is "Raddison","Hilton","Best Western","La Quinta"
so I want to be able to find the records sequence for all the Radisson's, Hilton.

SM

 

[dhookom]

I agree with lupins46. Please provide some sample records with field names and then how you would like these sample records to appear on your report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[lmcate2]

Thank you lupins46 and Duane. Here is the report sample layout. The record sequence is what I have trouble in getting in the same line starting with number 1 to 15..

RECORD SEQUENCE HOTEL TOTAL PROPERTIES
1 -15 HILTON 15
16-20 RAMADA 4
21-50 SHERATON 29
51-55 HOLIDAY INN 5
56-100 BEST WESTERN 44
ETC......
========
Total 97

 

[dhookom]

Is this your data or your desired display? If it is one or the other, we don't have a clue about the missing information. Is it too hard to respond with the answer to a simple question?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[lmcate2]

Thank you again guys, here is my fields

Propertyid n (autonumber)
HotelChainame c 50

So I want to tally by HotelChainame and count them. My question is to get the propertyid is starting and ending for each of the Hotelchainame starting - ending (1-30).

Thanks,

SM

 

[dhookom]

Can you use something like:
SELECT Min(PropertyID) & "-" & Max(PropertyID) as RecordSequence, HotelChainame, Count(HotelChainame) as TotalProperties
FROM tblYourTable
GROUP BY HotelChainName;

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[lmcate2]

Duane:

Thank you for your assistance this is what I need it .

SM