Search results

Hi About 10 years ago I wrote an Access application which is still in use. Over the years certain parts have become superfluous and new parts have been added by a variety of users. Thankfully they have stuck to the original ideal and only used macros and queries - and not modules of badly...

I have a table containing about 120 records of 40 fields containing integer values. The values are 0 (for 'no experience'), 1 - 5 (for evaluation of experience) and 9 (for question not answered). I would like to generate a row of averages for the 40 columns. Access includes the '0's when using...

Hi All I have a table containing Student Details. The table is the result of an Import and contains not-quite duplicate records (the 'not-quite' fields differ so cannot be used in a query). I would like to present the db user with two forms, each containing one of the near-duplicates so that...

Hi All I've had 'experts' across the globe fail on this one - but I feel it MUST be possible. I have a table (we'll call it table1) in which there is an int field containing a number. I have another table (call it table2) which has no records. I need a query/macro/module/anything that will...

I have been given a task: Two copies of the same database have been filled in in different locations. The database has 55 tables. I have been asked to compare each table to report on differences. It occurred to me that a program that would take two paths to identically structured .mdb files as...