MS Access Report Criteria (1 Viewer)

T

tarus987

New member

Local time

Today, 06:03

Joined

Oct 2, 2018

Messages

9

• Oct 17, 2018

• #1

I have a couple of issues I'm running into in creating a timesheet. But mainly, I want to know is there a way to create a report that will show employees that inputted time, as well as indicate employees that have not in the same report?



I have a table of Employees, & timesheets
And I have a Timesheet query that does the calculations.



My Report is based on the employees table and timesheet query.

 

The_Doc_Man

Immoderate Moderator

Staff member

Local time

Today, 06:03

Joined

Feb 28, 2001

Messages

27,148

• Oct 17, 2018

• #2

The question is, how do you want them reported? As flags on the DETAIL line that shows you the hours? Or some other method? Define what you want first. Then we might be able to advise.

 

T

tarus987

New member

Local time

Today, 06:03

Joined

Oct 2, 2018

Messages

9

• Oct 17, 2018

• #3

right now when I run the report, it only displays users that have entered a new timesheet for todays date. But I would like it to also show the rest of the employees names even though there is not a new record for todays date. That way when I run the report at the end of the day and export to excel, any users that forgot to submit their time, I can add it to their name on the spreadsheet.

 

GinaWhipp

AWF VIP

Local time

Today, 07:03

Joined

Jun 21, 2011

Messages

5,900

• Oct 17, 2018

• #4

I would use a separate query to export either to the same tab or a separate tab. Just put in a separate line (or code) to export.