Search results

I've figured it out, thanks a lot Plog, there was an issue with the date format, it seems that the #" & d & "# creates a US formatted date, while all my data is UK format, I searched the internet and found lots of people having the same issue and that there is now way around it. So I tried...

Thanks a lot for that Plog, I certainly need to use it for a query, and it has worked really well, but not perfectly, some of the rows I'm not getting a value i'm looking for, hopefully it just needs a bit of tweaking

Hi, I am trying to produce a field in a query that gives the running total, but then resets if there is a zero. So for the table below, i would like to produce the field Wins in a Row Date- Team- Win- Wins in a Row 29-Oct-06- Liverpool- 1- 1 12-Nov-06- Manchester- 1- 1...

Great, thanks a lot for that John, never knew that was possible, a much more elegant solution, and all the better for it :D

Hi, I am new to this forum and would really appreciate some help please. I am trying to use VBA to take a value from a dropdown combo box in a form, and use it to filter a query. I am able to get the value of the dropdown into vba, but am getting stuck applying it as a filter. Here is some...