Search results for query: *

Thanks a million

How would I get the end result of the running sum to appear in the report footer?

I have been able to get the correct result by setting up a running sum text box for each group. The report is actually a few hundred pages long as there are about 36,000 records. However, this is quite cumbersome looking and does not provide for a professional looking report that provides the...

I'll try to explain this the best I can hoping one of you can help. I have created a report that groups records based on a common reference. In some cases, the group may contain 1 record or it may contain 100. Each record has different field values, many of which are dollar values. Within...

Hence, my name: I'm Confused But it worked just fine, thanks for the help, this is a lot better than trying to figure it out by reading "Access For Dummies".

Les, I'm not sure I understand. Is this an expression?

I need to perform a sort within my query or create a sub query that performs the needed function. Within a particular field, each record contains a 5 digit numeric value. I need to sort/group this field based on the last digit of the numeric value of each record. I feel like I may need to...

Thanks, I finally got it to work using a combination of all of the suggestions. I had to use the Nz function in the JOQ Dollars field to convert the nulls into "0". Once that worked, everything else fell into place.

I take that back, it did work except where there was a null value in some of the records (in one field). For the first several hundred records, the JOQ Dollars was null.

Well, the query accepted the expression, however, no values are being displayed (I did check the "show" box). Below is the expression with the actual field names. BTW, thanks for your time. IIf([Inducted Dollars]>=[JOQ Dollars],[Inducted Dollars],[JOQ Dollars])

The table I am querying is very large (approx 38,000 records). Many of the fields contain certain values (dollars). Some of the fileds are reporting values that should match the value in a separate filed (within the same record). For reporting purposes I need to use the value in field...

I am trying to build a query that will compare values in 2 different fields then display the greater value. Any ideas?