Search results

Alan Simpson Number to text You very kindly gave me details for converting numbers to taxt from an Alan Simpson sample. I have tried going to the above site again to-day (April 12, 2004) but I am unable to get to that site. Do you have a new place I can go and find that same sample from...

These two tables are linked and I have to have the Project Budget with all the project details. It is a one to many table - so it works just fine.

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...

Please see Lynnjm 02-13-2002. I used the Alan Simpson method and it works brilliantly.

I have the same problem in my report and this solution did not work for me.

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...

My problem is not with the and or or - it is when I create my report. If there is no associated entry in either the Expenses or Disbursements (to go with the hours) then the report totals for expenses, disbursements and total with show "Error". I can get around this by putting a dummy entry of...

That is correct - I don't want 0 or null values to show. However, if I select this option in the query for my report' when I look at the report "Error" will show up. If I remove the <>0 or not null from the query, on which the report is based, then the "error" message has gone, but all the 0s...

Rich: No, it is a numeric field and I only put "" on it for emphasis in this text - I do not include " in my queries

Thank you Pat, but this does not really address the problem I was having. I have a form, Consultants, with a subform, expenses. Even if there was no expense allocated to the consultant for a specific job on a specific date, I still have to make a "0" entry in the expenses subform, otherwise I...

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...

I have just tried the Alan Simpson version and it worked beautifully. Again, thank you so much.

Thank you so much - I shall be giving all the suggestions a try. Really appreciate your trouble.

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