Unable to add new records

[todgers]

Hiya

I have created a query (Weekend) from 2 other querys (BCV & Daily Sales). The BCV & Daily Sales queries work fine but when they are added together I am unable to add new records. I only have 1 line of data that can not be updated.
I thought it was a relationship problem and have been and double checked all the relationships but can't see an error.
Heres a screen shot if it will help!

Thanks in advance

 

[Pat Hartman]

If your queries use aggregate functions, they will not be updatable.

 

[todgers]

If your queries use aggregate functions, they will not be updatable.

Sorry what does that mean?

 

[Pat Hartman]

Sum(), Avg(), Min(), Max(), etc. are all aggregate functions.

 

[todgers]

OK I think I've foung the problem table and I've checked for 'aggregate functions' but cannot see any. Is there any way I can search for them?

 

[Pat Hartman]

You'll need to post the SQL. If the query is based on other queries, you'll need to post those also.