Counting Dates

[ckeezer]

Here is my table:
tbl_tc
Name
Date
Tech_Name
Issue
Resolved
Resolved_Date
In
Out

I need a query that will do the following:
Total Number of:
Tickets Open (IE, Date field is populated, but Resolved_Date is not)
Tickets Closed (both Date fields are populated)
Total In
Total Out

Total By Tech_Name:
Same as above but I need it seperated by the techs name.

Problem is that I only need it to pull up the Current Months tickets, I will pull additional months later on.

I am not really sure how to even start this... HELP PLEASE!

 

[RuralGuy]

I don't have a solution just yet but you are using Reserved Words as field names.

List of reserved words in Access 2002 and Access 2003
List of Microsoft Jet 4.0 reserved words
Special characters that you must avoid when you work with Access databases

 

[ckeezer]

I should have been more specific, The field names all have the control identifier at the begining:
txtName
txtDate
cmbTech_Name
memIssue
cmbResolved
txtResolved_Date
cmbIn
cmbOut

sorry about that.

 

[RuralGuy]

Hi ckeezer,

I'm still killing time 'til a query guru drops by with the solution. I hope you haven't named your table fields with a control name prefix. That is usually the way to distinguish between a FieldName and a ControlName that is used to display the field on a form. Just asking.