enter data in a query

[wdisneymom]

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

 

[MustBNuts]

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

 

[wdisneymom]

tried that but it didn't work either

 

[MustBNuts]

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

 

[wdisneymom]

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

 

[MustBNuts]

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

MBN