Using Access

[NeoGreen]

Hello,
I have a question, I was wondering if this was possible. I have items that carry serial numbers. Within the Serial number it has the year the item was made. What I want to do is create a query that I can run, in which all items created in a certain year are shown. Here is an example of a serial number: FSB0612218421, the 06 is the year the item was created. Is there a way Access can distinguish or separate the items even though the year is fourth and fifth digit from the right? I hope I am wording this correctly.

 

[Golom]

To select items for a specific year

Where Mid([SerialNumber],4,2) = '06'

To report by year

Select Mid([SerialNumber],4,2) As MfgYear, ...

From ...

Order By 1

 

[ChrisCalvert]

Certainly it can. You should be able to use the LEFT function, and the RIGHT function to get this information.
Just take the LEFT 2 digits of the RIGHT (LEN -3) and that should get it for you. Please let me know if this is not clear.

 

[NeoGreen]

Awesome, thanks for the information. I'll try it.