Recent content by Malfar

Ok this is getting weird. I ran a query to see if it showed only the first days of the week and it did. I then had the chart table displayed at the same time as the chart, and the table itself only had the first day of the week, yet the chart seems to want to show every day of the week, even...

Ok, almost have it. The dates are showing up properly now, had to use the x-axis format in the chart. My SQL now looks like this: SELECT [dates]-weekday([dates]) , Sum([press500]) AS [500 Tonne] , Sum([press600]) AS [600 Tonne] , Sum([press1000]) AS [1000 Tonne] FROM [Tmp] GROUP BY...

Ok I think we are getting somewhere now, however when I try putting in exactly as you've typed out I get this error: syntax error (missing operator) in query expression '[dates] - weekday([dates]) Sunday'. If I take the Sunday out of the Query it will run however, it will show every day in the...

Ok what happens here is it only shows data for the sunday, I need it to show the total for the week, I just need the date to display the first of the week. As currently it displays it as the number of the week i.e The week of jan 1 2007 will show up as 1 '07. The data that is reflected in the...

The problem is, what I want for a chart, is a weekly report, not a daily one, however I need it to show the dates in the format of mm/dd/yyyy and that is where my problem lays, it shows them as ww 'yy currently and I have tried everything I could think of to change the format.

I've included pictures of what the x-axis needs to look like (x-right.jpg) which was achieved with sql code of: SELECT ( (Format([Dates]-(Weekday([Dates])-8),"Short Date"))),Sum([press500]) AS [500 Tonne],Sum([press600]) AS [600 Tonne],Sum([press1000]) AS [1000 Tonne] FROM [Tmp] GROUP BY...

I have a database and have a report which shows a chart, showing hours used(y-axis) per week (x-axis). I used the basic chart wizard to get it set-up, however the dates along the x-axis are formatted as ww and I'm unsure how to convert them to mmm dd, yyyy format. Everything I've tried so far...