Recent content by SpA

Thanks again all Some interesting things there to explore. I'll have a dabble over the next few nights or so and will report back on findings.

Thanks all for the very quick replies. To add some more to my question, I’ll try to give a simplistic example. I have four fields in the same table; Date, Number, Miles & Yes/No The date field is self explanatory, the Number field is a series say from 1 to 10, Miles is the amount of miles...

Hi First time on here. I’m not an expert coder or programmer, merely dabble with the application, but I’m trying to write a query that can output grouped results from the original query and with a WHERE clause together. It seems like you can have one or the other but not both together in the...