Search results

I will try and give you a run down: I have an employee database, and a button to print "Monthly lateness reports" in this case. We have 4 letters of warning from verbal to termination. I have several queries filtering data: How many times everyone has been late this month (anyone over 4) If...

Yes, i have 4 reports names "attendance1" "attendance2" etc. The "max" field is a number in the query 1-4 I am looping through the query results to grab the value for each person and print out the coresponding report by just concatenating the name. If there is a better way then i am all ears, i...

Sparks, thanks for your reply. What field name should i be referencing exactly? As i mentioned this query does not have a date field, but on of the queries it uses does. if i close the main form and run the report it asks for parameter value: Forms!frmMain!caldate.Value which is why i assume...

Hi, I am having an issue on 2007 where I am trying to loop through query results and print a report based on a field in the query. heres my code: Private Sub Command81_Click() Dim db As DAO.Database, rs As DAO.Recordset Dim strReport As String Set db = CurrentDb() Set rs =...