« previous next »
Pages: [1]   Go Down

Author Topic: Access wizard needed...  (Read 703 times)

0 Members and 1 Guest are viewing this topic.

Offline Cvillechopper

  • Is just pretending to be an
  • Expert
  • ****
  • Posts: 1,184
  • If not for my failures I'd never know my limits
Access wizard needed...
« on: February 28, 2008, 01:31:45 PM »
Anyone know Access REALLY well???

I've got a query in which I've created subquerys to various tables and would like to produce a multi-level summary report but can't figure out how to make it work.  Basically I've got 4 fields in the query, 3 of which are subqueries (lookup functions) including "Report Group", "Type", and "Month".  I need to report on the sum of the 4th field "Stat Count", by Month, by Type, by Group. 

Anyone.  Anyone.

Beuller?  Beuller?

Logged
It is the mark of an educated mind to be able to entertain a thought without accepting it.  Aristotle

Offline 333

  • Time for change
  • Really Old Timer ...
  • *******
  • Posts: 7,558
  • Mail List Member #162 - Call me Stan
Re: Access wizard needed...
« Reply #1 on: February 28, 2008, 01:37:54 PM »
How come you can't ask an Excel question?  That I would know.
Logged
Go metric, every inch of the way!

CB350F0  "Scrouching Tiger"
CT70K0    "Sneezing Poodle"

www.alexandriaseaport.org

Offline gerhed

  • Master
  • *****
  • Posts: 1,801
Re: Access wizard needed...
« Reply #2 on: February 28, 2008, 02:06:04 PM »
Sounds like Excel could handle this with ease ?
I used to be able to make a pie chart out of anything !
« Last Edit: February 28, 2008, 02:10:04 PM by gerhed »
Logged
Rides: 75 CB750F, 48 Indian Chief, 67 Triumph TR6, 63Honda CA95
          83 XL600R in CB360 Frame
          3-wheel electric tilting cycle

Offline Cvillechopper

  • Is just pretending to be an
  • Expert
  • ****
  • Posts: 1,184
  • If not for my failures I'd never know my limits
Re: Access wizard needed...
« Reply #3 on: February 28, 2008, 03:08:21 PM »
I teach advanced classes in Excel but this is a data set with well over 300K records.  A bit out of Excel's capabilities.  I ran a pivot in Excel on the Access query but after 15 minutes of my cpu running at 100% I decided it wouldn't be practical.  This has been under construction for a few weeks and I'm at a brick wall...  anyone have the easy button??
Logged
It is the mark of an educated mind to be able to entertain a thought without accepting it.  Aristotle

Offline DammitDan

  • Prodigal Son
  • Master
  • *****
  • Posts: 2,470
  • It lives!
Re: Access wizard needed...
« Reply #4 on: February 28, 2008, 03:49:08 PM »
I have some experience with Access, but without seeing what you're needing I'm not sure I can help ya :-\
Logged
CB750K4

Offline Cvillechopper

  • Is just pretending to be an
  • Expert
  • ****
  • Posts: 1,184
  • If not for my failures I'd never know my limits
Re: Access wizard needed...
« Reply #5 on: February 28, 2008, 03:51:58 PM »
I could send you the database with just a couple hundred records of dummy data and an Excel sample of the end report I'm trying to create if you don't mind.  just let me know where to send it.  I'd really appreciate it.
Logged
It is the mark of an educated mind to be able to entertain a thought without accepting it.  Aristotle

Offline kpier883

  • is quite the
  • Hot Shot
  • ***
  • Posts: 677
Re: Access wizard needed...
« Reply #6 on: February 28, 2008, 07:49:00 PM »
Generally when you sum and group by, you must include only the columns in the select that are grouped by.

For example,

select f1, f2, f3, sum(f4) group by f1

will fail because f2 and f3 aren't in the group by clause. 

Send me what you are trying to do and I will take a look, however, I wouldn't call myself an access expert at all....

send it to kpierce@drummondco.com and i will take a look at it some time at work tomorrow.

Kirk
Logged
74 CB750
80 CBX
82 KZ1000 K2 (LTD)
57 1/2 ton chevy

Offline DammitDan

  • Prodigal Son
  • Master
  • *****
  • Posts: 2,470
  • It lives!
Re: Access wizard needed...
« Reply #7 on: February 28, 2008, 08:05:23 PM »
kpier883 seems to have things more in line than I do, but I would still give it a shot if you wanted Cville (though I can't promise anything, while I do have experience with Access it's been several years  ;D)

My email is dhumberd@gmail.com
Logged
CB750K4

Offline Cvillechopper

  • Is just pretending to be an
  • Expert
  • ****
  • Posts: 1,184
  • If not for my failures I'd never know my limits
Re: Access wizard needed...
« Reply #8 on: February 29, 2008, 03:40:35 AM »
You guys rock.  I'll send a file once I get to work.
Logged
It is the mark of an educated mind to be able to entertain a thought without accepting it.  Aristotle
Pages: [1]   Go Up
« previous next »