...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...
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...
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?
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.
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?
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.
...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...
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...
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...
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...
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?
When I log on to Tek-Tips I see this message "We've recently had a problem getting your e-mail to you". 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?
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...
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...
...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]
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 "Your Reply" I hope this works.
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?
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?
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.