New eyes on a quick update query

[Lorlai]

I have an update query that I would like to run. For some reason, there are 21 records (the correct amount), but on the datasheet view, all 21 are blank and contain no data. Does anyone have an idea as to why this might be happening? I have two tables: Products, which is the table I would like to update, and Headcount, which contains the updated data.

UPDATE Products 
INNER JOIN [People Headcount] ON Products.Number = [People Headcount].Project_Number 
SET Products.[People Headcount] = [People Headcount].[Headcount];

Does someone with fresh eyes see why this might be exporting blank records?

Thanks for any help!!

[RuralGuy]

I would start with a SELECT Query and see what is pulled.

[Lorlai]

Hi RuralGuy, thank you for your response. When I run a select statement, I am able to pull 21 visible numbers. I have also tried an append query and again have 21 visible records. Any idea as to why this might be happening with an update statement?

Thank you!

[Lorlai]

EDIT: I have looked all over, and am thinking that maybe the reason I am getting this error is because I am pulling in a saved query. [People Headcount] is a saved query that I am trying to add. Is there a way to incorporate this query into my update statement?

SELECT DISTINCT Product_Number, Count(*) AS Headcount
FROM People_Pool
WHERE People_Pool_Name Like "*Smith-Doe-adams*"
GROUP BY Product_Number;

In plain english, I want my statement to Update the People Headcount on the Products Table when the Product Project Number is equal to the People_Pool Project Number. I want the People Headcount become equal to the above query release.

Is this possible to do in an update statement?


Thank you!


Previous Post:
I tried to sort the empty records, both from largest to smallest and smallest to largest and received the following error:

Syntax error in query. Incomplete query clause.

Any idea what this might be?