Query not giving me what I need... help

[rikki]

This query is getting complicated for me... I need help please!
I need it to give me the data for people between FirstMonth, Year and SecondMonth, Year...
Right now it's giving me only the FirstMonth, Year and SecondMonth, Year...
I think I need a between there somewhere but not sure where to put it...??
Hope this makes sense.
I'm doing the query in Access 2002

Thanks
Sarah




SELECT [FirstName] & ", " & [LastName] AS FullName, TriOct10.FirstName, TriOct10.LastName, TriOct10.Address, TriOct10.City, TriOct10.Prov, TriOct10.PostalCode, TriOct10.VolScreenCode, DatePart("m",[PRCDate]) AS Month2, DatePart("yyyy",[PRCDate])+3 AS PRCDueY2, TriOct10.PRCDate, TriOct10.MemberType, TriOct10.MemberStatus, TriOct10.ExpandName, TriOct10.RegOrgName, TriOct10.RegisteredRole
FROM TriOct10
WHERE (((DatePart("m",[PRCDate]))=[Enter 1st Month]) AND ((DatePart("yyyy",[PRCDate])+3)=[Enter First year])) OR (((DatePart("m",[PRCDate]))=[Enter Last Month]) AND ((DatePart("yyyy",[PRCDate])+3)=[Enter Last Year]) AND ((TriOct10.MemberType)="volunteer") AND ((TriOct10.MemberStatus)="Active" Or (TriOct10.MemberStatus)="probationary") AND ((TriOct10.ExpandName) Like "*" & [What Area?] & "*"))
ORDER BY DatePart("m",[PRCDate]), DatePart("yyyy",[PRCDate])+3;

 

[Sammy B]

I believe you have posted the SQL of a query. I am not that good at SQL but within the query itself I would type this under the criteria for the date field.

Between [Type the beginning date:] And [Type the ending date:]

This will promt you for the required date parameters

 

[WayneRyan]

Sarah,

Hope this gets you closer:

SELECT [FirstName] & ", " & [LastName] AS FullName, 
       TriOct10.FirstName, 
       TriOct10.LastName, 
       TriOct10.Address, 
       TriOct10.City, 
       TriOct10.Prov, 
       TriOct10.PostalCode, 
       TriOct10.VolScreenCode, 
       DatePart("m",[PRCDate]) AS Month2, 
       DatePart("yyyy",[PRCDate])+3 AS PRCDueY2, 
       TriOct10.PRCDate, 
       TriOct10.MemberType, 
       TriOct10.MemberStatus, 
       TriOct10.ExpandName, 
       TriOct10.RegOrgName, 
       TriOct10.RegisteredRole
FROM   TriOct10
WHERE [PRCDate] Between CDate([Enter 1st Month] & "/01/" & [Enter First year]) And
                        CDate([Enter Last Month] & "/01/" & [Enter Last Year]) And
      MemberType = "volunteer"  AND 
    ((MemberStatus = "Active" Or 
      MemberStatus = "probationary") AND 
      ExpandName Like "*" & [What Area?] & "*")
ORDER BY [PRCDate];

Wayne