Custom invoice subreport: I have a conditional sort in the
"Sorting and Grouping": =IIf([CustomerID]=3803,[ItemNumber],[SKU])
however I cannot get the Itemnumber field to sort numerically, I have
tried val([ItemNumber]), CInt.. etc., The recordset is a query of a few

i am a beginner. so please excuse me for my ignorance...
I have created a query which gets its parameters from a form. Now I have
created a report based on this query. When I open the report, the form
appears as reqd. But when i just close the form without entering the

Appreciate simple code to draw vertical line from top to bottom of Detail
Section. Line to be drawn approximatley 1 inch from left margin. Thanks in
anticipation.
S Kahn

I am using Access 2003 and I have a printing problem that I hope someone can
resolve for me.  I have about ten seperate and different text boxes in my
detail band.  My problem is that one particular text box called insured  can
grow, which is fine but since I put borders on all ...

I have a class summary report and i would like to find the number of missing
assignments.  The missing assigment report is from another query. Is there a
way i can create a formula in my summary report and obtain the information
from my missing assignment query.  Thanks you in ...

Where can I find information on iff statements and if I can use it in the
case.  What I am trying to do is design a report that will be populated with
sum values of data by month.  However, if the month has not occurred as yet
and there is no data to populate the field, the ...

I need your help. I know how to count records/items in a report but my
problem is that I only want to count those records/items I want. Like for
example, “Civil Status” field, I want to count how many are married, single,
and separated in a single report. Please help me and teach ...

Hi;
We have some tables with a complex format that are drawn in some Microsoft
Word files.Each word document contais just 1 design that i need convert all
of it as 1 report.Redesigning them takes a long time for me.

In a Form I have 3 combos that they go "filtering" the records that are read
in exactly form in one listbox.
One of the fields IdRecord.
When click in the one list box row (one record), it opens a Report but it

I know how to access table data on forms with use of recordsets for delete,
update, and add records to a table that is not bound to a form.
I think I am in a similar situation where I have a report that has a couple
function calls to a module and within each respective module ...

I need to generate a report that needs to call up data from different dates.
For example, my data base records that date that a loan application is
approved, declined, cancelled, settled ETC.
I have set up my reports via queries. Each query has the following in the

I have created a Control to Print the current record as an Invoice.  This
works fine, but when a new record is added and you go direct to Print
Invoice, The details are missing and I suspect this is because the new record
has not been saved.

I am trying to make a Label Control Visible based on the value of a Textbox
in my Report's Open Procedure:
If txtSubTotals.Text = "No Data" Then
 lblMessage.Visible = True

I have a report linked to a Foxpro table.
When I link the table if the dates in Foxpro are blank they comes as time
over to Access. 12:00AM. The records have several fields with dates.
So if I choose one field with a date, and some other fields are blank they

I have two combo boxes
vendor number and month1
I did a find record with combo box for the vendor number-Works great.
Now I need  it to work along with month1.  This combo box list all 12 months