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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Zoon

  1. Zoon

    SQL for subtotals & grand total?

    This query is for an Access 97 database and it works OK. With it I get a total cost for each department. Department is not the key field, there are 40 fields. There are 50 different departments in the Department field & 10,000 records. SELECT [Department], COUNT([Department]) AS [SKU Count]...
  2. Zoon

    HTML table row problem

    Could somebody tell me why this calendar looks wrong with DECEMBER, but looks right without <TH bgcolor=BROWN>DECEMBER</TH> <HTML><HEAD><style>a{text-decoration:none}</style></HEAD> <body> <TABLE BORDER=0 CELLPADDING=2 CELLSPACING=0 WIDTH=115 BGCOLOR=Yellow> <TH bgcolor=BROWN>DECEMBER</TH> <tr...
  3. Zoon

    Desktop Icons Move

    I have Windows XP Home on a Compaq Presario 6000. Sometimes when I start the computer the desktop icons are rearranged. I then drag them to where they should be. Why is this happening?
  4. Zoon

    WordPad won't Wrap

    I only changed the Text option to No Wrap, but although I set Text to Wrap and click OK it will not wrap. Now all 3 text types show Wrap to Ruler but do not wrap. The monitor view does not wrap, but the printing does wrap. I usually only use text to compose e-mail, then I paste it into Outlook.
  5. Zoon

    WordPad won't Wrap

    Word Pad won't wrap the text even though I click View>Options>Wrap>OK. Up to a week ago it wrapped, then I set it to No Wrap. When I went to set it to wrap it stays on No Wrap. What is wrong?
  6. Zoon

    Calculate a number field?

    Thanks for the help. This inventory control program has a bunch of forms but none are listed when using Access 97 to open the tables. I will work on this using your direction.
  7. Zoon

    Sum of a Sum column?

    I have these 3 fields (and others) in an Access 97 database; [Department] a text field, [Quantity] a number field, [Cost] a number field. There are 30 different departments and 9000 records. This query works and gives the total cost for each department. SELECT [Department], SUM([Quanty]*[Cost])...
  8. Zoon

    Calculate a number field?

    Thanks for responding Paul. I need 2 fields, Order is an existing number field, and I want to add a new number field named Quantity. I want to divide the number in Order by the number in Quantity. The number in Order will change. I want to add the new field because the program makes errors on...
  9. Zoon

    Calculate a number field?

    I use a 6 year old program that uses Access 97 databases. I also have Access 97 and a beginners knowledge of how to use it. I want to add a number field (I know how) and use the number entered in this new field to calculate the number in another field (I do not know how). The fields are; Code...
  10. Zoon

    Order By 2 ways on 1 field?

    A text field named SKU has in it strings like these; 1005693, 88800245, ABC-5846703, XYZ-23710. How can I sort or Order a Select query using the first character in SKU unless the fourth character is a dash, then I want to use the fifth character to sort? The query should return this; 1005693...
  11. Zoon

    How is CD-R CD-RW recording speed determined?

    How does the computer know what recording speed to use with a CD-R or a CD-RW disc? I was setting the recording speed for a CD-R when I was told that the software knows the correct speed for any disc. Do I set the speed or is speed selection automatic?
  12. Zoon

    tek-tips problem getting e-mail to me

    When I log on to Tek-Tips I see this message &quot;We've recently had a problem getting your e-mail to you&quot;. I click to indicate the e-mail address is OK, because it is OK. What could be causing this problem? Is upper case and lower case important in an e-mail address?
  13. Zoon

    Jet 3.5 SQL and tables

    I am using a commercial database program that was made using Access 97 and runs on Jet 3.5. I do not use Access to run this program. Each table is in a file like HISTORY.MDB or CUSTOMER.MDB. The program updates the required tables when entering data in a form for data entry. There are about 20...
  14. Zoon

    How can I copy a column sum to another database?

    I have 2 databases, customer.mdb has fields ID and NUMBER, sales.mdb has ID, CODE and AMOUNT. Customer has 2000 records and sales has 20000 records. ID and CODE are text fields, NUMBER and AMOUNT are number fields. Customer.mdb has data in ID and there are no duplicates of ID it is a key...
  15. Zoon

    How to copy a record from another table in another folder?

    Thanks for the help. I couldn't try this because the only way to query this database is with the built in reports or in a box that you type in SQL, no File, Get External Data, Link. Using your example, and just SQL, would I include a path like - Insert Into C:\Poduct[Transactions] Select...
See more

Part and Inventory Search

Back
Top