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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.