Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.79K
~87 People Reached
Favorite Forums
Databases x 1
Favorite Tags
microsoft:access x 1
database-sql x 1
1 Posted Topic
Assuming that your format is always the same (yymmdd) and that it's placement in your string is always the same, try adding this to your as a field in your query, replacing [Example] with the field name that your text resides in: DateConversion: Format(Mid([Example],11,2) & "/" & Mid([Example],13,2) & "/" …
The End.