Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. debbiecarvery

    Peer to Peer connection

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

    Installing ibm db2 v8 on Win2003

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

    Sub Reports and date ranges

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

    Access Report using cross tab queries

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

    2 probs with Access 2000 Report (using crosstab)

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

    Access Report using cross tab queries

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

    Access Report using cross tab queries

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

    Access Report using cross tab queries

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

    Want to print actual website addresses

    Thank you crisc. [2thumbsup] Debbie
  10. debbiecarvery

    Want to print actual website addresses

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

    Want to print actual website addresses

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

    Access Report - Having trouble calculating a field

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

    Access Report - Having trouble calculating a field

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

    Installing Custom Label (dos) 6.5

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

    IIF with a "and" statement

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

    IIF with a "and" statement

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

    IIF with a "and" statement

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

    IIF with a "and" statement

    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] =...
  19. debbiecarvery

    IIf statement

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

    IIf statement

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

Part and Inventory Search

Back
Top