Search results

  1. S

    Solved Union Query

    If I removed ORDER BY Rnd([ID]); from the union and use the it I. The property sheet I. The Order by section it works as intended.
  2. S

    Solved Union Query

    I spoke too soon I still need help with this. If I run this query I end up with only 10 questions total not 10 questions from each category. SELECT TOP 10 Questions.ID, Questions.CAT, Questions.Job, Questions.Department, Questions.Question, Questions.Answer1, Questions.Correct1...
  3. S

    Solved Union Query

    Well that was my fault I changed it to what you actually sugested and it works great. Thanks for the help Solution. SELECT TOP 10 Questions.ID, Questions.CAT, Questions.Job, Questions.Department, Questions.Question, Questions.Answer1, Questions.Correct1, Questions.Answer2, Questions.Correct2...
  4. S

    Solved Union Query

    I'm not sure how to make this work. If I just add "Month Check" I get syntax error (comma) in query expression
  5. S

    Solved Union Query

    I have a table being used as a question bank. When I started using it I was only generating test on one subject at a time so I used a query that looks like this SELECT TOP 10 Questions.ID, Questions.CAT, Questions.Job, Questions.Department, Questions.Question, Questions.Answer1...
  6. S

    Conditional formatting enable/disable toggle

    What I ended up doing was just to make a button called "Delete Answers" and add Private SUB Command15_Click() Answer1.FormatConditions.Delete Answer2.FormatConditions.Delete Answer3.FormatConditions.Delete Answer4.FormatConditions.Delete End Sub This is good enough for the time being, I didnt...
  7. S

    Conditional formatting enable/disable toggle

    Yes, but the query Im using to select the questions from question database is random so. New copy with out formatting would produce a new random quiz.
  8. S

    Conditional formatting enable/disable toggle

    I have a report that is bing used as a quiz it has 4 conditional formatting rules that highlight a correct answers. I am looking for a way to disable to rules with a button so the quiz can be printed out without the answers highlighted. Thanks.
  9. S

    Sum IIf items being true

    It is a String and this worked out wonderfully. Thank you for the help
  10. S

    Sum IIf items being true

    I'm looking to Sum IIF with multiple items being true. I can't seem to figure it out Sum(IIf(([TD]![COMPLETE]="YES") And ([TD]![NOAC]>1),1,0))
Top Bottom