Recent content by Snak

Thank you Hi - and thanks I was working along the lines of that thanks to another thread and it seems that that is the way to go. Thanks again

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

Evaluation of experience You're absolutely right. The questions our respondents are asked are to evaluate the usefulness (or not) of medical training activities. This allows us to guage the effectiveness of one trainer over another. Those respondents who did not attend/were not given the...

Hi Guys Thanks for your responses. I'll have a play with your solutions. Just to round things off: The scores 1-5 are an evaluation of experience and you cannot evaluate someting you haven't experienced. The average of 1 + 0 is 1 if you do not count the zero - these are averages of...

:) you're welcome

Hi - appreciate your reply, but... The table contains other fields too - it actually records results from a questionnaire and contains references to other tables. Having a different table for each question would be normalisation gone mad. The table is part of a normalised database. I MUST...

Suggest you use File > Get External Data > and LINK your two databases together. You should then be able to include tables from both databases in a single query.

Could you use the BETWEEN...AND function? For example [DrillDate] BETWEEN [OrderStartDate] AND [OrderEndDate] in the criteria?

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

You're welcome. :) A good plan. Good luck.

Yes. If you want to use your own machine to host the MySQL tables, you need to install MySQL locally. When you set up a DSN, if you've installed the MySQL ODBC code, there will be an option in the list of drivers (including MySQL v 3.51) in the Create New Data Source option (either from within...

Excellent article. Under most circumstances, using MySQL with Access via ODBC, and for relatively simple applications, some of the esoterics of field type differences do not matter. The obvious exception to this is a date/time field. The cute thing is that MySQL stores dates as text: YYYY-MM-DD...

Never a problem Glad I could help.

Hi Shadow Create your table(s) in Access and then export...(File > Export .....Scroll down the 'Files of Type...' combo to ODBC databases, then choose [or set up] a DSN for the MySQL tables). I usually do it the other way round - create the tables in MySQL and then link to them (File > Get...