Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Gill1978

    Change results of 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
  2. Gill1978

    Display of query result set

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

    Change results of query

    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??
  4. Gill1978

    Change results of query

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

    Change results of query

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

    Change results of 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...
  7. Gill1978

    Query to bring back every day of month

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

    Query to bring back every day of month

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

    Excel in Access Report

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

    Excel in Access Report

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

    Stored Procedure to run in excel

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

    How to embed Excel chart

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

    Stored Procedure to run in excel

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

    Display excel chart in Access Report

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

    Starting Actuate

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

    Starting Actuate

    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) ...
  17. Gill1978

    split div tag into 2 sections

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

    split div tag into 2 sections

    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 {...
  19. Gill1978

    split div tag into 2 sections

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

    Sql server dropping connection with Access view

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

Part and Inventory Search

Back
Top