Reports

Vertically Aligning Fields in a Sub-Report
I'm putting together a report for a service database where each service ticket can have multiple call reports, and each call report can have multiple engineers associated with the report. While all the data's getting on to the form, the vertical alignment shifts if there's more then one service engineer. What... 7 Jul 2008 22:47

Order Details in horizontal list instead of vertical list
Is it possible to have the order details to be listed horizontally which is seperated by a comma after each value instead of the default vertical listed. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200807/1 ... 5 Jul 2008 12:31

Case statement Problem not resolved Still
Doug; The Value of the Me.Combo28.Column(1) is Like 'B*' , and any other variations.(Like 'C*', etc.....). You helped me with this earlier on. The lstbox gets poulated with items that start with a B when I select a combo box value of Like 'B*', and so on. No all I want to do is print the items in the lstbox , ... 5 Jul 2008 10:28

Graph won't display Zeroes
My report has a bar-graph of items per month for the past year. In months where zero items were produced, I want to show zero but the chart skips the zero months. How can I make every month show? All 12 months even where production was zero. ... 11 Jul 2008 12:00

Decimal Problem
Hi My report is based on the following expression in my query in one of the text box: Balance: Format$(nz(([sumofpoamt]-[paidnet]),[sumofpoamt]),"$0.00") This works fine but when I added another text box to sum the total, Access ignore the decimal number. For example: 8.00 9.00 6.25 Access display 2... 5 Jul 2008 18:39

Case statement Problem not resolved
Damon; I tried your code and I added 3 message boxes at the end of the code to see the value of the stDocName and it is always the report name in the Case else statement. It seems that we are close, but the conditional reports are not being picked up . "Damon Heron" <damon_327(a)hotmail.com> wrote in message ... 5 Jul 2008 06:24

Case statement Problem few more tries
I tried the code without the left function, and my debugging message box returns what is actually in the combobox column(1) which is any of the below criteria. here is the code: ............................................................................. ............................................................... 5 Jul 2008 10:28

Case statement Problem Compile Error
Compile Error Expected Expression if I put ? Debug.Print Left(Me.Combo28.Column(1) & "", 1) in thr immediate window Also I get an error that the Value of the Combo Box is not set yet.or not calculated. I used to be able to use the immediate window very successfully. Please tell me if I am doing something wro... 5 Jul 2008 02:21

you must define a sort field or expression for group header or
You probably deleted the field name from the column but didn't delete the entire row in the sorting and grouping dialog. It's much like deleting a value from a field where you should have deleted the entire record. -- Duane Hookom Microsoft Access MVP "iccsi" wrote: On Jul 4, 9:52 am, iccsi <inu...@... 4 Jul 2008 14:07

Report to display SQL code
On Jul 3, 7:56 pm, questy <que...(a)discussions.microsoft.com> wrote: Hi There I have a form with 17 checkbox options for the user to select. Once the user selects the checkboxes  he then clicks a button that is suppose to run a report. based on the options selected this report is to display  sql syntax ... 4 Jul 2008 13:05