Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bazzanoid

  1. bazzanoid

    Printing default message instead of blank date

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

    Printing default message instead of blank date

    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...
  3. bazzanoid

    Counting text in reports

    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
  4. bazzanoid

    Counting text in reports

    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...
  5. bazzanoid

    Counting text in reports

    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
  6. bazzanoid

    Counting text in reports

    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...
  7. bazzanoid

    Counting text in reports

    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...
  8. bazzanoid

    Counting text in reports

    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...
See more

Part and Inventory Search

Back
Top