Recent content by Gill1978

Well I've managed to coble together a query (using quite a few temp tables) to get the right data ... just need to figure out how to flip the display of the data ?!!? Added it to the Access forum as you suggested ... as yet nothing ??! Thanks for the help though HarleyQuinn

Hi, I have a sql query (stored procedure) that returns a set of results as follows: Date [Count Post Midday] [pre midday] Heldover ------------------------------------------------------- 1/07/2007 0 2 1 2/07/2007 0 0...

The reason why i need to flip this query round also is that I need to add 3 other lines to it ... 1. messages received before midday 2. messages received after midday etc Otherwise I'll have to add these as further columns to my query above ... and I dont know how to do this .... any ideas??

Don't know how to do that in Access ... do you know how to do this?

Not sure how that helps ... I'm trying to flip round the result set of the above query ...????

Hi, I have a query (below) that displays all the dates of a given month and a count of messages inserted into a table on each day of that month ie. Date Count -------------------- 1/07/2007 0 2/07/2007 0 3/07/2007 5 4/07/2007 10 5/07/2007 0 However is...

I think maybe I didn't explain myself properly.. Because of the data ... for the a particular month you may records for 3 days of the month so if I used the query above I'd get 3 records in the select statemnt. However I'd like the sql statement to bring back 30 records (one record for every...

Hi All, I have a query that brings back a count of a field in a table grouped by Process_Date. This brings back the right count but if for some reason nothings processed on a particular day of that month it doesn't bring back a data row for that day. What I would like is for the query to bring...

No particular! Though what I have managed to do is create a query that is created once a button is selected. I've added this to the rowsource. However, the datasheet that's attached when you create a graph has a completely different set of data than whats in the query (seems to be some default...

Hi, What I'm trying to do is create charts in an Access Report. My thoughts on this was to create an embedded excel chart in an Access report ... the excel chart would use a stored procedure that is located in the sql server back end. What I'm stuck on is how to actually link the stored...

Hi, What I'm trying to do is create charts in an Access Report. My thoughts on this was to create embedded excel charts in an Access report ... the excel chart would use a stored procedure that is located in the sql server back end. What I'm stuck on is how to actually link the stored procedure...

Hi, I have a sql server stored procedure. What I need to do is use this stored procedure to create an excel chart that will be embedded into an Access report. I'm not having any luck in finding how to do this bit ... though I've got some info on how to manipulate the chart once its embedded...

Hi All, I have a stored procedure that I need to run in excel to create a chart, which will be saved as an object in sql server ... does anyone know how I go about this? Really have no idea ... please help! Thanks Julie

Hi All, I need to display an excel chart (that is saved in a sql server table) in an Access Report? Can anyone tell me how this is done ... I have no idea??? Any help would be greatly appreciated? Thanks Juiie

This is the bit I'm struggling with. I stopped panicking ... and I see I can create stored procedures to capture the data that the users will need. So the reports will be developed by another team (not actual users but I call anyone not on my team a user - sorry about that)!! I was just...