N
Niklas Östergren
Hi!
Is there anyone that knows the syntax for DatePart function in query design
mode.
I´m trying to produce a QBF but don´t know exactly how to get the result I
want. So right now I´m exerimenting with DatePart in a query to see the
result I get.
I want to get all records from [MemberShipEndDate] for year 2003. The result
I get right now (with the SQL statment below) is zero / nothing. But I DO
have records with [MemberShipEndDate] for 2003 in
[tblMemberValidation].
The questions the user want to get answer on is:
1.) Which person (PersonID) hav valid membership ([MemberShipEndDate] >
Date() )?
2.) Which person had membership last year (ex. 2003)?
3.) Which person had membership last year and have NOT valid membership
today?
All help is appreciated!
TIA!
// Niklas
Her´s the SQL statment I´m using now:
=====================================
SELECT tblMemberValidation.fkPersonID
FROM tblMemberValidation
WHERE
(((([tblMemberValidation].[MemberShipEndDate])=DatePart("yyyy",[MemberShipEn
dDate]))=2003));
Is there anyone that knows the syntax for DatePart function in query design
mode.
I´m trying to produce a QBF but don´t know exactly how to get the result I
want. So right now I´m exerimenting with DatePart in a query to see the
result I get.
I want to get all records from [MemberShipEndDate] for year 2003. The result
I get right now (with the SQL statment below) is zero / nothing. But I DO
have records with [MemberShipEndDate] for 2003 in
[tblMemberValidation].
The questions the user want to get answer on is:
1.) Which person (PersonID) hav valid membership ([MemberShipEndDate] >
Date() )?
2.) Which person had membership last year (ex. 2003)?
3.) Which person had membership last year and have NOT valid membership
today?
All help is appreciated!
TIA!
// Niklas
Her´s the SQL statment I´m using now:
=====================================
SELECT tblMemberValidation.fkPersonID
FROM tblMemberValidation
WHERE
(((([tblMemberValidation].[MemberShipEndDate])=DatePart("yyyy",[MemberShipEn
dDate]))=2003));