Recent content by Pusscat

Hi, I have a data report with say 5 columns of data fields A- E. There are 6 rows of data. A___B___C ___D ___E 1__ MS__ ___ 5__10 2 __XX__0___20___5 3 __MS__0___0 ___20 4__ XX__0___20___5 5 __MS__ ___15___10 6__ MS__0___20___5 I want to be able to have a count under each field column...

Hi MStef, Thank you so much! Kind regards, Pete

Hi MSte, Thanks for the suggestion. It's half the way but the Qualifier (less or greater than sign) is effectively attached to the result in your solution. I need the qualifier to be in a column by the side of the result it refers to so I can actually use the results for calculations...

Hi, I’m using Access 2003 and need a little help with a query. Please excuse my ignorance (I’m not too hot with access and certainly not SQL), looked in the guides etc, have tried searching the forums and found myself here. I have a data set: Top row are field names. "Sample-ID"...