Dates in access.

[SkippyjonJones]

I’m looking up some date info in a large table. I have a date for each item but I need to be able to return the last date of that month for each item (in a separate field). Ie- anything in Jan-09 need to show a date of 31st Jan 09.

Anyway of doing this?

[John am Rhein]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[John am Rhein]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[SkippyjonJones]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[John am Rhein]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here