In my report, I want to sum the time for a particular item.  I have a field,
Duration, and it can have anywhere from 5 to 19 lines of time (short time).  
Nothing I try seems to work.  
Thanks

I'm trying to do a weekly report that counts the number of work orders
done during each week.  Given only the Open Date and Closed Date, I
can only know if a Work Order was opened during a certain week by
asking if Open Date was <= The end of the week and the Closed date is

hullo - -
i've done the thing in the registry and set the value to '0', but now i'm
getting a 'cannot locate file' message.
i know there are Others with the same problem, even having done this

Is there a function that, when given a parameter returns 0 if the parameter
is negative and returns the parameter when it is positive?  Here is the
scenario in which I would use such a function.  I have a school database that
tracks how many credits one needs in each department.  ...

I am currently at the stage of distributing my access db, and after a
few hours of reading i have still not come to a satisfying solution
regarding security.
My db is split into FE and BE, my customer will most likely be running

I understand that Access database can be created from Excel file.  If you
have an Excel file that has each row containing data pertaining to each
individual, is it possible to produce a report where each page will contain
the information for just that row and print it out?

I'm using Access 2007 and yesterday we had a power failure and the machine
got switched off abrubptly. I was doing data entry on a new record in a
particular table through a form.
On resuming I found that particular records I was entering went into #Error

When I open a Word 2003 document in Word 2007, it deletes all the
auto-numbering of paragraphs in a contract document.  How do I stop this?

Is there any way to add a new line to the control tip?
Right now my control tips are really long.  I am displaying the functions
that users can perform if they click a button.  For example, a button
labelled "Reports" would display "Project Status Report", "Data Entry Status

Everyday a macro is run that prints out reports, then suddenly the other day
I am unable to run the macro on the computer that usually does this process.  
I copied the db to another computer and can run it fine.  When I try and run
the macro on the original computer I receive an ...

I have a big report that is listing customers and the reps/companies they
worked with.  I need to find out which of the customers have worked with a
company more than once and if it was with the same company multiple times or
different companies.  Any ideas how to do this?

I am reposting because I don't know if anyone will look at my additional
question.
I got a general answer from Tony to my question "but insert that code in the
FE.  Check a version number you have specified in the FE against a field in a

I am trying to put together a FORM where the employee (mgr) schedules
cleaning jobs to be done for that day.
Each record will be a given DAY.  It will include the employees available
for that day and then ALL jobs that need to be done.   Once the job is

I am working with an existing database. The form is pretty complex and pulls
from several different tables.  One section states Years to Display and they
currently have it set up to just display one year. I want to make list boxes
that state Start Date (mm/dd/yy) and End Date ...

I use access 2003 sp2 with source safe.  Some little bugs but it works fine.
Having just upgraded to Office 2003 SP3, impossible to create a new database
from the source safe project.  Many messages during the import of many forms
(? error during importing, can't find record, ...) ...