Recent content by SimplyDemented

  1. S

    Query Expression to autofill given other criteria

    Got it working. I appreciate the help from everyone. I ended up kinda mixing and matching different ideas from the thread. I didn't bother saving the individual month and year in the DB that held the scores, but did hold it seperate in the DB with the goals. The report then pulls in all the...
  2. S

    Query Expression to autofill given other criteria

    ... there is a DSum function... HAHAHAHA~! This fixed one of the big problems I had. I was unaware of this function and can now call a dsum from the report to tally up the goals based on the Forms input! *sigh* I knew it was gonna have some super simple solution. I still have some tweaking to...
  3. S

    Query Expression to autofill given other criteria

    Kodiak, Unfortunately I won't be out of work until 10PM EST, I work 11 hours days 4 days a week. Honestly, I have a feeling if I see an access DB once I get out of here, I may break whatever monitor I may be looking at... I will check out the one you sent tomorrow while i'm off. Curiousity I...
  4. S

    Query Expression to autofill given other criteria

    Thanks Niroth, anything is worth a shot. I may actually have this right on the edge of working now. I have been playing with it for awhile and I have two queries that work. One returns the right goals, the other returns all the information I need from the people. What would be great is if my...
  5. S

    Query Expression to autofill given other criteria

    Kodiak, Thanks a lot for the attachment! That's going a little above and beyond there. Unfortunately my work doesn't allow downloading zip's and i'm sure a db may throw a few red flags. I will check it out when I get home later tonight. Thanks again!
  6. S

    Query Expression to autofill given other criteria

    Heh heh, any help is appreciated. :) Here is what I need it to do. I have my table that contains grades that are given on tons of dates. Each Grader needs to have a certain amount done each month to hit their monthly goal. The problem I see is down the road when I write a report that covers...
  7. S

    Query Expression to autofill given other criteria

    I have a grades_table with data regarding a grade a person gets. It contains like Name, Date, Grade, Grader_Name, Month, Year... I have another table (grader_table) that contains the Grader_Name, and how many Grades that grader needs done in a given month (i'm using two numbers to indicate...
  8. S

    Allowing Duplicate Data in a Query

    Yeah, scratch this post. Just made an autonumber for the table to distinguish the records. I'm REALLY rusty on this stuff. :/
  9. S

    Allowing Duplicate Data in a Query

    I have a database that allows multiple entrys of the same information. I also have a report based on a query that pulls out said data. I just need my query to pull out every record regardless if it is indentical to a previous one. I found under queries > design > properties there are two...
  10. S

    Trying to count specific values

    dude, I can't thank you enough. I can't believe it was that simple. One of those situations where I was trying to make it a lot harder than it should have been. :P Thanks again!
  11. S

    Trying to count specific values

    I am very new to access and I am trying to get a simple count to work. I have a table with about 6 fields, one being Comp_Inc. That field is always either "Complete" or "Incomplete". I then have a query that uses 3 boxes from a form, "Begin_Date", "End_Date", and "Name". The report is based on...
  12. S

    DCount issue

    Wayne, You are like my new hero. Worked like a charm. Thank you. I know it was such a simple little fix, but I just don't have the access experience to have figured it out. I only have one other issue if you don't mind my whining. I have a button on my form that I tied to report preview...
  13. S

    DCount issue

    I am making a report that just displays some basic information. One of the things I want it to display is all the peoples names and to the right, how many times they show up in the DB in a given time range. So right now I could enter "*" for name, then "6-1-07" "6-7-07" and it would show me all...
  14. S

    DCount issue

    Wayne, Appreciate the help, but I can't seem to get it to work that way either. I looked up DSum and it seems to be for running totals where the total is calculated by adding up whats in the fields rather than how many times the fields show up. Correct me if i'm wrong, but DSum would be good...
  15. S

    DCount issue

    I am attempting to write some reports and am pretty much teaching myself access here at work. I am currently stuck on a counting issue. I have a table where among other things it has a name and a number. Lets say for example: Joe 2 Bob 3 Betty 4 Bob 5 John 1 As you can see, there are 2...
Back
Top Bottom