Search results

I submitted the question under another topic and didn't get a response. I probably confused everyone including myself. If a report has a text box with just the current date to be entered when the report is issued =date() . I am copying the information to a table, using an append query, with...

Well, I am still working on the same stuff. I ended up creating a append query that duplicates the information in the Improvement Notice Report to a table. From the Table I created the employee history report. Thanks for all your help in accomplishing that part. Now, I have a problem with...

Thanks for responding. I am having problems planning the flow or process to reach the end result. The end result is populating a table in another database with information from a report. 1. My task was to create an improvement notice for an employee's excessive absences, which I did from a...

Well I did the Make-Table Query from the same query I created the report, but how do I get the information from the report to the table to the other table? I am not real experienced with Access, so please give me a hint. Thanks

I have a report created from various queries that creates a disciplinary notice for attendance. The report lists the various dates and information that led up to the improvement notice and the Level of the notice. Most of the information in in column format except for the level of notice and...

Thanks for your help!! I finally got it to work.

Query Problem Thanks for your response. If I am understanding your note, in the query in the "Incident" Field (the field that has the numeric number of absences), I can enter the following in the criteria: "Incident" > [5.5] Is that correct?

I have a query that creates a report that list all the employees absences and then totals the absences. The report is grouped by employee number so all the dates and information for that employee is grouped with their total. I created a report from the same query that just listed the employee...

I'm using double and the criteria for the total incidents is >5.5

I have a query that creates a table that add up all attendance points for employees. The total include half points. I have another query that uses the information from the table where I want to pull all employees that have greater than 5.5 points in attendance. The query will not pull any...

I tried the form and it works great! Thank you very much. Linda

Thanks for your reply. When I eliminated the parameter from the Subreport, ALL employees' information was listed in the subreport instead of just the one in the main report. I will try the form. Thanks!!

I have a main report with a parameter of employee number. I also have a subreport with a parameter of employee number. When I try to open the report, the parameter "What employee #" is repeating several times; some times as many as seven times. It also asked again if there is a second page to...