Search results

I have a table with a field type employee type (text): It has values of: P or PF employee type = P (pension (some) employee type = PF (pension, full) When I do a simple sort of data in the table , the #s don't add; When I select P AND! PF, I get 7,000, and only F = 4,000, but just P and...

I hope to contribute more as I become more versed, so pls. know I'll return the favor soon. Right now I can't even find the post button, it isn't obvious; any help? Thx, one tired analysts who needs coffee, which I luv.

i WANT TO CREATE A NEW POST ABOUT A CALCULATED FIELD IN QUERY, BUT i CANT LOCATE THAT....READ SIMILAR POSTS. I WANT TO DO A SIMPLE THING ADD 2 VALUES (BOTH NUMBER TYPE) AND FROM SAME TABLE IN DESIGN VIEW IN QUERY I DEFINED SUM: [VARIABLEA]+ [VARIABLEB], BUT i GET AN OVERFLOW ERROR, WHICH IS...

I have a list of numbers in a table w/ 10,000s of records and a want to mark a subset of those with a character designation or somehow query based on subset. For example, field is social security No (type is number) and I have a subset of SS# I want to mark as R (retired) or D (deceased). Can...