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 Chriss Miller 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: *

  • Users: Zoon
  • Order by date
  1. Zoon

    SQL for subtotals & grand total?

    ...are 50 different departments in the Department field & 10,000 records. SELECT [Department], COUNT([Department]) AS [SKU Count], SUM([Quantity]*[Cost]) AS [Department Cost] FROM [Products] GROUP BY [Department] The question is, how can I get the total cost of every item in every department...
  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?

    ...are 30 different departments and 9000 records. This query works and gives the total cost for each department. SELECT [Department], SUM([Quanty]*[Cost]) AS [Total Cost] FROM [Product] GROUP BY [Department] Adding this to SELECT does not work. SUM(Total Cost) AS [Grand Total]. How can I get...
  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?

    ...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 [Transactions].* from C:\Backup[Transactions]
  16. Zoon

    close dial-up connection after using IE in WinXP

    Thanks for the help. I did what you advised but I still have to manually close the dial-up connection. It seems like nothing changed. I restarted Windows XP and IE 2 times to see if that was necessary. I am sending this from &quot;Your Reply&quot; I hope this works.
  17. Zoon

    Copy a folder to a CDR by one click?

    I have Windows XP and I want to copy a folder from the C drive to the F drive, a CDR, just by clicking a icon or button. I tried Xcopy in a batch file but it did not work. I do not know VB. This is so that a regular computer user can easily make a backup each day. How would I go about doing this?
  18. Zoon

    close dial-up connection after using IE in WinXP

    I recently changed my ISP, before when I closed IE the dial-up connection would be automatically disconnected. With the new ISP I have to do several steps to disconnect. How can I automatically close the dial-up after closing IE?
  19. Zoon

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

    I have a commercial database that uses a jet engine. I make a backup of this database in another folder on the same computer. How can I copy a record from the backup database into the working database using SQL?
  20. Zoon

    Word Pad Open all files?

    Thanks for the help. I am new to forums and did not look at FAQs. I did a search and that is how I found this forum.

Part and Inventory Search

Back
Top