[MS_AccessPros] Re: Insert a label within report detail lines

 

Are the Amount values in a increasing order so 500 will be hit only once? Is this a running sum or just a simple numeric value?

Duane Hookom
MS Access MVP

--- In MS_Access_Professionals@yahoogroups.com, "cc" <saigonf7q5@...> wrote:
>
> Good morning all
>
> I have a report's record source is based on a query that has a column named "Amount". I am wondering if it's possible to program the report to insert a label or column headings after the detail lines meet a specific criterion. For example, the value of the "Amount" field has a range from 1 to 1000, when the Amount reaches 501, then insert a label "Amount greater than 500". Can this be done within report?
>
> Phucon
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 4
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___