So, I said I'd help a friend sort out some materials she's been recording on her work as a theatrical costumer for some serious folks for the past 10 years.
Apparently she took a course a while ago and learned how to set up the basic tables she needed and has been duly entering info into them ever since.
She's basically trying to figure out if her pricing and her hours are working out well, and she asked me to put four tables (really queries) together. A couple need crosstab queries, and I figured those out, but then they need columns added after those results, and sums and multiplications after that, and that's where I'm getting stuck.
I did everything in Excel and after tweaking a few things, it worked, so I have some basis for knowing if I'm on the right track, but I'm foundering on the stupidest things...at least it seems so to me.
And somehow I can't find any friends who know this stuff who could look at it and tell me what's wrong! Anyway:
1) One issue is that I seem not to be getting the relationships set up correctly, and I can't seem to find any instructions for how to think about those more logically. I've read through a couple of books, but nothing explains how to decide what lines to draw to get what results....or has a parallel I could follow that matches what I'm trying to do.
2) The other is that I'm getting the dread "Type mismatch in expression" message and I'm not seeing where it's coming from...I've looked at a couple threads here but so far no solutions have popped up; possibly this is related to No. 1 above, or it could be a different problem, just can't tell.
There may be other problems with what I'm trying to do, ongoing, but I have a feeling if those could be fixed, I could at least see what they'd be.
Any help, suggestions, appreciated.
Apparently she took a course a while ago and learned how to set up the basic tables she needed and has been duly entering info into them ever since.
She's basically trying to figure out if her pricing and her hours are working out well, and she asked me to put four tables (really queries) together. A couple need crosstab queries, and I figured those out, but then they need columns added after those results, and sums and multiplications after that, and that's where I'm getting stuck.
I did everything in Excel and after tweaking a few things, it worked, so I have some basis for knowing if I'm on the right track, but I'm foundering on the stupidest things...at least it seems so to me.
And somehow I can't find any friends who know this stuff who could look at it and tell me what's wrong! Anyway:
1) One issue is that I seem not to be getting the relationships set up correctly, and I can't seem to find any instructions for how to think about those more logically. I've read through a couple of books, but nothing explains how to decide what lines to draw to get what results....or has a parallel I could follow that matches what I'm trying to do.
2) The other is that I'm getting the dread "Type mismatch in expression" message and I'm not seeing where it's coming from...I've looked at a couple threads here but so far no solutions have popped up; possibly this is related to No. 1 above, or it could be a different problem, just can't tell.
There may be other problems with what I'm trying to do, ongoing, but I have a feeling if those could be fixed, I could at least see what they'd be.
Any help, suggestions, appreciated.