Help with Repeating Records

[AccessIM]

I am trying to create a form that Inventory Control can go in to their menu,
select a bill date range and order type and have all items billed under that
specific criteria come up on a form so they can physically check the
inventory in the slot and enter a slot count.

My problem begins with creating the query to feed the form. When I create
the query, it repeats the item information for each bill date in the table.
I only want the one record so I created a second query and eliminated the
bill date field and used the grouping function. This gave me just one record
for each slot but the query is not updateable and they can't enter their
physical slot counts in the form.

Here is the SQL for the first query using the bill date:

SELECT tblBookedOrdersWithPOsAssigned.OrderType, DateValue([BillDate]) AS
BilledDate, tblBookedOrdersWithPOsAssigned.ItemCode, tblDiv48ItemFiles.Brand,
tblDiv48ItemFiles.Description, tblDiv48ItemFiles.Slot,
tblDiv48ItemFiles.Inventory
FROM tblDiv48ItemFiles INNER JOIN tblBookedOrdersWithPOsAssigned ON
tblDiv48ItemFiles.Item = tblBookedOrdersWithPOsAssigned.ItemCode
WHERE
(((tblBookedOrdersWithPOsAssigned.OrderType)=[forms]![frmMenuInventory]![ChooseOrderType])
AND ((DateValue([BillDate])) Between
[forms]![frmMenuInventory]![BeginningDate] And
[forms]![frmMenuInventory]![EndingDate]));

Here is the SQL for the second query which feeds from the first query but
without bill date:

SELECT qryInventorySlotVerificationWithOrderTypeAndDateRange.OrderType,
qryInventorySlotVerificationWithOrderTypeAndDateRange.ItemCode,
qryInventorySlotVerificationWithOrderTypeAndDateRange.Brand,
qryInventorySlotVerificationWithOrderTypeAndDateRange.Description,
qryInventorySlotVerificationWithOrderTypeAndDateRange.Slot,
qryInventorySlotVerificationWithOrderTypeAndDateRange.Inventory
FROM qryInventorySlotVerificationWithOrderTypeAndDateRange
GROUP BY qryInventorySlotVerificationWithOrderTypeAndDateRange.OrderType,
qryInventorySlotVerificationWithOrderTypeAndDateRange.ItemCode,
qryInventorySlotVerificationWithOrderTypeAndDateRange.Brand,
qryInventorySlotVerificationWithOrderTypeAndDateRange.Description,
qryInventorySlotVerificationWithOrderTypeAndDateRange.Slot,
qryInventorySlotVerificationWithOrderTypeAndDateRange.Inventory;

I have read in several threads in the discussion groups that grouped queries
are not updateable but I was hoping someone could help me out with a work
around or possible a totally different way of getting the information I need.

ALL suggestions will be appreciated as this is driving me crazy and I am
nearing a deadline. Thank you so much in advance.