Search results for query: *

No wonder I didn't understand it! :) Thanks. I'll work on your original suggestions again. Now that I understand the formula; that will be of help.

Row headings are Customer_ID and Part_ID. And the other would be the Past_Due sum. I didn't understand the first part of your original post. It looks like a date is being multiplied by a numeric quantitiy. I couldn't get it to work for whatever reason. Should I continue working with your first...

Duane Sorry it took so long for me to respond. I've been trying to get this to work, but can't. The basic problem seems to be when I try to accumulate the past dues they get filtered out because I'm only showing the last five days of the date range on the crosstab. I've tried using a make-table...

I have tried several ways to build this crosstab query, but can't get results. Result Desired: A crosstab query with row heading-partID and column heading orderDate, the value is quantity. A query for each customer. This isn't a problem so far, here's the twist: I want to sum the past due...

I have a form that has a field called Show Order. This is the order in which the entries in a sports event are going to perform. An entrant may request that they perform in position 5, and there may be 20 entries already listed for the event. What would be the best way to insert this entry as...

Perfect! Thanks for your timely response.

I'm importing a text field, and the negative numbers are in parenthesis. They come into the table field as an error, #Num!. How do handle this? Thanks.