Recent content by Knape97

Hi Guys. Not sure if this is possable, and I have absolutly no idea how to go about what I need doing so fingers crossed you can help :) (The stuff I will put here is a lot more simplified than my actual system, but it should explain what I require) In a Table (Table1) I have the following...

Once again PHV you have excelled yourself. Thank you, it works a treat.

Didnt quite understand that last msg? The SQL posted is exactly what Access produced, are you suggesting that I remove the brackets?

This is what I have so far, however it produces a "Opperation must use and updatable query" error UPDATE Tbl_Stats_Temp SET Tbl_Stats_Temp.Moving0405Null = (SELECT COUNT(*) FROM Tbl_Staff WHERE (((Tbl_Staff.Moving0405) Is Null))) WHERE (((Tbl_Stats_Temp.StatID)=1));

Hi Guys I am trying to run a query that will select all the fields related to a Property (Service) that is based within a user specified county. I then need to have the query also show any tenants associated with the services that are NOT set as NLU (no longer using) Anywho, I can get the...

Got a related question to this now. In a separate query I need it to Count where the StaffActive field is Null from Tbl_Staff. However, I need this to update to InactiveStaff in Tbl_Stats where StatID=1 Had a little play around with PHV's append query, but i coudnt get it to work as a modify...

Excellent; Thanks guys, that works a treat. Many thanks for your help

Cheers guys for the responses. To clarify what i need. I need it to scan the moving0405 field, and count the Null values. Then, say there were 5 Nulls it would enter "5" into the new table. LesPaul's looks to be the one that would do that, but when I try to save the query i get the error...

Hi, hopefully someon can point out what I need to do to get this working as it has me pullin my hair out. I have a query that has the following SQL; SELECT Tbl_Staff.FirstName, Tbl_Staff.LastName, Tbl_Staff.Service, Tbl_Staff.Moving0405 FROM Tbl_Staff WHERE (((Tbl_Staff.Moving0405) Is Null))...