Search results

Hi all, I'm trying to amend a query on the fly, but it includes a function and i'm getting all confused with how I write it in vba so that I can change it (if that makes sense!) Here is the sql of the query as is: SELECT DISTINCT tempExport.ROUNDCODE, tblpafdata.Str, tblpafdata.PCD...

Hi all, Here's hoping you can help, this is driving me nuts! I have a report that is grouped by 'Roundcode', and I want to be able to print duplex, but in order to do that, I need to be able to make sure the first page of each 'Roundcode' starts on a new page. I've searched and searched and...

Hi everyone, In desperate need of help! :o) I have two temp tables, temp_qryTotals and temp_qryTotalsOnService temp_qryTotals: sDate TimeSlot sCount eCount temp_qryTotalsOnService: sDate TimeSlot osCount What I need to do is if there is a record in temp_qryTotalsOnService, where the...