I have a strange one I can't seem to solve. I have a query that I use to generate a report which returns each entry of daily sales data. I can either call for this data by the month or all of the months. My trouble is that the last month, March in this case will return only the last entry date. I can run Jan or Feb and the query (report) will return every day's data. I need the data from every date entered for a report for the head of this department.
My code is below. Please show me the error of my ways.
SELECT tblDailies.Date, tblDailies.GreetingCards, tblDailies.Giftware, tblDailies.CandyPhoneCardsCameras, tblDailies.MagazinesBooks, tblDailies.Balloons, tblDailies.Jewelry, tblDailies.Flowers, tblDailies.GiftCardSales, tblDailies.Stamps, tblDailies.Month, tblDailies.Year, tblDailies.Tax, [GreetingCards]+[Giftware]+[CandyPhoneCardsCameras]+[MagazinesBooks]+[Balloons]+[Jewelry]+[Flowers]+[GiftCardSales]+[Tax]+[Stamps]+[NonTaxSales] AS TotalSales, [GreetingCards]+[Giftware]+[CandyPhoneCardsCameras]+[MagazinesBooks]+[Balloons]+[Jewelry]+[Flowers]+[GiftCardSales] AS TotalTaxableSales, tblDailies.Over, tblDailies.Short, [Over]+[Short] AS OverShort
FROM tblDailies
WHERE (((tblDailies.Month) Like [Forms]![SearchDailyByMonth].[qMonth] & "*"))
ORDER BY tblDailies.Date;