Recent content by Daffyduck

Well, I've given up. I'm returning the advance and suggesting my friend go elsewhere. I've spent more time on this than it deserves, given that I have papers in my own field that are due in soon. The time-money crunch for independent scholars is like this, and I've learned my lesson, I think...

I didn't get a chance to work on it until just a bit ago...the tables aren't the problem, I don't think...those were the given items to be worked from, and I can't change those, they were set up by the person who's wanting this done. Unless it's something about how you linked them, but since...

Thanks and blessings! DD

Uh-oh, I'm in Access 2000, and don't have access (oooh, sorry) to anything later. A search for conversion options online shows that they only want you to convert in favor of the upgrade (of course)...I'll poke around here to see if there's a way to do this, unless some kind soul wants to tell...

Thanks very much! I've opened it and will look it over. Much appreciated.

This is the group of tables with my comments on each one, zipped and attached. Having mocked them, one of the icons does indeed make sense here: :banghead::banghead::banghead::banghead: One for each table I'm trying to do... :--} DD

Thanks, appreciated.

So, is this dead in the water? I'm noticing lots of lookers but few comments. I really do need the help...I don't see a PM system here, if it's more complex and not all that useful to others, I'm glad to take it offline as well.

Guess it did. So, there are four tables (queries, really) I'm trying to set up. 1) One is "hours per job vs. fee" so: Project Fee Hours: (7 stages as a X-tab) then Fee/hour with an Average line to be figured at the bottom. That's the one that's been the balkiest, since adding any other...

It seems quite happy to give me many silly icons to choose from, but none of them seems to be about managing a file or attaching it. Oh, wait, maybe one is a paperclip...OK, finally...I think it worked. I attached the Excel file as well, since it tells the story better than all my cheeps...

So, QryHpJvF3 gives me the project name and the hourly rate for all those projects that were quoted on an hourly basis. Good enough. But when I try to pull the total hours for those projects from the Hours_crosstab query, it doesn't work....that's when I get the first name repeated all down...

Um....I don't see the "manage attachments" button that I'm supposed to see to be able to upload a file...per the FAQ instructions, anyway...if I survive the learning curve on the forum software, Access will be easy....!

Digging further, I"m also noticing that the column for "Projects," which is usually a name (so, text, I would think) is entered as a number in the file type. Is that an error or is there some reason for doing it that way that I just don't know enough to recognize? (and so, should I change it or...

Hmmm, OK, it's got a bunch of false starts in it...I'll see if I can clean it up and zip it to send. I'm also getting a series of things where I get the same answer all the way down the column, I get the project names and fees/hr OK from one query but when I try to add in the total hours, so I...

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