30 Days Average
SELECT Avg(tblMetalXignite.Pt_Bid) AS AvgOfPlatinumSpot,
Year([PostDate_System]) AS YearDate, Month([PostDate_System]) AS MonthDate, Day([PostDate_System]) AS DayDate,
CONVERT(VARCHAR, Year(PostDate_System)) + '-' + CONVERT(VARCHAR, Month(PostDate_System)) + '-' + CONVERT(VARCHAR, Day(PostDate_System)) AS Label
FROM tblMetalXignite
WHERE (((tblMetalXignite.PostDate_System) > #DateAdd("m", "-3", Now())#))
GROUP BY Year([PostDate_System]), Month([PostDate_System]), Day([PostDate_System]), CONVERT(VARCHAR, Year(PostDate_System)) + '-' + CONVERT(VARCHAR, Month(PostDate_System)) + '-' + CONVERT(VARCHAR, Day(PostDate_System))
ORDER BY Year([PostDate_System]), Month([PostDate_System]), Day([PostDate_System]);
SELECT Avg(tblMetalXignite.Pd_Bid) AS AvgOfPalladiumSpot,
Year([PostDate_System]) AS YearDate, Month([PostDate_System]) AS MonthDate, Day([PostDate_System]) AS DayDate,
CONVERT(VARCHAR, Year(PostDate_System)) + '-' + CONVERT(VARCHAR, Month(PostDate_System)) + '-' + CONVERT(VARCHAR, Day(PostDate_System)) AS Label
FROM tblMetalXignite
WHERE (((tblMetalXignite.PostDate_System) > #DateAdd("m", "-3", Now())#))
GROUP BY Year([PostDate_System]), Month([PostDate_System]), Day([PostDate_System]), CONVERT(VARCHAR, Year(PostDate_System)) + '-' + CONVERT(VARCHAR, Month(PostDate_System)) + '-' + CONVERT(VARCHAR, Day(PostDate_System))
ORDER BY Year([PostDate_System]), Month([PostDate_System]), Day([PostDate_System])
SELECT Avg(tblMetalXignite.Rh_Bid) AS AvgOfRhodiumSpot,
Year([PostDate_System]) AS YearDate, Month([PostDate_System]) AS MonthDate, Day([PostDate_System]) AS DayDate,
CONVERT(VARCHAR, Year(PostDate_System)) + '-' + CONVERT(VARCHAR, Month(PostDate_System)) + '-' + CONVERT(VARCHAR, Day(PostDate_System)) AS Label
FROM tblMetalXignite
WHERE (((tblMetalXignite.PostDate_System) > #DateAdd("m", "-3", Now())#))
GROUP BY Year([PostDate_System]), Month([PostDate_System]), Day([PostDate_System]), CONVERT(VARCHAR, Year(PostDate_System)) + '-' + CONVERT(VARCHAR, Month(PostDate_System)) + '-' + CONVERT(VARCHAR, Day(PostDate_System))
ORDER BY Year([PostDate_System]), Month([PostDate_System]), Day([PostDate_System]);