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!

Register Log in
  • Congratulations John Tel 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. sharkchaser

    Access 2003 Transfer

    Will this work just by changing the 2003 DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel2010, "qryCBCapoBeachProg", "C:\flw\Access\", True Thanks . . . SharkChaser
  2. sharkchaser

    Access 2010 Median Group qry

    tblHistorical2012 Fields in table City text ClosingDate Date: Format([ClosingDate],'yyyy') ClosePrice Currrency BuildingSize LongInteger Records in Table (478,795) I need to calculate the MEDIAN of [ClosePrice] and [buildingSize] for each city for years 1998 through 2012 GroupBy City and...
  3. sharkchaser

    =[count] & Report!count

    =[count] & Report!count I don't understand the "& Report!Count" It's providing the correct answer but with the number 18 in front of the correct results. ie. correct answer result from above statement 17 1817 7 187 4 184 Any ideas . . ...
  4. sharkchaser

    Horizontal bar or line based on field value

    GROUP STATUS COUNT WILMINGTON ENTRYDATE 23 WILMINGTON POSITIONNO 60 WILMINGTON LOCKGDATE 123 What I wish to do is have a solid or gradient horizontal bar to the right of each group entry representing the COUNT number. It really needn't be a bar but any chatachter, ie., > How do I...
  5. sharkchaser

    Query Failure

    Doesn't work. Returns empty rows. SELECT Max([HIGH Dollar Market].ListPrice) AS MaxOfListPrice, Avg([HIGH Dollar Market].ListPrice) AS AvgOfListPrice, Min([HIGH Dollar Market].ListPrice) AS MinOfListPrice, Count([HIGH Dollar Market].City) AS CountOfCity, Avg([HIGH Dollar...
  6. sharkchaser

    Enter Parameter Value

    If I pull out the WHERE clause this works well. What I need is to filter by the WHERE clause and ORDER BY Volume DESC. SELECT listofficename, sum(closeprice) AS VOLUME FROM tblCARETSdata WHERE Volume > '10000' GROUP BY listofficename ; I'm trying to figure this out from "Simply SQL" but...
  7. sharkchaser

    NEW To Site Design ASP.net questions.

    I am brand new with web design. I no little about HTML and CSS. Enough to get in trouble I suppose. On XP Pro I use MS Access (2003) data tables, reports and queries for PRINT purposes. I also generate charts in FL Graphics from these queries which I then convert to .jpg’s and upload to my...
  8. sharkchaser

    UNION Query Wants Parameter Value Entered?

    This is what I have. . . It keeps asking me to enter an 'Active' parameter value? SELECT COUNT(*) AS [Count <=199999] FROM tblCARETSData WHERE ListingStatus = ‘Active’ AND ListPrice <= 199999 AND County = 'orange' UNION ALL SELECT COUNT(*) AS [Count >=200000 <=299999] FROM...
  9. sharkchaser

    Private Sub Command100_Click() FAILS

    When I click the button on the form NOTHING HAPPENS at all! This same code works in many other form buttons I have. I'm totally lost as to why. Thanks . . . Rick Private Sub Command100_Click() 'LA QUINTA On Error Resume Next Kill "D:\flw\Access\YTD\qryLaQuintaProg.xls" On Error GoTo 0...
  10. sharkchaser

    Center image on HTML page and Background image in CSS

    All nighter again . . . How can I center these images on an HTML page? SIMPLE method please. <img src="/MacroValueChart.jpg" vspace="10" width="950" height="700" alt="macrovaluechart" longdesc="/MacroValueChart.jpg" /> <img src="/MicroValueChart.jpg" vspace="10" width="950" height="700"...
  11. sharkchaser

    Header Image in CSS DW CS4

    Is it correct to place header code for a header graphic in the css file or should it go into the html file. I can easily make it work in the html file but I can't insert an image into a css file. If in the css file - HOW! PWSHeader.jpg is a 950 X 120px graphic. Thanks. Rick
  12. sharkchaser

    Quick Flash Page Template Design.

    I'm looking to design a simple flash template layout that I can used over and over again. I'm not sure how to start with a design concept. Thank. Rick
  13. sharkchaser

    css background not working ?

    Here is my css page All is working except the background-image part. I've doubled checked the path and image name, etc. and it's all correct. Is it in the head, style, body portion? I VERY new at this using DW CS4. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"...
  14. sharkchaser

    Image not showing in table using CS4

    I'm so new at this I have little syntax knowledge using HTML & CSS. <body> <table border="0" align="center" cellspacing="0" cellpadding="0" style="background-image:url(/Images/PWSHeader.jpg); width950"> <tr> <td>&nbsp;</td> </tr> </table> </body> It looks like it should work but no...
  15. sharkchaser

    Aggregate SQL Count Problem

    I'm quite ingnorant regarding aggregate SQL functions, especially Count functions. This query returns values that I can then count but what I would like is the query to actually COUNT the number of ListingDate and PendingDates that are returned for each. SELECT June2010Newsletter.City...
  16. sharkchaser

    =Avg([ListPrice])-Avg([ClosePrice])/Avg([ClosePrice])

    In a group footer section of a report I have this: =Avg([ListPrice])-Avg([ClosePrice])/Avg([ClosePrice]) I use something very similar in Excel and it works perfectly. Excel Sample: =(E3-F3)/(F3) where E & F fields are currency. The format is set as a percent. Two problems. First the...

Part and Inventory Search

Back
Top