Newbie ACCESS Question

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

Hi. I'm using ACCESS XP and I have a problem that I can
not solve on my own. I have a very large database with
several columns, but the two that I'm concerned with are
as follows:

Col. A (which contains single Greek words - row by row),
and
Col. B (which contains my English translations of these
single Greek words).

I need a query to check on the fly, so to speak, to see
how these individual Greek words have already been
translated in previous records (for the sake of
consistency). I am working in FORM view, so is there some
way I can stay in FORM view, run a macro or the like, have
a window or the like pop up that will show me how this
individual word I am working on at the moment has already
been translated in previous records? I would like to stay
in FORM view so I can read the Greek fonts along with
English fonts, but if worse comes to worse I could switch
over to datasheet view, run a query or macro, and then
switch back. As you can see, I'm a newbie in all this.

I would deeply appreciate your help in this matter.
 
I forgot one thing. The query should disregard English
translation duplications of the various Greek words. So
lets say Greek word XXX appears dozens of times in the
database, and has been translated YYY ten times and ZZZ
four times, and BBB 18 times, the query will only show
YYY, ZZZ, and BBB only once for each (to avoid having to
scroll down a long list). Also, would it be possible to
include a count after each English translation, say, using
the example above, YYY (10), ZZZ (4), and BBB (18)? Just
a thought.
 
Use a totals query as your source

SELECT ColA, ColB, Count(ColB) as NumTimes
FROM YourTable
GROUP BY ColA, ColB
 
I forgot one thing. The query should disregard English
translation duplications of the various Greek words. So
lets say Greek word XXX appears dozens of times in the
database, and has been translated YYY ten times and ZZZ
four times, and BBB 18 times, the query will only show
YYY, ZZZ, and BBB only once for each (to avoid having to
scroll down a long list). Also, would it be possible to
include a count after each English translation, say, using
the example above, YYY (10), ZZZ (4), and BBB (18)? Just
a thought.
Click to expand...

I'd create a Totals query:

SELECT Greek, English, Count(*) FROM tablename
GROUP BY Greek, English;

and display it on a Subform, using the Greek word as the master/child
link.
 
Back
Top