enter data in a query

I created a query based on a table
I wanted to edit the data in the query and couldn't. I've done this very often but this time it won't let me

Any suggestions

 

Yup, some queries will do that.

Example: I have a query that pulls in soccer games from a schedule. The way the query is set up, the games are pulled by team, and as a result, the query pulls the record twice, once for the home team and again for the away team. This was done by design (I intended this).

But as a result, I cannot edit any data in this query. Why? Because I am displaying a record twice, if I tried to edit the first of two, what would happen to the second? See?

Take a look at the records that you are pulling and how the query is organized; if you have unwanted duplication, try viewing the query in SQL view and adding the word DISTINCT after SELECT and see if that thins the records.

Hope this helps,

MBN

 

tried that but it didn't work either

 

Okay, then it has something to do with your query structure. If you can, give some details and we can see what's up....

MBN

 

I just looked at my structure and sur enough I was "grouping"
When I removed the "group by" I was able to enter/edit data
Thanks for your help

 

Phew, glad to know it was that easy! Sometimes they are positively hairy!

MBN