Search results for query: *

Hello, My client is using an XP workstation as a server to test a data warehousing software. I have installed it on the workstation beingused as a server. When I try to access it from a client XP machine I cannot connect to the machine acting as a server when I open my application. It is...

Hello, I am presently trying to install IBM DB2 v.8 on a Windows 2003 server with the latest service packs (logged as Administrator on the server ) .I am receiving the following error messages: 1st- An error ocurred while launching the command d:programfiles....bi n/db2.exe.....the return...

Hello, I have a report that has 3 sub reports in Access 2000.I would like my report to have a parameter query.Problem is, I added " between (type beginning date) and (type ending date)" criteria to my query.All 3 subreports are based on the same query. When I open my report it prompts...

I was able to add info from my original query to my crosstab query. All is well "well kinda". I just added some new questions about this report on Oct 3.Thanks for your response. Thanks Debbie

Hello, I have a report that runs from a crosstab query the crosstab is built from a regular query. Here are my 2 problems. 1. There are 6 heading in my crosstab that I need to show on my report. As long is there is information in those fields I have no problems. If for any reason no data is...

This is the error I am getting from the REport Wizard, when I try to chose fields from my 2 queries. One is a regular query the other is a cross tab based on the original query. You have chosen fields from record sources which the wizard can’t connect. You may have chosen fields from a table...

OOps ! Not sure where the rest of my message went.Here is my original post. I am using Access 2000 I need a report that calculates numbers for salesmen and telemarketers statics. I would like to see, number of sales, cancellations, renewels etc. All these fields work fine and I am able to...

I would like to have: rep Deposits balance qual confir sale contract John 100.00 50.00 1 3 2 1 Mark 100.00 0.00 5 2 1 2 I have tried using a crosstab query and I am able to get the information I need on a regular query...

Thank you crisc. [2thumbsup] Debbie

Hey !!!! Your good ! Thank you, this is exactly what I wanted to do. Debbie

Hello, I have numerous favorites on my computer. I would like to print out a list of all my favorites (showing the actual website address).Is this possible with Internet Explorer 6.0 Thanks Debbie

Thanks CosmoKramer, That is exactly what I have tried. The form that the data is placed in has a sub form. So if I try to add an unbound field in the footer with this calculation, it calculates number of hours then multiplies by the number of items in the subform???? I don't get it ;) Debbie

Hello, I have built a production database in Access 2000 and it runs a few reports. I have one report where most of the calculations were done in the report and run off of a query. I need to add some fields to the report but I cannot get the fields to calculate properly. I am trying to add...

Hello, I am purchasing Custom Label for Accpac (dos ) 6.5 for $225.00 CAD, the company I am buying it from wants to charge me for installing it (about 4 hours) at $150.00 an hour. Is it that difficult to install it? I know where all my data is, and how to add in the start menu, I managed to...

Thank You !!!!!, -1 is giving me my "yes" that I need and 0 my "no". Debbie ;)

Yes, it is a check box, if I play in my queries and use "yes" or "no" I get the correct results. I "could" do this in a query, the only thing is I want to use one report to calculate totals on "equipe" with a no value and different totals on...

Thanks Kevin, I tried this and now nothing is printing. I checked to make sure my data actually had some fields where the equipe = no and there are definitely a few. The rest of the formula works it is when I try to add the [equipe]= no, I have no clue what I am doing wrong, any other...

Hello, Jim and bob helped me out with this statement but now I would like to add something, and again it is not working, perhaps someone can help . The Total VC area works, I want these numbers 12, 14 or 16 to print only if Equipe equals "no", I have also tried putting the [equipe] =...

Thank You, I tried Jim's and it worked, thank you both ;) Debbie

Hi, I would like to add a field to a report that calculates a bonus. If the employee has between 1000 and 1499 points they get $8.00 If the employee has between 1500 and 1999 points they get $12.00 and if the empoyee has over 2000 points the get $16.00. Here is what I tried entering in my...