Niteshift

I have a list view of all sales... i want to make a summary box that always shows up and tells me the total sales of all records in the found set... when i do sum(units) i get 1 and when i do Count(units) i get 2... why cant it just add all sales from ALL the records showing??

I would like to have a status windows that shows if a statment has already been paid. I have one file with the statement and the status windows and another file that contains an associtated record based on its serialnum. What i need is to have something like (if serial number exist in file paidcommison then show COMPLETED otherwise show UNCOMPLETE) possible? tony

I have a field for "units sold" and when there is a cancelation I simply put a negative number relative to the amount of the cancelation. What i need to do is have SUM(units sold) calculate only positive units and then another field with SUM(units sold) and add all the negative units... this way i get a total of cancelations and a total of sales seperately...is this posible?

In the spirit of continuing to move forward... ive changed the system of period to include year... which makes an ideal primary key.. so i still have 52 periods to a year but we are now in period 5102 instead of just 51, therefor being unique as well... am i moving in the right direction??? lol

fixed it! Case( Month Ref="d

If Month Ref is janvier and Year Ref is 2002 then it should return de janvier de l'ann

hmmm... key? ms access type key or "the unique identifier" is agent

there is 1 file for sales... Each sale is a new record and it contains the period and agent for the sale. I have another file for commissions that i need to have show all the sales for the given period and print a statement for that period. I therefor issue a check and attach this to it to show what i am paying. When i create a new record in commissions i put in the period and it will show all sales for the period... how do i make it also do so by agent? If i change the relationship to agent i can then get all the sales for a certain agent...but not by period.

I am trying to generate a commisions report for salespeople. The Sales are divided into a 52 period system (weeks in a year). I need the commissions database to break down the sales by period AND by agent fields... When i make the relationaships it works great for either the period or the agent but not both. It disregards the other relationship. So i am doing sum of of Units sold....however i want sum of units sold during a specific period.