Accees report-how to display month as character

cindyl · September 13th, 2010, 11:09 AM

Hi everyone, I need your help here.

I have a query show month as 1, 2, 3..... and I use it do my report.
But on my report, I want to show month as January, February, March.......
How do I do?

Thanks,
C

Old Pedant · September 13th, 2010, 02:07 PM

Show your query.

But, basically, you should be able to use

Code:

   ..., MONTHNAME( theMonthYouAreCurrentlyGetting ) AS theMonth, ...

If you show your actual query, probably would be easier to help you.

cindyl · September 14th, 2010, 04:11 PM

could you provide more detail. I am using a query which has month shows as a number. but on the report, it should show September, October..

many thanks,
Cindy

Old Pedant · September 14th, 2010, 05:52 PM

As I said, twice, show your existing query. Without that, it's hard to say more than I already have.

cindyl · October 2nd, 2010, 08:01 PM

Hi everyone, I need your help!

On my Access table Projects0, my field name IndexCode, data type is text. I try to use combo box and List box. combo box for IndexCode0, and List box for ProJe. I need to bound these two fields. When I select item from IndexCode0, the related item should show up on List box Proje, but I got "data type mismatch in criteria expression". Here is my code:

****

Private Sub IndexCode0_AfterUpdate()
Me.ProJe.RowSource = "select ProjectName from Projects0 where IndexCode=" & Me.IndexCode0

End Sub

**

If I swithch IndexCode data type from text to number, it works, but I can not. Because in this field, many data start with 0, like 00723, so I have to use data type text for IndexCode on table.

Thanks,

Cindy

Old Pedant · October 4th, 2010, 02:08 PM

Code:

Me.ProJe.RowSource = _
    "select ProjectName from Projects0 where IndexCode= '" & Me.IndexCode0 & "'"

You have to put '...' around *string* values. Never around numbers. Always around strings.