I have a database that is used to create reports based on data we receive from a vendor. I have been working on using forms to make report selection easier for my employees. My vendor sends us an invoice for the service with notation regarding the dealer and the amount billed for each account. One of our reports sorts the data by dealer and creates an amount associated with each dealer. We use this data on a billing report to bill our dealer.
The vendor also has a vendor bill date for each record.
From time to time a dealer wants to see the detail of their bill. We have another report that uses the vendor bill date and the dealer number to select the data for this report.
My form that selects the data for the initial billing report looks at a table that displays the months in a combo box. i.e. January, February… We have a text box where we enter the year.
I have another form that uses this same information to create the selection criteria for the dealer detail report. On the report I want the month shown as January, February… While the combo box displays the text month the numeric month is used for the actual selection.
I have a table in my database with 2 fields, one numeric from 1 to 12, the other the text month.
My question is how can I build the expression in the report text box to show the text month. Currently I have the expression to look at the combo box but the numeric month is what shows on the report.
Thanks for any assistance you are able to provide.
The vendor also has a vendor bill date for each record.
From time to time a dealer wants to see the detail of their bill. We have another report that uses the vendor bill date and the dealer number to select the data for this report.
My form that selects the data for the initial billing report looks at a table that displays the months in a combo box. i.e. January, February… We have a text box where we enter the year.
I have another form that uses this same information to create the selection criteria for the dealer detail report. On the report I want the month shown as January, February… While the combo box displays the text month the numeric month is used for the actual selection.
I have a table in my database with 2 fields, one numeric from 1 to 12, the other the text month.
My question is how can I build the expression in the report text box to show the text month. Currently I have the expression to look at the combo box but the numeric month is what shows on the report.
Thanks for any assistance you are able to provide.
