Search results for query: *

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...

Hi all, I've just been handed an Actuate project, bearing in mind my back ground is SQL Server/ transactional database's. Having a look at the Actuate overview, this is based on OLAP and cubes. The point of the project is to load data from a sql server to an actuate server (is that right) ...

Hi BabyJeffy, I tried what you suggested, but this removed all the background colour/ imaging? Thanks Julie

Hi there!! Here's the contents of the .css file: body { font-family: Arial, Helvetica, sans-serif; font-size: 0.8em; margin: 18px; background-color: #CCCCCC; background-image: url(bg.gif); } #wrap { padding: 4px; background-color: #97D9EC; border: 1px solid #229ABD; } #wrap #header {...

Hi all, I've got a div tag within in a header, and I'd like to split it into 2 sections next to one another. However whatever I try the sections go one below the other. Can anyone help ... been a long weekend I think ... <div id='wrap'> <div id='header'> <p align="left"><img...

Put in some simple re-connection code ... and the connection is still being dropped ... I'm thinking it must be sql server for some reason !!?? Does it have some memory of failures that needs to be cleared ... I'm totally lost!!