Search results

I have a table called Project Hours with fields. Two of the fields are Project No and Project name. The main table is called Project Budget where I also have Project No and Project Name. Is it possible, when I am in the Project Hours table that when I type in the Project No and then tab to the...

When I create a new database and then import all the data from my older one, I find there is no option to import my groups of favorites and I therefore have to recreate them each time I renew my database. Is there any way to import these groups as well? Thank you all.

I have a report that lists invoices for a months period. Some of the invoices are in US$ - so the first thing I do is convert the US$ into Cdn$. That works fine. I then want to sort out the HOLD invoices from the sent invoices. That works fine. The problem starts when I try to total, in...

I have a report basically made up our total hours, expenses and disbursements. If either the expenses or disbursements are 0, I would like to leave them off the report. However, when I do this (omit an items with a 0 balance) I then get Error! in my totals column e.g. Total hours...

When I enter the following statement: IIf([Fieldname]=0,null,[Fieldname]) I get an Error message. Also, in the query, if I say <> 0, the results do not show anything, however in my reports that field will then show up as Error in my calculations. Do you have any ideas what I am doing wrong...

Microsoft has come out with an add-on to convert numbers to text in Word 2002, but is it possible to do this in MS Access 2000. Would greatly appreciate any help. Thank you