Search results for query: *

So...I guess I'm just SOL, huh? It seems like I'm tantalizingly close, but then Access always manages to confound my notions of what "simple" and "complicated" are. :) Thanks, all, for your time. I really do appreciate your help.

The SQL validates now, but this appears to be excluding records of type "list request" regardless of whether Check98 = Yes. I ran the query with Yes and No values for the checkbox, and it returned the same records. When I removed AND ([forms]![rreports]![Check98]=False Or [Task Type] <>...

Sorry. Actually, that was only the end of my query. The whole thing looks like this: [code} SELECT qryResearchStaff.ID, Joblog.[Job Number], Joblog.[Project Description], Joblog.[Task Type], Joblog.[Constituent Code], Joblog.[Requested By], Joblog.[Date In], Joblog.[Date Out], Joblog.[Time...

Here's what the end of my query looks like. It produces a syntax error. HAVING (((Joblog.[Date In]) Between [forms]![rreports]![beginningdate] And [forms]![rreports]![endingdate])) WHERE IIf([forms]![rreports]![Check98]=vbChecked, [Task Type] <> 'list request', 1=1); Maybe I'm missing a...

Thanks very much for your reply. I'm unsure where to implement this code. Should it be the header in a new column in my query, or should it appear in the criteria of an existing column?

I have a form I'm using to input criteria for a query that outputs to a report. The database is a job log that tracks a number of criteria on jobs done by the people in my department. I have a query set up that feeds my report, but what I'd like to do is include a way to *exclude* all records...