formating a date field to month and year only ms access 2003

[Panchovia]

I have a member database each member pays a monthly fee

How do you correctly format the date field for month and year only in ms access 2003,
do you make to fields for a range if a member pay let say 6 months in advance or can you do it in one field also.

And how do you search after you make these fields for missing

months not paid.

Pancho

 

[PWise]

format(date(),"mmm-yyyy")

 

[SkipVought]

First, the solution that PWise submitted, does not format your date field, but converts your date field to a STRING in mmm-yyyy format in a query, for instance.

You questions are not phrased clearly. Please explain what you need to do. Please post your related tables and table structure. Are you trying to store payment history?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Panchovia]

Yes I want to store and keep track of all payments, for each member, right now I am using a text field (note the info for this field is fill in by the operator)
field name reference, the Idea is to make another field paymentref.
then I will update the paymentref field with the info from the reference field, and if every is ok to later remove the field reference.

There is one problem with the reference field right now which is a text field this includes also range payments of members who paid there contributions in advance.can this be stored in one field this is my first question how, and how do I have to format this field.

Afters this is acomplisch I want to run a query to see for missing months for each member that did not pay their contributions for a certain month.

Is their a specific code for the query to handle range payments.

example; member pays the months first record jan 2010
second record feb 2010
third record mrh 2010
fourth record he then he pays apr/dec 2010

the query should return all months paid

and not missing months may/nov 2010

 

[dhookom]

If you want to create any meaningfull reports, you will need to store something like the beginning and end dates for the payment or possibly a single record for each month.

Unformatted text fields don't meet criteria for financial (or other) reporting.

Duane
Hook'D on Access
MS Access MVP