Query to return records within dates and all names

[Vargasman]

I am trying to build a report based off of a query for weekly attendance. My query as of now uses the Between [Start Date] and [End Date] for it's criteria. The problem I am having is that everyone will not have an entry every week but I will need everyones name returned in the report. How would I go about seting up a query the info within a date range but reutrn all names even if the names are not within said date range?

Thanks,
Vman

 

[DCrake]

Simple Software Solutions

Applying a date is a specific request, however you could use the following

Between [Start Date] And [End Date] Or Is Null

This would filter out all records with a valid date between the boundaries you have set. But also include all records that do not have a date (Null Vaue).

CodeMaster:

 

[Vargasman]

I should of explained what I need a little better. I have 2 tables one with personnel info and another with attendance info. Each office wants to know who show up for each event weekly. The names are pulled form tblPersonnel and the dates and number of events attested come from tblAttendance. Each new record is entered into tblAttendance. My report needs to have all members form each office even though they might not of attended an event that week.
Ex.

Name Attended

bob 2
mary 3
john
mark 3
juile
bill 1

I can pull a report for all records but i wan to keep it specific to a weeks worth of info. By doing it the way it's setup now, I can't get the names to return if they don't have an entry for that week long date range.

 

[DCrake]

Simple Software Solutions

In your query that is the source of the report you need to make the inner join all from Employees. So it will show all employees even if they do not have any attendances.

David

 

[Vargasman]

THANKS! That was exactly what I was looking for.

 

[DCrake]

Simple Software Solutions

Glad to be of help and thanks for the reputaion