Prev: Special Characters in Access 2007
Next: days between tweak
From: gueser on 21 Apr 2010 15:23
I have a report that I generate via a query which promptme me for a value for
one field of one table. I want to generate all the entries from another
table that correspond to that one field in that main table. I get the info,
but many times over. For exampe if there are 6 entries in the second table,
I get all the info 6 times over. Any ideas on how to correct this?

--
John M Medeiros
Senior Testing Manager
From: XPS350 on 21 Apr 2010 15:53
On 21 apr, 21:23, gueser <gue...(a)discussions.microsoft.com> wrote:
> I have a report that I generate via a query which promptme me for a value for
> one field of one table.  I want to generate all the entries from another
> table that correspond to that one field in that main table.  I get the info,
> but many times over.  For exampe if there are 6 entries in the second table,
> I get all the info 6 times over.  Any ideas on how to correct this?
>
> --
> John M Medeiros
> Senior Testing Manager

It seems to me you are not joining the tables. The query should look
like:
SELECT * FROM Table1 INNER JOIN Table2 ON Tabel1.FieldX =
Table2.FieldX;

Groeten,

Peter
http://access.xps350.com
From: Ron2006 on 21 Apr 2010 17:01
It sounds to me as if it is working as expected. Think of it this way.

1) You have an employee master record that has employee name
2) You have a hours table with number of hours per day per employee.

I you create a query that says SHOW the employee name and all the
hours records for an employee. Then if you show the employee name on
the form for each record returned with the query then you will see the
employee name each time/ for each record.

Only 3 solutions I can think of:
1) Use a report to show results and group by employee name (then it
will only show once)
2) Don't show the employee name on the form.
3) Create the form with a subform with the main form showing the
employee name and the subform NOT showing the name.

Ron
 | 
Pages: 1
Prev: Special Characters in Access 2007
Next: days between tweak