Search results for query: *

Hi We have a date of purchase for an item in one column. It as a warranty of 3 years. I want to set a column where it says how long is left on the warranty (perhaps in months)based on the purchase date if it is out of warranty in 3 months to display in green , if out of warrnaty to display in...

Hi If I have a spreadsheet with order number and totals for year. However we have 2 types of order direct and stock. This is show by the order number, direct as a - sign in. We would like a total for both types. Example below Order NO Article Amount Toal Sum Direct TotalSum Stock...

Hi We have a spreadsheet linking into our sql databse. We bring out order rows. We sort by order number. If we want to put a blank row after every new order number is there a way to do this? Thanks

HI How can we set a full column so it displays the current amount of working days for this year. This should update each time we oprn the spreadsheet. Also the same but for weeks for the current year. Thanks for any help in advance

Hope someone can help If we run a query and want a field to be filled in with another field (asuming the field is null) then what expression can we wrtire in a query so that the field is filled in with the alternative. Example : Delivery address 1 as a name in if it is null we want it to be...

Hi Does nayone know how to integrate access with a TAPI interface. We have an Alcaltel phone system that uses Pimphony software, we have created our table in access and we are told we need a small program to integrate with TAPI. Thanks

Hi Is it possible to make a table into an execuatable file at all. I am trying to link our telephone system into a table in access and it requires it to be an EXE file. It does link, or so it help systm says with Access. Thanks

Hi I created a formula that displays 1 if a date range is true and 0 if it is not true. This works, but what I want to do is count all 1 and then all 0 and this dispayed as a total of 1 and 0. No matter what I try I cannot get a total count. Can someone advise please, thanks in advance

Hi We are trying to mail merge with our databse. We do this through ODBC ad the connection is fine. The links are fine, however we want to. 1. Create one sheet full of first record of details. We can can get one lable, but it does not fill in all the other labels with the same information...

Hi I am trying to create a label in Crystal version 8. I have linked through SQl and have the link okay. what I want is to create a whole sheet of labels 2 columns by 7 (14 for each sheet). They are order rows and will go on articles related to each order row, I have grouped and forced new...

Hi We are trying t mail merge with our databse. The links are fine, however we want to 1. Create one sheet full of first record of details. We can can get one lable, but ti does not fill in all the other labels with the same information. 2. The create a new sheet if record changes and then...

Hi In the program file menu I have excel missing , how can I add it so it shows in my menu programs Thanks

I ahve lost excel out of my Start\Porgram files menu, how can I add it back in

I have lost Excel off my ALL program files menu, how can i get it back on there I am using XP

I want to count boolean fields in a report but only count the Yes . Any ideas how I can achieve this. Thanks

I have a YES NO field that I need to put a count on for only Yes. Could someone please tell me how to do this. Thanks

I want to be able to count on a list of true or false answers but only the true's. I ahve tried various formulae but either get all counted or none at all. Any ideas please.