Collumn select?

[Nico]

Hi there,

I am new tot Access. Maybe this has been discussed earlier, sorry for
that ;-)

I want to show 4 columns in a query. Last month, Current Month, Next
Month en the month after that. These columns come from a table
containing al 12 months.

Is it possible to change
SELECT [Planning]![apr]
FROM [Planning]

into

SELECT [Planning]![Month(Date()+1)]
FROM [Planning]
?

What is the used syntax if this is possible?

Thanks!

Nico

[Ed Robichaud]

It may be too late to change your structure, but having a table/field for
each month is not a good data design.
A better approach is just to record dates (in a related 1-Many table), then
filter/sort records on the value of those dates. The DatePart function will
get the day/month/year component from any date/time field.

-Ed

"Nico" <ni*********@gmail.com> wrote in message
news:7b*************************@posting.google.co m...

Hi there,

I am new tot Access. Maybe this has been discussed earlier, sorry for
that ;-)

I want to show 4 columns in a query. Last month, Current Month, Next
Month en the month after that. These columns come from a table
containing al 12 months.

Is it possible to change
SELECT [Planning]![apr]
FROM [Planning]

into

SELECT [Planning]![Month(Date()+1)]
FROM [Planning]
?

What is the used syntax if this is possible?

Thanks!

Nico