Search results

I would like to know if there is a way to find unmatched data in a table when compared against 8 other tables? Each table has 20 records. Thanks!

Thanks! So easy!

Would I be able to get more help?? :confused:

I am pretty new at Access and would like to know how I can strip the last 3 alphanumeric char in a field. Easiest way preferred. Thanks! I.E. 51-0054.01 51-0054.02 51-0054.03

My apologies...Field 1 may or may not be common in number up to the 9th char position. Of the ones that are common based on this, I want to average Field 3. For the ones that aren't common up to the 9th char position, I do not want to average. Table contains some 7000+ records. Sorry!

I need some help on how I could approach getting this task done. I have a table with 3 fields. Field 1 Field 2 Field 3 Condition: If (Alpha) is duplicate in Field 2 and the (numeric) value in Field 1 is common for the first 9 of 10 alpha-numeric char, then average Field 3 values. I.E...

Thanks! I figured it out. CrossTab is what I needed. I've never used it before but it is very helpful for this task. Thanks!

:confused: I don't know where to start with this but here goes.... I have a table that looks something like this: ID DOL # Description (Other fields...etc) 5 DOL26 Yamaha 5 DOL4...

Could someone help me? I need an expression that will trim the first 5 characters in a field. I.E. (NEW) A Discussion of..... Need to trim (NEW)..

The update query appeared to give me the results I wanted. It actually added ending zeros to the original numeric value in table. Should this have been done another way?

Wow. That was very simple actually. It worked perfectly! Thanks so much Richo!

Need some help!!! I have a sequence of numbers in a column/table that I need to add ending zeros too. Field length needs to be = 6 bytes total 23 - add 0000 4265 - add 00 etc. I'm thinking a customized expression is the answer but I'm not completely comfortable writing scripts in a module...