C cvboas Registered User. Local time Today, 11:38 Joined Jul 31, 2006 Messages 20 Aug 9, 2006 #1 Hi. I have a query where one of the fields is a date of days months and year, it wanted that in the criterion field it appeared only the months. Is that possivel? Thanks
Hi. I have a query where one of the fields is a date of days months and year, it wanted that in the criterion field it appeared only the months. Is that possivel? Thanks
W WrHn85 Registered User. Local time Today, 11:38 Joined Jul 9, 2006 Messages 31 Aug 11, 2006 #2 In your query you can add a field to convert the format of the date to month only: Expr1: Format([whicheverdatefieldyouareusing],"mmm") hope that's what you're looking for
In your query you can add a field to convert the format of the date to month only: Expr1: Format([whicheverdatefieldyouareusing],"mmm") hope that's what you're looking for
M modest Registered User. Local time Today, 14:38 Joined Jan 4, 2005 Messages 1,220 Aug 11, 2006 #3 you can use yoru choice of "m", "mm", "mmm" or "mmmm"
