Advertisement

07.19.2005 at 03:03PM PDT, ID: 21497348
[x]
Attachment Details

extracting this string

Asked by zachvaldez in Microsoft Access Database

Tags: months, extracting, string

How can I get just the month portion...

WHERE left(([Monthly_Forecast_Table].[Month_Forecast],1)=[Month].[MonthID])) ---> does not work
say 9/1/2004 = 9

in the month id table i got the id from 1 t0 12...
Start Free Trial
[+][-]07.19.2005 at 03:04PM PDT, ID: 14479971

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.19.2005 at 03:05PM PDT, ID: 14479975

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.19.2005 at 03:05PM PDT, ID: 14479978

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: months, extracting, string
Sign Up Now!
Solution Provided By: flavo
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32