Search results

Hi sorry think our posts crossed. It worked what you suggested :) Thanks very much!

I found the hide duplicates options :) However the count appears after the first record now not the last :(

Hi, I guess there is something simple I'm missing here but can't find how to prevent the count on a report from repeating after ever record in the report. I have a text box below the feilds. In properties>data>control source I have =Count(*) The count is good but it repeats after every record...

Ok, I think I have a problem in that the feild I'm focusing on is a lookup feild so it is grabbing the id number rather than the name. Any idea how I shift focus to the name?

Thanks Bob for the 3 examples - I should have said it is for a text field (staff names) sorry. I pick the name from the combo and it filters straight away, I need it to filter only when another button is pressed. Is there any way to pipe the data selected from a standard lookup list into an...

Hi, I have a form and I need to be able to filter it from the selection of a drop down list on the form. I don't what it to filter automatically once a selection is made from the list but I need it to filter on button press using the selection from the list and to only show records that include...

Beautiful, it works :) Many thanks

Thanks. What about DateDiff("d",[ Date_Received],Now()))-(DateDiff("ww",[ Date_Received], Now()))*2)>18 AND ([Date_Acknowledge]) = IsNull ??

That works great thanks. I forgot I need another date field to be blank for the expression to be true. I have added this to the end of the expression but no good AND [Acknowledge_date ] = isnull

Hi, I'm trying to use an expression in conditional formatting on a date field. I want the date to turn red if it is more than 18 workdays older than today's date (now). I'm using DateDiff("d",[Date_Received],[Now()]) > 18 Not working though Thanks

Awesome :) Thanks very much

Hi, I'm trying to build a query to generate a report based on the difference between two dates being greater than 5 days. On the query setting the criteria for the "date_acknowedged" field I'm trying to write a statement that says if it is 5 days greater than the "date_received" field. Something...

Brilliant! Thanks very much. :)

Hi have been trying all day to do this simple task. I want to filter a form to show records that have a certain date field blank. I'm using a query (as a macro does not seem to like Is Null or Null or any other syntax of Null in relation to a date). I have linked the query to a button, but on...