I need to transfer number of total amount  to english expression. for
example,   " 80,655.84"as " sy total us dollars  eighty thousand six hundred
fifty five and cents eighty four only".  Pleaase tell me how to do?

I have a productivity report (money generated) by sales people. The columns
are different categories of sales. Entries for some columns are missing
because the sales person was not active with that line. The value of the
column is probably Null in that case because the left outer ...

How can I locate an individual report, in a set of records of well over 100,
without clicking through the whole list?

I have a report that groups records by e-mail address.  There is no standard
number of records per e-mail address.  Is there any way to send the person
their page and not any of the other pages then repeat this for each e-mail
address?

I am trying to create a database that, when opened, the only object to appear
anywhere on the computer creen is a particular form in Pop-Up view. I have
set the startup to open this pop-up form but i would like to see the database
window dissapear altogether, including from the ...

I have created a report at home and set it to
Landscape, Legal on my Epson inkjet(default Printer).
However, when I deliver my program with this report,
to an office using a small network, somehow the report

I have a report that takes up all of the 22" that i am able to see. Is there
a way that I can make the report in design to go past the 22". any help would
be appreciated.
thanks

I'm trying to use dlookup in the control source of a text field in the header
section
of a report. If I used a query to get the result it would be this:
select EMP_CODE from EMPLOYEE WHERE EMP_CODE = 'nah'

i have one form where i enter patients data and expenses. and i have three
reports to be printed for it.one for ticket LPO , one for advance payments ,
and one is for printing details report. i am print these three reports by
having one command button (using macro) to print for ...

If the numeric field in a report's underlying query = 47, I want the report
to print "Los Angeles."  If the field says something other than 47, I want
the report to stop and prompt the user to enter the city before the report
prints. How can I do this?

I have a report with columns and headings, and a sub-report that displays the
detail for these headings. When the detail does not need more than one
column, it looks fine, but there are a few headings that need more than one
column to display all the data. The detail for these ...

I have numerous drop down boxes in a "Student Input Form" that get their
values from the table 'Students'. When I move to the next record, the drop
down boxes that I have selected and therfore have inserted in the table
'Students' are correct. Those drop boxes that I did not used ...

I would like Access to Create a Random Number (eg 1132GH667UIIP) for a
student ID tag, that creates this once a day if that record is opened. This
for for Parents to collect their children from our Sunday School. I will
print labels for the student and for the parent with the ...

I am having troubles trying to create a sum in a report.  I have a report
that is grouping on different divisions.  I have made some calculations in
each division on the report.  I have named the cells "division Totals", it
adds different cells in the report, when I go to do a ...

I have a report that I must count the number of check boxes in the on
position or the is not null.  I used the "= Count ([Injury])" below the
footer but it counts all the  check boxes even if they have not been checked.