Expression for multi-purpose field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working with a query that has a 14 position multi-purpose field.

Example:

14 position fields: widget (1-6) ; date 7031 (4) ; test (4)
reads as: "widge7031test"

I need an express that takes the date (7031) and places in it's own column.
 
You need to normalize you database so that each data element is in a separate
field.
The date should use a DateTime field and control the display in your query,
form or report.
You can concatenate them together in a query, form or report later.
 
Karl,

the mdb was turned over to me to work with. I need the date field in it's
own column for sorts, etc. Must be away in Access to do this.
 
IT05 said:
Karl,

the mdb was turned over to me to work with. I need the date field in
it's own column for sorts, etc. Must be away in Access to do this.
Click to expand...

=Mid([FieldName], 7, 4)


....will return the string "7031" from your example data. To use that for
sorting you will likely have to do further conversion on it. For instance I
can't see how that represents a "date". With just the above it will osrt as
text (alphabetical).
 
Thanks for the reply =Mid([FieldName], 7, 4) worked!


Rick Brandt said:
IT05 said:
Karl,

the mdb was turned over to me to work with. I need the date field in
it's own column for sorts, etc. Must be away in Access to do this.
Click to expand...

=Mid([FieldName], 7, 4)


....will return the string "7031" from your example data. To use that for
sorting you will likely have to do further conversion on it. For instance I
can't see how that represents a "date". With just the above it will osrt as
text (alphabetical).
Click to expand...
 
Back
Top