I have a crosstab query called ShiftHours in access with the following fields:
Staff, Shift, Mon, Tue, Wed, Thu, Fri, Sat, Sun
i need to export the fields to excel using a recordset
the problem i have is the the shift field
i need to loop through the records and if the shift = "AM" then...