Search results for query: *

Code might be an option. How would you go about doing it?

I am trying to build a macro in order to send a custom email to multiple people out of a single table. The email will have a list of the individuals buying habits so some individuals might have 4 lines and others will have 10 lines. The Sendobject function does not seem to have this ability...

Can you generate an email from Access? For example, if an invoice goes past due by a set number of days, is there some way a system generated email can be generated from access and sent automatically?

Thanks for all the help everyone. I found it in the sort criteria.

I have a large report with MANY fields involved. When I look at the table in feild explorer, there is a green check mark next to a field, but I cannot find where this field is being used on the report. I went through all the formulas as well, and could not see this field being referenced. Any...

Thanks so much. I learned something else today!!!

Worked beautifully. Now another silly question: How do I relect what date range the report is showing in the report header?

I have to put some reports on Crystal Enterprise. The first will be scheduled to run weekly on Monday morning to show all activity for the previoues week (Sunday to Saturday). The second will be similar, except it will be scheduled to run on the first day of the month, showing all the...

NICE!!!! It all works perfectly. Thanks so much for the help.

I believe this worked corectly showing me the grand total number of past due accounts. Now to add to the confusion I have this report grouped by: #1 - Division #2 - Collector Name I need to subtotal past due accounts by both groups as well as the grand total. Thaks for all your help MJRBIM!!!!!!

My past due formula is: if Maximum ({@Days past due}, {ARMAST.CUSTNO})>0 then "Yes" The @Days past due formula is : datadate - ({ARMAST.INVDTE}+{ARMAST.PNET}). Basically, todays date minus the invoice date plus the terms.

I tried this but the Insert Subtotal, Grand Total, and Summary options are greyed out.

I have a formula field that indicates whether or not the customer has a past due balance. I need to get a COUNT of all the past due accounts from this formula field. When I try creating the formula, I receive the error "The summary/running total field could not be created" I am using...