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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
"ȉ" - Why do these boxes keep appearing in my query results!
It is ok, panic over, I figured it out. I had question_description set up as a memo field and therefore Access had difficulty grouping on it. Thanks anyway.- bondidude
- Post #2
- Forum: Microsoft: Access Reports
-
"ȉ" - Why do these boxes keep appearing in my query results!
I have written a query that has a table of Questions with a question_id and a question_description. This links to a table of results where there is a persons client_id, question_id and result_id. I am trying to write a query that averages the result_id per client per question, but displays it...- bondidude
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Crosstab Queries in MS Access
Thanks Steve, that worked a treat. I hadn't come across parameters before. Incidentally, yes Sydney, Aust would be correct. Cheers Nik- bondidude
- Post #3
- Forum: Microsoft: Access Reports
-
Crosstab Queries in MS Access
Hi, I am trying to run a crosstab query which has input from a form as criteria in its where clause, but I keep getting told that the 'Microsoft Jet Database doesn't recognise [Forms]![Form Report]![Cert] as a valid field name'. I find this strange seeing as I have form fields as criteria in...- bondidude
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
