How do i extract only part of a field

[crysma]

Hi,

I was wonderning if anyone could help me out with a problem I'm having. I've got a database which contains, among other information, the date of registration for clients. These dates are organised in a dd/mm/yyyy format. Is there anyway to extract just the year using a query? I'd like to have the query sorted by year and by client ID. I'd appreciate any suggestions. Thanks in advance,

Sheryll

 

[xlbo]

Assuming you're using access, instead of just dragging the field into the query, right click on the space where you would drag the field and select build
Thewn, use the wizard to create
=YEAR([DateFieldName])
This will then return teh year associated with the date field along with any other fields you care to bring thru Rgds
~Geoff~

 

[crysma]

Works like a charm! Thanks Geoff ^^