S sando Registered User. Local time Tomorrow, 06:25 Joined Jul 7, 2004 Messages 25 Aug 4, 2004 #1 I have a query with a date field. The date field is set up "DD-MM-YY" in the table. What I want to do is when the date is: "1-1-04" is to show only the month as "January" Can anyone help thanks
I have a query with a date field. The date field is set up "DD-MM-YY" in the table. What I want to do is when the date is: "1-1-04" is to show only the month as "January" Can anyone help thanks
S sando Registered User. Local time Tomorrow, 06:25 Joined Jul 7, 2004 Messages 25 Aug 4, 2004 #2 Do worry. I have it sorted. I inserted the following code into the query field. Date: Format(sales!Date,"mmmm")
Do worry. I have it sorted. I inserted the following code into the query field. Date: Format(sales!Date,"mmmm")
