Displayed value

[hockeylvr]

Could someone give me some keywords to look up to find out how to do this? I have searched almost every post in Tables, Reports and Queries with no luck.

I have a form "Projects" with 6 date fields (cutinact,cutinplan,etc.)
The rowsource is
SELECT [tblMonths].[monthid], [tblMonths].[month] FROM tblMonths;

Bound column = 1
Column Count = 2
Column Widths = 0;1

I want the actual Month name to appear in the table and in my report that is based off of the same query. Right now I am just seeing [monthid].

What should I be searching for to accomplish this?

Thanks!

 

[dhookom]

What are you storing in tblMonths? Is your Month field just a month name like January, February,...?

I assume you are storing the value from the MonthID field in your table (in six different fields). Could you provide more information?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[hockeylvr]

In tblMonths I have monthid and month(month name (January, February) I'm not "storing" anything here, but need to store the month name in my table instead of the monthid.

I need to have monthid as my bound column in my combo box because I am using it for another calculation on my form.

Thanks,

Toni

 

[dhookom]

Toni,
So, are your MonthID values 1-12? If so, you can get the month name by using:
Control Soruce:=DateSerial(2000, [MthNumField],1)
Set the format of the control to:
Format: mmmm

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[hockeylvr]

That's giving me a parameter window for the cut in month and gives an error if I don't enter in a month number.

I went into the table and changed the date fields to lookup fields and that gives me the actual month name when I run queries/reports. I don't know if that is the best way to do this though as I have heard negatives about using lookup fields.

Thanks for your help.

Toni

 

[hockeylvr]

Found what I needed in this post from scriverb.

http://tek-tips.com/viewthread.cfm?qid=831892

Thanks!

 

[dhookom]

hockeylvr,
You sure seem to have avoided questions about what is stored in tblMonths and your six date fields.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[hockeylvr]

So my earlier response wasn't sufficient when I gave the exact field names and descriptions? I don't see how what I'm storing in my six date fields is of any significance since they are all using the same rowsource. For the record, the six date fields reference six different actions -cutinplan,cutinactual,tryoutplan,tryoutactual,contractplan,contractactual.

I find your post completely unecessary and a waste of this forum's time and space. I thanked you for your help. I don't just ask a question and then sit back and wait for someone to solve it for me, I continue to look for the answer on my own and, if I find it, share it with everyone else.