Search results

Thank you for your response. I will try this. As you can see I am a beginner and that was rookie mistake. I know better now but have to deal with the monster i created. Thanks for the assistance.

I have an existing table that has calculations. When I added a new field with an default value of zero, it did not populate the existing records. Now my tables are not calculating. How can I update the existing records with the new default of zero. Please Help.:confused::confused:

Thank you everyone ! It worked like a charm.

Yes,the results could be null. How can I revise it to prevent the overflow. I think that may be the answer! Thanks

I have tried the repair option but it didn't help. Employees and Productivity are both tables. The Productivity table has calculated fields.

SELECT Employees.Sites, Employees.[Employee Name], Employees.[Employee Number], Productivity.[Product Date], Productivity.[FD Prep time], Productivity.TWC, Productivity.[TWC Equiv], Productivity.[FD Tracking], Productivity.[FD Tracking Equiv], Productivity.[FD Pend Returns], Productivity.[Pend...

I am working on a database and I running into an overflow error in my query. It was working find with the simple <2.5 which is the less productivity allowed for employees. Now I am suddenly getting this error overflow. I have removed the other 2 filters that are in the query and they do not...

Thanks. I am new and did not know.

I am working on a database and I running into an overflow error in my query. It was working find with the simple <2.5 which is the less productivity allowed for employees. Now I am suddenly getting this error overflow. I have removed the other 2 filters that are in the query and they do not...

Hi I am not new to access but am in no way an expert. I live in Texas and am working on a database. It has been a while 2003 since I worked in access and I am a bit rusty;)