Get minimum from table
I have a table TempInventory with 2 fields Id, Inventory. I would like
to grab all distinct Id's and the minmum inventory for thse Id's. What
is the sql query to get such data. The data looks something like this:
28388 ...Insert Values Into A Table Using A Module
Hi, PLEASE HELP WITH THIS PROBLEM, IM STUCK! :confused:
Ill explain the problem quickly with an example.
Ive got this table:
January1999 February1999 Etc...
day 1 value value
day 2 value value
day 3 value value
day 4 value value
day 5 value value
Etc... value value
The table is very very large and inputing values in it by scrollon
through it is very irritating, so i want to design a little module tha
would allow me to either (1) input, or (2) call a value in a given x,
point of the table.
The 1st problem r...Shortcut to convert all formulas to absolute references?
I thought I read that this is possible. Am I wrong
Kevlar's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=723
View this thread: http://www.excelforum.com/showthread.php?threadid=26940
contains "a gaggle" of such converters, courtesy of Gord Dibben.
AlfD's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=478
View this thread: http:...Is it possible to synchronize data from an SQL table to an Exchange Server
Is it possible to have a replication or synchronization between contact info
stored in an SQL db's table and the Contacts or Public folders of an
Sure - programmatically, it can be done. Check out MSDN for more info.
Comsphere - "Where Knowledge Transfer is Key"
"D Gauthier" <email@example.com> wrote in message
> Is it possible to have...Help with altering a formula
I am using the following formula as part of my data source for a chart and it
works perfectly. It sums column D, rows 2 through 20K where the value in
column A, rows 2 through 20K = cell G2 and where the value in column E, rows
2 through 20K = 1. The SUBTOTAL allows for any filtering on my source tab
(AAT_Raw_Data) to dynamically get factored in.
...Re: Using A Macro/VBA code to re-set formulas
when you recommended using :
Application.ScreenUpdating = False
Range("C14").Formula = "=SUM(A14:B14)" ' <<< Change the Formula here
Application.ScreenUpdating = True
when I tried putting in my formula i.e.
It displayed an error message due to the " " in the middle of m
Is there syntax to avoid this
Message posted from http://w...change the code to be a formula
i have the following code added to the s/s tab which does what i want but is
there a way of adding this to cell like a formula thing like vlookup??
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Target.Column = 2 Then
If Target.Value = "" Then Exit Sub
Application.EnableEvents = False
Target.Value = Worksheets("Station").Range("A1") _
.Match(Target.Value, Worksheets("Station").Range("StationList"), 0), 0)
I have to make a pivot chart, but i want to set fixed fill color for every
series (and them to stay tha same when i and or filter some data in the
Tel. (54-11) 4792-8757
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:
XL2000: Changing a PivotChart Removes Series Formatting
ht...Copying only subtotals
In doing Data>Subtotals and then clicking on the 2 to show only subtotals,
how do I copy and paste only those subtotals into another spreadsheet without
it pasting in all the data in between? Thank you. Connie
Sorry....I found my own answer here:
"Connie Martin" wrote:
> In doing Data>Subtotals and then clicking on the 2 to show only subtotals,
> how do I copy and paste only those subtotals into another spreadsheet without
> it pasting in all the data in between?...From temporary table to master table and then join this in junction table
I have imported two spreadsheets from excel to two temporary tables
called "import_tbl_contract" and "import_tbl_products". I do this on
daily basis and import many spreadsheets.
I end up with these data:
I now append these data to the following two tables:
1; Syringes and needles; 01-01-2010; 31-12-2010
...Forward results in 2 copies
One user here forwards e-mail and all recipents receive
I am preparing an exam marksheet.
In one cell, I add in this formula to check if the students pass the whole
The condition to pass is that the student must not get any "E" in any
Now, I want to change the condition of passing.
The students must not get any "C", or &q...Can I copy or clone a Price SCHEDULE?
Isn't there a way to quickly & easily clone an entire price schedule? My
wife tells me that this can't be done in GP (we're still on v 7.0).
When I want to do custom pricing for a new customer, she first creates a new
price schedule, then goes thru the time consuming process of adding each
inventory item to the new schedule one at a time and configure all the price
levels (quantity discounts) for each item manually.
Isn't there an easier way?
I would think you should be able to have a "Master" price schedule called...
say... "Distributor List" ...Copy/Move Between Folders Changes Sender and Date Info
I'm using Outlook 2002 and Exchange 2000. When I move a message from
a public folder to another subfolder (also public), it changes the
"From" to my account instead of the original sender, and the "Sent"
and "Received" dates from the original sent dates to the time that I
moved the items.
I know it must be an easy fix, but I just can't seem to find the
Any help greatly appreciated.
...formula help #32
I am using a formula =COUNTIF('CONTROL GROUP 3'!H6:H313,"no info")
and I need to include other criteria in addition to "no info" such a
"12th", "11th", etc. The formula works fine the way it is with n
errors but I need to include the other criteria but when I add th
other criteria I get an error message that the formula is no longe
valid the way I have typed it. Can someone show me how to add the othe
criteria and still make the statement (formula) valid?
------------------------------------------------------------------...Formula for getting values in File-Properties-Custom
Is there a formula for retrieving values stored in the variables in
...Copy cell of one sheet to another sheet
I need a macro that will copy Cell C3 from one sheet and add it to another
sheet starting at A5. If A5 already has something in it then use A6
Dim lr As Long, sh As Worksheet, sh2 As Worksheet
Set sh = Sheets("Sheet1")
Set sh2 = Sheets("Sheet2")
lr = sh2.Cells(Rows.Count, 1).End(xlUp).Row
sh.Range("C3").Copy sh2.Range("A" & lr+1)
Change the sheet names to suit.
"Bobbo" <Bobbo@discussions.microsoft.com> wrote in message
&g...Delete table values automatically
I want to create a routine that will clean all records from a specific table
automatically once a week (if possible) or each time that the MDB opens up.
Thanks a lot in advance
the code to empty a table is simple
Public Sub EmptyTable()
Dim strSQL as String
Dim db as DAO.Database
Set db = dbengine(0)(0)
strSQL = "DELETE FROM TableName"
db.Execute strSQL, dbFailOnError
Set db = Nothing
the above code goes in a standard module
when your database opens, you call the routine EmptyTable
"Lp12" <Lp12@discussion...AdventureWorks: can I query table w/o using table_schema name
I tried to query the Contacts (Person.Contacts) table in the AdventureWorks
DB, but it wouldn't let me unless I included Person. in front of the table
select * from Person.Contact
If I query the same table from a VS(2008) project using LinQ To Sql, this
appears to forgo the table_schema name. Is there a way to forgo the
table_schema name in QA?
I don't know what "magic" LINQ is doing, but at the TSQL level: If you don't
specify a schema, then SQL Server will look at the default schema for your
user. So, make sure your user has t...Excel copy/paste questions
Greetings. In Excel 2002 SP3 I have a large sheet of data I use as a
timetable. As time passes I remove the data from the first line and shift
the rest of the data upwards. For example: Data in rows 1-4, delete data in
row 1, copy/paste data from 2-4 to 1-3 (been using "Valus Only" to preserve
conditional formatting in row 1), delete row 4. Is there any way to do this
while 1) maintaining the conditional formatting in row 1 (time-based
highlighting) and 2) maintaining the font formatting from rows 2-4 as they
move to 1-3 (red X's and green check marks)? If an e...Problem with draging a formula,one cell value fixed,trivial question
I have a value in cell A10. Then i have a formula in cell C1 which
goes: (A1+B1)/A10. If I drag the formula down to cell C5 the formula
for C2 will be (A2+B2)/A11,
for C3 will be (A3+B3)/A12,....,for C5 will be (A5+B)/A14.
I would like the formula to have the A10 parameter fixed so when i drag
the formula down the A10 would always be A10(it wouldn't go up by 1).
So the formula for C2 will be (A2+B2)/A10,
for C3 will be (A3+B3)/A10,....,for C5 will be (A5+B5)/A10. Please
make your original in C1 formula
then drag down.
See help on absolute versus re...How do I unhide the subtotals in a pivot?
I hid the subtotals for a field in an Excel pivot table.
I am discovering that there is no unhide option.
How do I bring back the subtotals?
I do not want to regenerate the pivot, I am afraid to mess up the
formatting in the chart working off this pivot.
Never mind. Got my own answer.
On Jun 25, 6:59 pm, Kompu Kid <deg...@hotmail.com> wrote:
> Hello All:
> I hid the subtotals for a field in an Excel pivot table.
> I am discovering that there is no unhide option.
> How do I bring back the subtotals?
> I do not want to...Copy worksheet ---> worksheet
I have 3 Worksheets in 1 Workbook....
the worksheets are known as...:
each worksheet has at least 2 columns that will have the sam
information as the others..for example:
Manifest has 1 column (A) named Receipt Number, Deliveries and Stuffin
also have 1 column that has this column as well.
My question is, what formula do I need to apply so that when
introduce the Receipt Number in Manifest's Receipt Number column i
will automatically be introduced in Deliveries and Stuffing's Receip
Number Column? That way I dont have to be intro...Clear data from pivot table
Usually when building a pivot table report I throw the data sets in
the pivot table a few times to find the best way to show data.
So I wonder - is there a way to quickly erase all the data sets so the
pivot table is again empty as just being created (so I do not have to
select each data set and remove it?
Macro or some other trick?
The closest I got to the answer was the idea to just create another
pivot table from the original data=85but it would be so much easier to
click a button and all the data is cleared from the pivot table.
Thank you as always people!
In Excel 2007 ther...Pivot Tables #38
Can I have two pivot charts linked? if I have two pivot tables (same data
source) can I filter on one table and have the other automatically filter to
the same criteria?
There's a sample file here that changes the page field in all pivot
tables, when the master pivot table is changed:
Under Pivot Tables, look for 'Change Page Field'
> Can I have two pivot charts linked? if I have two pivot tables (same data
> source) can I filter on one table and have the other automatically filter to