Selecting month out of a date using a query?

A

Apprentice1

Could someone please help?????

I am wanting to select the month out of date using a query but i am unsure
how.

The date in the table as it stands is 20091225 and i am wanting to use the
middle 2 digits of the date but i am unsure want to use in the query to take
only those 2 digits?
 
A

Apprentice1

Thanks!

Jerry Whittle said:
TheMonth: Mid([TheDateField],5,2)
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Apprentice1 said:
Could someone please help?????

I am wanting to select the month out of date using a query but i am unsure
how.

The date in the table as it stands is 20091225 and i am wanting to use the
middle 2 digits of the date but i am unsure want to use in the query to take
only those 2 digits?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query to show where no data in a stated column 0
Creating a Chart on form from selected data in query. 0
Automation of scanned file storage based on content 0
Query the same table three times 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Improving Macro That Keeps First Letter 0
Crate Table Query - Closest to the 15th day..... 0
Query to select individual records 4

Top