Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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