TM Forums Backup 2: The Backening

MS Access Help Please

#	Post
1	I'm fairly new to Access. When attempting to run a Parameter Query for a training exercise I'm doing, I get the following "HAVING clause (Employee.[Employee ID]=[Enter Employee ID]) without grouping or aggregation" - where would you suggest I go looking for the reason why it's generating this "HAVING clause" msg please? I understand the concept, I just can't see why it just won't generate the Employee ID's I've entered in the practice data tables. Thank you. To recap: Access should just generating a "Enter Parameter Value" box, into which I enter the Employee number and it generates some data from two linked tables. All the other practice exercises work, but this one generates a "Having clause" msg, where would I find that issue please? According to the practice exercise guide, nothing needs grouping or aggregation. Edited by mmmail at 5:36 pm, Thu 29 Oct mmmail - 2020-10-29 17:35:00
2	'Having' is normally used in conjunction with a 'group by' eg https://www.w3schools.com/sql/sql_having.asp if no grouping is required then maybe just a WHERE clause is all you need Edited by king1 at 5:47 pm, Thu 29 Oct king1 - 2020-10-29 17:45:00

Post

I'm fairly new to Access. When attempting to run a Parameter Query for a training exercise I'm doing, I get the following "HAVING clause (Employee.[Employee ID]=[Enter Employee ID]) without grouping or aggregation" - where would you suggest I go looking for the reason why it's generating this "HAVING clause" msg please? I understand the concept, I just can't see why it just won't generate the Employee ID's I've entered in the practice data tables. Thank you.

To recap:
Access should just generating a "Enter Parameter Value" box, into which I enter the Employee number and it generates some data from two linked tables. All the other practice exercises work, but this one generates a "Having clause" msg, where would I find that issue please?

According to the practice exercise guide, nothing needs grouping or aggregation.

Edited by mmmail at 5:36 pm, Thu 29 Oct

mmmail - 2020-10-29 17:35:00

'Having' is normally used in conjunction with a 'group by'

eg https://www.w3schools.com/sql/sql_having.asp

if no grouping is required then maybe just a WHERE clause is all you need

Edited by king1 at 5:47 pm, Thu 29 Oct

MS Access Help Please

mmmail - 2020-10-29 17:35:00

king1 - 2020-10-29 17:45:00