working with date- month and year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm tring to creat a fiel that have the month and the year of the data. But
turn out that is quite dificulte to do so. I excel I do that all the time to
sort out the bill I have I one month of the year, but for some reason access
can't do so. I want to have that data in the date format. The reason for such
data is to create a relationship betew two tables. One is how much I have to
pay and to other one is how much I will recive from my clients.
 
Felipe

Microsoft Access has a date/time field that lets you store a point-in-time
(i.e., a date & time). But you can use Format() to alter the appearance of
whatever date/time is stored such a field.

If you want (only) show Month & Year of a date, use Format().

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I'm tring to creat a fiel that have the month and the year of the data. But
turn out that is quite dificulte to do so.
Click to expand...

Only until you know how... said:
I excel I do that all the time to
sort out the bill I have I one month of the year, but for some reason access
can't do so. I want to have that data in the date format. The reason for such
data is to create a relationship betew two tables. One is how much I have to
pay and to other one is how much I will recive from my clients.
Click to expand...

You can't (and shouldn't) have separate month and year fields in your
Table, but you can use Month([datefield]) and Year([datefield]) as
calculated fields in a Query. (Don't name the fields Month and Year
though, Access will get confused).

You can even do a (non-updateable) Join using these calculated fields.

If this isn't clear please post a description of your tables and the
relevant field types.

John W. Vinson[MVP]
 
Back
Top