Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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