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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by LeenOoo

  1. LeenOoo

    2-y axis graph in access

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

    Dynamic Report with sub-groups

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

    Dynamic Report with sub-groups

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

    Dynamic Report with sub-groups

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

    Dynamic Report with sub-groups

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

    Dynamic Report with sub-groups

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

    Dynamic Report with sub-groups

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

    Dynamic Report with sub-groups

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

    Dynamic Report with sub-groups

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

Part and Inventory Search

Back
Top