What are "Control Breaks" in ADO/ASP ?

What are "Control Breaks" in ADO/ASP ?

Is this what you're looking for?

vbCrLf

what you mean , explain in more detail ?
I have an ado problem saying <<... is a "Control Breaks" problem get advice from instructor >> but the textbook do not cover it ?

Sorry, I thought you were asking for the code to create a break. Post your code and I'll see if I see any problems.

Is just an ado exercise I do not know , how to do "Control Breaks" in ado to solve it ? can you tell me where to find more about the topic I refer ?

Ok - so having had to look up what control breaks are :o I've found this:

In a computer program, a control break occurs when there is a change in the value of one of the keys on which a file is sorted which requires some extra processing. For example, with an input file sorted by post code, the number of items found in each postal district might need to be printed on a report, and a heading shown for the next district. Quite often there is a hierarchy of nested control breaks in a program, e.g. streets within districts within areas, with the need for a grand total at the end.

So.. without seeing your code, I'm guessing you're looping through a list of results, and you need to do something like display a sub-section header. Most of solving this will be via getting your SQL right: grouping and ordering your results correctly. But without seeing your actual code it's going to be very hard to accurately identify the problem, let alone suggest a solution.

... one of the keys on which a file is sorted ... what file ? where ? key <> file relation ? file=record ?

Post. Your. Code.

:thumbsup: