Search results for query: *

Hi, I'd like to create a 2-Y axis graph as part of a report that I have all set up and running in Access. But, of course, I can't figure out how to make the graph. I would like to show the number of sales and the median sales price as my two Y-axis. The X-axis is the month. And I'm...

thanks, that was perfect. i might one day really know what i'm doing in access.... now my boss has asked me to set up a new report, basically the same as what i've already done, but different! so by changing the query i used the report that i made to do a report for the four major areas, then...

ah ha! that was it! thanks! now, i'm trying to figure how to do a report with subreports, (i've never used these or sub-forms) maybe i don't even need to do this: i want to add a graph at the end of my existing report. so i started by creating my graph -- i created a new query for it to...

i'm not sure if there is a way that i could copy in a picture of what my report looks like?? i'll try my best to re-create it here: Housing Sales -- 1st Quarter 2007 Age [tab][tab][tab][tab][tab]Number [tab]MedianSalesPrice (column headings...) Incline Village (this is the group0) Single...

the report is set up with two levels in the sorting and grouping. group0 is the areaname, and this is sorted asc. this is a text field. group1 is the landuse type, and this is sorted asc. this is a numerical field. next i'd like to sort on age, which is the first column in the body. age is...

now i have a new problem! i ended up writing a macro to run through and create a line in a new table for each region, time period, land use type, and age -- filling in fields for each of these, plus the count of the sales, the averages and medians. from there i have it set up to use your...

i think i must be going about this the wrong way. here is what my query looks like: SELECT "SFR" AS Landuse, "New" AS Age, Count(YTDSALES2007.ID) AS CountOfID, Avg(YTDSALES2007.[Sale Price]) AS [AvgOfSale Price], Median("YTDSALES2007","[Sale Price]",'TaxDist="5200" And [LUC at Sale]=20 and...

Your applet was great, but it won't do as the reports I'm trying to generate will come from multiple queries. I'm getting slightly closer, by using an append query and union-ing my three parts (new, existing and all sales) into one table. But it won't let me make a report out of this new...

hello, i've struggling with trying to build a dynamic report. we have a table that has housing sales data for a county. i've set up a form, in hopes of being able to dynamically create/open a report based on what the user selects in the form. the selection choices are area (three cities, the...