Recent content by loopyl00

I think i've solved it with NZ SumPoints: ([qryRankAc].[Points]+[qryrankmarge].[Points]+[qryRankSales].[points]+Nz([QrySumOriginesVendeur].[SumOfOrigines]))

Actually I thnk i've solved it with NZ SumPoints: ([qryRankAc].[Points]+[qryrankmarge].[Points]+[qryRankSales].[points]+Nz([QrySumOriginesVendeur].[SumOfOrigines]))

Could you please clarify how it handles NULL or how I get it to assign 0 for Null I have another query that pulls several queries together to add up the poitns, at the moment if this field is NULL it is not totalling that line SELECT qrySumofAc.FKVendeurID, qryRankAc.Points...

Thanks I can see that this will work however, when entering data in the table, the drop down is showing 1 and 2 Also when i put this into a query to SUM it is returning a value of 2 for marketing, basically, I need to report how many 'prospect' for each ID over a date period, so want...

Hi I'm not sure if I'm having a similar problem I have a table where I have a drop down for the user to select one of two options 'Prospect' 'Marketing' elsewhere i need to convert Prospect to 1 and Marketing (and non entries) to 0 for reporting purposes do i need to Cint At the moment I...

all working perfectly accept i can't seem to sum the machines sold per vendeur per date So i tried to adapt it RqrySales Weekly Machines Sales Data (table) [Date de Vente] [Machines Sold] Summed and Descending [FKVendeurID] Distinct - Properties set to unique value Weekly Machines Sales...

I have it working successfully - yay Rank: (Select Count(*) from DistinctCount Where [CountofMachines Sold] >[Prod1].[CountofMachines sold])+1 i created a second query DistinctCount where it has a unique value however as soon as i enter any date criteria i am back to the original problem...

Tried and failed to get my head around this support.microsoft.com/kb/208946

i have used you're sample data here and experience the same problem :( see attached is screenshare on skype poss?

I think i've figured it out - it's if there is a tie 0- how do i edit the code so that if two people have the same rank, it just carries on counting i.e. 1 2 3 3 4 5 5 5 6 6

At 2 am and after many hrs of heartache it tastes fantastic, too wired to sleep, slight problem now though that the form is ranking as per all data not as per the data select in the Date field -!:mad: Ideally a Date Range would be better here and i wish i could lose the combo box field...

Wow that is EXACTLY what i want, i'm so close I can taste it

I have been trying for agest to get a ranking expression that works I have a sales table [weekly sales data] where each [vendeur] has sold [machines sold] and [accounts open] I want to rank who has sold the most and in a seperate ranking who has opened the most accounts - and by date I...