Search results

Hi Ian, You don't say where you're performing the calculation but try the Iif statement; Iif([Start_date]="", do the calculation,0)

SikSlk, You put me on the right track but I had to add some stuff, some of which is actually redundant but here it is in case it's of use to you. Many thanks :D 1. Number of Annual Payments: IIf([contract_billing_frequency]>0,12/[contract_billing_frequency],0) 2. Amount of Period Payment...

Hehe, may have a solution for you. Create two new queries with only Job_id and date, and only user_id and date. Job_id and user_id should be 'group by' on the grid Totals row and date should be 'Max' on the grid Totals row. This will pick out the last date per job/user in each query then you...

Thanks Sikslk, I'll give that a try and let you know. I was beginning to think I'd beaten everyone :)

I'm no expert but the easiest way would be to change your line numbers to a Text field and change them to be 0010, 0020 etc?

I have an Access 2002 table with contract_start and contract_end dates, plus annual_payment and payment_frequency (in months i.e. 0 (net 30 days), 3 (quarterly), 6 (half-yearly) and 12 (annually). I need to extract a query that will tell me when the payments are due by working back to the...

Many thanks Alan, I'll stop scratching my head now :)

Can anyone tell me how to generate a query that shows the results for the 'Last 12 Months" based on a Date field?