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

    MajP . . . I'm not sure how I did it but it is working well. I was able to export the results over to Excel and apply my percent calculations. If you wish to see how I use this data you can view www.propertieswithstyle.com - click on City Info Pics & Value Charts and scroll down to the Median...
  3. sharkchaser

    Access 2010 Median Group qry

    Thanks very much MajP I can assume that the smaller first code is for a SELECT query. The second larger code is a Function(). Where do I place that section of code? More importantly, how do I call it.? Would love to get this to work. SharkChaser
  4. 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...
  5. sharkchaser

    Horizontal bar or line based on field value

    Okay I solved it. (?) In the txtBar text box control source I placed =Report!count This gives me the exact total. Now - how do I get the bar in the txtBar text box to reflect the count percentage up to 100%? Thanks . . . Rick
  6. sharkchaser

    =[count] & Report!count

    Okay I solved it. (?) In the txtBar text box I placed =Report!count And I discovered that the exclamation point means the the user created the field. Thanks Rick
  7. 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 . . ...
  8. sharkchaser

    Horizontal bar or line based on field value

    OK I'm totally dazed and confused! Here is the ORIGINAL UNION query (courtsey of r937)which produces the correct results for the detail section of the report. SELECT tblCARETSData.City, 'LISTINGENTRYDATE' AS count_type ,1 AS sort_order ,Count(*) AS [count] FROM tblCARETSData WHERE...
  9. sharkchaser

    Horizontal bar or line based on field value

    This is what I've have . . . . =String(([Count])*100,"g") 1> It displays the "g" across the page all the way to the right edge for all three counts per grouping. There are three count_types per group, count_type LISTINGENTRYDATE count PENDINGDATE count...
  10. sharkchaser

    Horizontal bar or line based on field value

    How about if I put something like this in the control. . . IF ([count_type])="listingentrydate" then String(count)= ????? I don't understand how to complete this but could it be the answer? Thanks. Rick
  11. sharkchaser

    Horizontal bar or line based on field value

    I tried both windings & webdings. When I select the solid box and copy it into its field placement it just copies a "G" or "g" into the string. No bar shows even though it does in the selection list of webdings & wingdings. Why does this need to be so difficult? Thanks Rick
  12. sharkchaser

    Horizontal bar or line based on field value

    PWise That produces a different result. The three bars "|" goo all the way to the right, word wrap again all the way to the right and word rap again foe about an inch then ends. Most of these count number are well below 100 but about three or four (City of Los Angeles are over that). Somehow...
  13. sharkchaser

    Horizontal bar or line based on field value

    Gammachaser - I must apologize as I changed those "newlistingcount," etc. names myself. Rudy had them ALL as "count" and it works that way. This is really frustrating. Thanks . . . Rick ps. I can't seem to upload a 13k .pdf file of the report page either.
  14. sharkchaser

    Horizontal bar or line based on field value

    I didn't think of that either - reserved word. Here is the actual query which is an r937 design. SELECT tblCARETSData.City, 'LISTINGENTRYDATE' AS count_type ,1 AS sort_order ,Count(*) AS [NewListingCount] FROM tblCARETSData WHERE (((tblCARETSData.ListingENTRYDate) Between #4/1/2011# And...
  15. sharkchaser

    Horizontal bar or line based on field value

    Thanks Gammachaser The numbers represented above are in a count field of a query placed in the report detail record, grouped by city names, ie. WILMINGTON example. I have this =String([Count],"|") but it shows all the same number of "|" marks for ALL three of the counts even though they are...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Part and Inventory Search

Back
Top