Search results for query: *

Thanks Crowley - very useful!!! I've implements it now and it works fine. Thanks, Barry

Hi guys, Not sure how to go about this!! I have a field called ShipDate which, as the name suggests, prints the shipping date onto a report. If we don't know the shipping date, then it is left blank. Presently, the ShipDate is in ShortDate format on the report, and i'm trying to work out how...

Paul, Before you delve too far - it appears to be working now - i had a bracket in the wrong place that i've corrected as it was uploaded and it works perfectly! Thanks for all your help! Barry

Thanks Paul - I've modified the RecordSource and put in place all the coding for the different sources, I should have checked that using common sense really! It's still not returning the figure based on date - again i tried to run it twice with the month of february and the month of march so...

Hi Paul, I managed to get this bit down without a problem, but when i enter a different date range, i get the same results! Any clues? Thanks, Barry

Hi Paul, Thanks for the continued help - the easiest way to explain is by example... I've uploaded a stripped-down version of our invoicing database to http://www.rtd.uk.com/tektips/database.mdb (16Mb) for you to take a look at if you don't mind - the report in question is Source Breakdown...

Thanks Paul - I've tried this, but it's not counting as per the date period set. For example, it returns a result of 58 regardless whether the date is 2/1/05 to 2/28/05 or 3/1/05 to 3/14/05. Any ideas? I've basically adapted an existing report, which takes the order date and identifies the...

Hi all! I'm trying to persuade a report to count the number of occurrences of particular words, e.g. 'Google' for a specified date range (as entered on form) and display the result on the report (as a number). I've tried every combination i can think of, but i can't get it to work! I've...