Allow Duplicate Entries in Access

[AccessUser123]

I am trying to get my Access database to INCLUDE duplicate records. I have a simple database with one table that does not have a primary key and I am using one query to generate a report. The data has a lot of duplicate records that need to be included in my report. Is there a way to include duplicate records so that they will show on my report. All table fields that are indexed are set to "Yes, Duplicates OK" and all fields in the report have "no" in the Hide Duplicates field on the property sheet.

[TheSmileyCoder]

Unless your using some sort of grouping in your report or query or possible some criteria not including null fields, they should allready show. What is the SQL syntax of your query?

[AccessUser123]

Sql

SELECT   [Labor List].Clock,
         [Labor List].Name,
         [Labor List].Department,
         [Labor List].[GL Account #],
         [Labor List].[Period Hours],
         [Labor List].[Period Gross],
         [Labor List].[PAY PERIOD],
         [Labor List].PSID,
         [Labor List].[Pay Rate]

FROM     [Labor List]

GROUP BY [Labor List].Clock,
         [Labor List].Name,
         [Labor List].Department,
         [Labor List].[GL Account #],
         [Labor List].[Period Hours],
         [Labor List].[Period Gross],
         [Labor List].[PAY PERIOD],
         [Labor List].PSID,
         [Labor List].[Pay Rate]

HAVING   ((([Labor List].Department) Between [Beginning Dept] And [Ending Dept])
   AND   (([Labor List].[PAY PERIOD]) Between [Beginning Pay Period] And [Ending Pay Period])
   AND   (([Labor List].PSID) Between [Beginning PSID] And [Ending PSID]))
    OR   ((([Labor List].Department) Between [Beginning Dept] And [Ending Dept])
   AND   (([Labor List].[PAY PERIOD]) Between [Beginning Pay Period] And [Ending Pay Period])
   AND   (([Labor List].PSID) Between [Beginning PSID] And [Ending PSID]))

ORDER BY [Labor List].Department,
         [Labor List].[GL Account #];

[NeoPa]

If that's what you want, why are you using a GROUP BY query?

[NeoPa]

As a very basic first suggestion I would say try :

SELECT   Clock,
         Name,
         Department,
         [GL Account #],
         [Period Hours],
         [Period Gross],
         [PAY PERIOD],
         PSID,
         [Pay Rate]

FROM     [Labor List]

WHERE    (((Department) Between [Beginning Dept] And [Ending Dept])
  AND    (([PAY PERIOD]) Between [Beginning Pay Period] And [Ending Pay Period])
  AND    ((PSID) Between [Beginning PSID] And [Ending PSID]))
   OR    (((Department) Between [Beginning Dept] And [Ending Dept])
  AND    (([PAY PERIOD]) Between [Beginning Pay Period] And [Ending Pay Period])
  AND    ((PSID) Between [Beginning PSID] And [Ending PSID]))

ORDER BY Department,
         [GL Account #]