Search results

Was wondering if someone could help me with finding the easiest way to join 8 different tables by a common field and finding unique records in each that aren't in any of the other 7 tables. Anyone know of an easy way to do this?

Could someone please help me? There is no function in Access 2000 to compute the median of a column of numbers (Currency) from a table.

I have a subform within a form when run will not display. In design view however, I see all the fields from the subform...and all links appear to be fine. Any ideas on what the problem might be?

I'm setting up a form for a friend & would like to know the best way of getting it done. He has surveys that allow for multiple answers for each of 14 fields. There could be different combinations of 5 answers. Please see example: Field = Current Occ Proj - Survey Response = Internet...

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!

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

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

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

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