This works for me: Expr10: IIf([Billing Term]="Collect",[Destination])
but how do I do the following or can I?
Expr10: IIf([Billing Term]="Collect",[Destination]),IIf( [Name]  "COD" isNot
[Billing Term]"Collect",[Destination])

I am using Access 2003
I have been working on a database created by someone else.  Every now and
then, we get the following error message.  YOUR MICROSOFT ACCESS DATABASE OR
PROJECT CONTAINS A MISSING OR BROKEN REFERENCE TO THE FILE "MSOWC.DLL"

How would I write a formula to eliminate any invoices starting with the
invoice number 02 that have a 0 claim value and are less than 60 days old?  
My query has the following columns:
Inv Num     Claim Amt     No Days Open

I have a table that has data from July 2005 though the end of 2006.  I
created a report that sums the totals by month.  I tried to create a YTD
Total in the footer that would only give the total for 2006 of the months
that 2005 had shipments in.  So only would total July 2006 - ...

I have created a report in MS Access. The report looks much like an excel
spreadsheet. Every text box and the Detail section is set to CanGrow.
How can I set the entire detail section to be the same height and adjust
size according to the largest text box in the section?

Is there a way to get the time from the system clock and import it into a
field in a table? I'm familiar with Access but new to SQL and do not know any
Visual Basic. Thanks.

I wasn't able to find my question on another post so please help.
I have a database that my team of 4 use to track our projects and time
working the projects. about once a week, the first record in the
table/database gets written over. I know it's someone's mistake by not

I have inventory data from seven different Tech Trucks that are being dumped
back into the main warehouse as the Techs are being eliminated in that region.
Each inventory is currently in its own table, with fields for Part#, Qty &
Cost. I need to add the quantities of like Part#'s ...

I am trying to export data that has a variable number of leading zeros.  The
export into Excel always drops the zeros which I wish to retain.  The data
type is set to text. When I export the report to a "txt" file and then import
into Excel I am able  retain the zeros.

I'll go into details in another post if necessary, but I was wondering if
anyone had noticed flakiness when copying records from an Excel spreadsheet
and then Paste Appending them into a table. If I have a combination of
numbers and text in the Excel column, only the numbers get ...

Is it possible to use Lotus Notes to automatically e-mail a report from
Access?  If it is does anyone know how to do it?  I have a found a lot of
great code using Outlook.  Any suggestions for Lotus?

I have pictures in a database report, 4 per page. I have the pathname in the
field in the records, and assign the picture to an image control in the On
Print event of the Detail section. The pictures are incredibly slow and the
report crashes on the third page when my client runs ...

I was trying to intiate many to many relationships with tables in a database
but when trying to follow the instructions on how to do that in Help, the
instructions read that I should select Database Diagrams under Objects in the
Database indow.  There is no Database Diagrams ...

I have a weird one: A user here has started getting Access error messages in
German. He regularly imports Excel spreadsheets that come from European
suppliers. We're not sure if it started after he imported one of those, or
it could have been after I installed the BMW ETK ...

I've read through a rather large amount of posts, and I can't seem to find a
direct answer to my question even though I understand there are many related
questions, so please pardon my ignorance and newby status.
I am trying to create a form that lists "risks".  These risks are ...