Need help with update Query Acc 2003

[DougP]

UPDATE Projects INNER JOIN ProjectTrackingItems ON Projects.[Project Number] = LEFT(ProjectTrackingItems.[Project Number],6) SET Projects.Quote = [ProjectTrackingItems]![EstimateNumber]
WHERE (((ProjectTrackingItems.[Project Number])="061301") AND ((ProjectTrackingItems.[Tracking CodeNumber])=4));

It says updating 0 records
I checked the Project number and Tracking CodeNumber and they are in the table.

Help !!!!

DougP, MCP, A+

 

[dhookom]

in the table"... but is the project number in both tables? If you view the datasheet do you see any records? This type of question is near impossible to troubleshoot without seeing your actual data or table structures.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[DougP]

Sorry this won't work anyway. I have a one to many relationship bewteen the two tables and...
disregard this post OK

DougP, MCP, A+