I would like to know how to round a number to its higher value (Ex. 5.3=6
5.5=6  5.9=6 and 5.1=6) I'm trying to do it with a simple expression
=(Round([text85];1))*[text81]
thanks in advance

This is probably simple but it has me stumped.
I have a tab control which has several text boxes on one of the tabs.
This tab has no other controls such as command buttons etc.  When I
select the tab, the focus moves to the first text box.  In the absence

I'm working on a database to track students in a Title1 program that
provides special tutoring in Reading and Math. There is a set of criteria
that determines which students get placement in the Title1 program. On a
month to month basis, I need to know who is in the program. A ...

Here's what I was doing, it is obviously stupid because i have exceeded the
"too many fields defined error"
I have to create a database driven application that allows students to
update the records of which classes they took, what grade they received, and

After spending several hours trying all I could imagine and search for in
Google I gave up. In a continuous form I want to sort the choosen column by
clicking the header (label) of that column. I even want to sort up and down
if one clicks again on the same header. No problem so far ...

Is there a way to query Microsoft's index server service from an
Access front-end?  When you run the index service on a workstation (or
a server), you can full-text index a directory/series of directories
and you can query that via the quick-and-dirty query capability under

   I am able to display the contents of a table to a form in datasheet
mode. I would like to change the background of the rows displayed to red or
blue depending on what the value of one column is. For example,
First     Last         Color

Hi, I've got a field that contains a list of rooms.
In most cases, this contains a single ID. However, under some
circumstances, the field may contain a list of two IDs which
are broken by a comma.

Hey people,
I have to convert MS Access 2000 database into mysql database, the whole
thing being part of this project I'm doing for one of my faculty
classes. My professor somehow presumed I knew db's and gave me long list

In the ldb file you can see the users of the mdb-file. If you open the
mdb-file your machine and username will be written in the lbd- file.
Allthough you close the mdb-file your name won't disappear from the
ldb-file, before every user has closed the mdb-file.

I am developing databases in Access2000.  Most of my work is done on my
desktop computer, which has a printer attached.  However, whenever I try to
view, design or preview a report on my laptop not connected to a network), I
get Run-time error #2202:  "You must install a printer ...

Does anyone know if there's a way to mirror data from a backend database to
a second database?
Example: When writing data to one database it would mirror the data in a
second database for backup

I'm an experienced application developer in some languages (including
various SQL dialects), but have very little experience with MS Access or
VBA, and am having trouble figuring out how to even get started with the
following seemingly simple task...

I am currently using an unbound OLE object to display images stored in a
folder. I want to be able to print these images from their normal format
(it just happens that these are A4 scanned documents) so they would
simply come out as 1 sheet and good quality. I have a print button on ...

(this is s repeat post from MS community newsgroup)
I am building a form for people to use to analyse the data
in my Access2000 database. The SQL is built up in VBA
depending on control values set in the form. How do I