[AccessD] Need help

wouldn't it be Mid([Event Number],3,4)?

The first number is where to start and the second is how many to take.

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Heenan,
> Lambert
> Sent: Wednesday, February 08, 2006 4:25 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Need help
>
>
> Extracting the text in positions 3 through 6 is easy...
>
> txtSomeTextVariableOrSomeTextControl = Mid([Event Number],3,6)
>
> But how those four characters translate to a date is another
> matter. Can you
> show us some examples of the data that appears in [Event Number]?
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DorisH3 at aol.com
> Sent: Wednesday, February 08, 2006 4:17 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Need help
>
>
>
>
> I apologize ahead of time but I am fairly new to Access and desperately
> need
> help.
> I have a text field called Event number I need to remove the text from
> position 3 thru 6 and place it into a date field on a form....can anyone
> tell me  how
> I can accomplish this task. Thanks for any help extended my  way.....D
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>