Recent content by programmingmiss

I solved it; need to clean the data.................thx!!

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.

C J London; Thank you for the orientation and I had the Caps on b/c of access; I forgot it/'s like shouting. Also, I tried other words for calculated variable like sumofprodab, but I'll keep an eye out for reserved words. A 1,000 THANKS (caps intentional this time). ;-)

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 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...

HI plog, you helped me before a I have a similar ? re: duplicates. For a given field in 1 table, I want to select ONLY UNIQUE values in a query, I've been exporting a large file to Excel, where I cando this, but it would be more efficient to do in Access. Help? thx!!!

ACTUALLY, I GOT IT!!!!!! THX TO ALL AND Mihal, I didn't want to send files, b/c some the analyses are considered CBI; thx 4 offer. NOW TO LEARN ABOUT APPEND QUERIES TO ADD VALUES IN THE SUB-TABLE.

Thanks to all 3 of the responders; I just bought U a cup of virtual java ;-) First, Pat, # is now type text, I learned that the hard way when I needed to sort :-( Plog: I'm half way there. I ran and update query and was able to enter a N (for Null) in all TYPE fields in Master, but I can't...

Plog: I understand where UR going. GREAT ADVICE! I've imported the excel file into ACCESS (let's call it subset table), it has 1 data element, call it ID # that exactly matches the ID# (although slightly different name) in the Master Table and the Master Table has a new field (TYPE) to hold...

Table has data element (ID number); type is number egs of values 00002, 234432, 33222,4444, (for approximately 50,000 records) of the 50,000 I need to flag approximately 10,000 (I have a list of numbers that match 00002, etc, but there is no particular order or pattern, just some meet the...

UR comment got me thinking, maybe I could export entire large table to excel and add two fields (column that match) data in field (think 3 rows of SS # w/ different labels) and run query where data element 1 = data element 2. that would lead to a easier question; how to operationalize that...

First, many thanks plog! There is no pattern; I have an Excel file w/ a few thousand records and I want to run queries for that subset. They exactly match approximately 1/3 of records. I can go back and forth b/c ACCESS/EXCEL, IF it's is easy to sort/match that way, but I ultimately need to...

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...