I want year in one table to be less or equal year in another table
I have some problems writing a query and I hope someone can help me.
I have a database with serveal tables. In one table I have this information,
Lake ID-number, treatment, year for treatment. In another table I have Lake
ID-number, fish species (I am intrested in pike), year when pike is present.
I want to find all lakes that have pike present before the treatment was
done, I want the year in the second table to me less or equal the year in the
first table. Is there a easy way to do this?
Try something like this substituting your table and field names.
S...Hyperlink via indirect cell reference
I have workbook that contains a number of sheets. On a separate sheet I
would like to be able to insert a hyperlink so that I can jump to a specific
However, rather than inserting all of the hyperlinks manually (I will have
to replicate this over many workbooks) I wondered if there was a formula to
allow me to jump to a cell (say A1) in another worksheet, based on the name
of that worksheet being entered in a cell reference.
For example - a number of worksheets called "Sheet1", "Sheet2", "Sheet3",
In another sh...Money: Err Msg: Path Has Not Been Properly Set Up
Microsoft Money. The path is not properly set up in the registry or has been
moved after running Money's Setup. Please re-install Money. Otherwise, Money
may not be able to run properly.
re-instal wont help
deleting registry entry dasn.t help.
windowx xp sp2 Ms Money 97 (v.5.0)
Are you using an administrator account to run the software?
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://registe...Money 2005 #50
Trying to restore my date from old xp computer to new vista computer. Loaded
program ok, set the path to new location, am logged on with admin rights,
when i try o restore says cannot open file. Have not had this on other
computers? Need ideas? Thx
how did you transfer your *.mny file? If you used a CD or DVD your file
becomes read only. You have to manually go into to Windows Explorer and
change it back to read/write.
"meg85" <email@example.com> wrote in message
> Trying to re...How do I freeze or lock cells to show up on each page without typ.
I have a 4 page sheet. I have a header already. But I want to freeze the
cells that head up the first page. I've done it before in school but can't
remember what it is called or how to do it...that's why I'm doing this.
Anyway, I want these cells to print off on each new page without having to
type them on each page. I hope that makes sense and I hope that someone can
If you mean for printing do file>page setup>sheet and select rows to repeat
otherwise for viewing you can select a2 if the headers start in row 1 and do
window> freeze panes
...Money Central Portfolio #2
My print function has gotten corupted. When I print it flips to WORD / format
and prints in a format that is 4x normal.
How can I rename column A to read "bills" instead of the letter A?
You can't. The closest you will get is to hide column headings, via Excel
Option, and then create your own.
"shoe" <firstname.lastname@example.org> wrote in message
> How can I rename column A to read "bills" instead of the letter A?
you cant change the headers or row labels but you can define you data as a
list (or table) and the headings can then be used to refer...merging 2 cells without losing data?
How can I merge 2 cells without losing data from the other cell?
Not possible I'm afraid. Try placing the dat from both cells into one
and use "Center across selection" under Format>Cells>Alignment
Merge cells always end up causing grief. they are best avoided.
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
"bob" <email@example.com> wrote in message
> How can I merge 2 cells without losing data from the other...Create static text from cell reference
I have two columns of text which I'm combining in a third column using the
formula (for C1, for example) =A1 & char(10) & B1
This gives me the contents of A1 on a line above the contents of B1 and
What I NEED to do is somehow create column C as TEXT, not as a REFERENCED
data from columns A and B. How do I create a cell that contains the actual
TEXT content of another cell instead of a REFERENCE to the other cell?
Select all the cells in "C" that have content. R-click them and select
"Copy" then r-click again, sele...Problems Converting Data from Quicken 2001 Deluxe to MS Money
I have a relatively new Compaq Desktop (2.5 GHz Celeron with 512 MB RAM).
I have a Viewsonic Pocket PC and I wanted to use it to track my financial
data so I purchased Money 2003 Standard.
I tried several times to convert my Qucken Data (it's a big file--I've
been using Quicken since 1995). My Quicken program is Quicken 2001
Anyway, the MS Money program started to convert and after a few minutes
"Your Quicken file could not be converted. Money could not convert your
Quicken file. You might have run out of disk space or system memory. Try
closing othe...Cell Format #4
Is there a way to have a cell format based on contents of an i
if(C1="Input",and(C3,Format $#.##),if(C1="% of Revenue",and(C5,Forma
I want the If statement to test a condition, return contents of th
correct cell and format automatically.
Any help is appreciated
bforster1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1177
View this thread: http://www.excelforum.com/showthread.php?threadid=26133
You can't change the fo...Getting contents of adjacent cells
I want to divide the y1-axis column and save it to radius (y1/2) column. How
do I do that?
x-axis y1-axis radius(y1/2)
0 0.00 8.0000
1 0.25 8.0242
2 0.50 8.0691
3 0.75 8.1281
4 1.00 8.1989
5 1.25 8.2803
6 1.50 8.3716
7 1.75 8.4729
8 2.00 8.5832
divide the y1-axis by what?
2 as an guess with y1-axis in column c
in the y1/2 column(d?), enter
> I want to divide the y1-axis column and save it to radius (y1/2) column. How
> do I do that?
> x-axis y1-axis radius(y1/2)
> 0 ...cell selection gone crazy on Excel 2003
All of a sudden the mouse is acting like it is held down, and will not stop
selecting cells. Have tried double clicking, playing with the Function keys,
all sorts of things, but to no avail... don't want to force quit.
Any clues? TIA, Geri
See David McRitchie's notes at:
"Tweedie-Vaughan" <Tweedie-Vaughan@discussions.microsoft.com> wrote in
> All of a sudden the mouse is acting like it is held down, a...Average of logic cells
I used a logic test to determine some levels from raw scores. For EG
>120 =5, 119-110 = 4, etc. I now want to dtermine an average score of
several of the the results from the logic tests but it doesnt seem to
work. (AVG does not recognise cells with logic tests) Can anyone help,
ckdkvk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29245
View this thread: http://www.excelforum.com/showthread.php?threadid=489704
hi, ckdkvk !
> I used a logic test to determine so...Formatting Linked Cells
I have a project to do. I have to create an input worksheet that is the originator of other worksheets that are linked to the input worksheet. Is there a way to have the linked cells shown as a blank cell if the data (especially text data) is not enter in the input worksheet yet.
(Don't use my reply address - it's spam-trap)
"MT" <MT@discussions.microsoft.com> wrote in message
> I have a project to do. I have to create an input ...Run series of query -- I don't want any pop-up
I have generated 4 queries (1. empty all, 2. import data, 3. generate
information, 4. Make a new table)
I've created a button to run these 4 quries sequencially.
MS ACCESS pops up "confirmation dialog" to ask me whether to delete/modify
I don't want any question to be asked. I just want those queries to be
executed once i press my button.
I have a 12 month rolling report with a seperate worksheet within th
workbook which refers to the column containing current month's Numbers
When I "Cut" Column C (which contains the oldest Month) and "insert
column C between N & O it shifts my cells left and all I need to do i
input all of the current Month Data into Column N. The formulas al
remain intact and everything is peachy. Until I goto the Workshee
that refers to the Current Month on the 12 month rolling report.
My problem is that when I shift the columns on the "Report" workshee
it chages the cell...Use a VBA Macro inside an Excel Cell
This is a multi-part message in MIME format.
its been helpful to me so maybe it will do good for you too:
how to create a simple macro within Microsoft Excel, and then how to use =
that macro to calculate a single cell value.
&l...Changing named range reference depending on a cell's content
Where to start?!
I've got the following formula pulling data in from a secon
spreadsheet within the same workbook:
We have 8 different locations ("MICH" being one of them) that we nee
to be able to access. I can write a nested IF formula that looks a
cell I7 (that contains a list of all 8 locations) and, depending o
I7's content, brings back the desired values.
I was hoping someone in the forum could help me write a simpler formul
that would not have 7 IF statements embedded in it.
Any help w...Color change in cell when > 49.99
I need a cell to change color if the value inside the cell reaches 50 or
higher.either text or cell shade. just so it catches the users attention.
im running excel 2000. and i have this currently in the cell that i want to
aplly this to:
have you tried conditional formating?
>I need a cell to change color if the value inside the
cell reaches 50 or
>higher.either text or cell shade. just so it catches the
>im running excel 2000. and i ...I have individual place cards I want to print can anyone advise m
I am helping friends print their wedding place cards, they have been given
the individual cards from the place where they are having the wedding, but we
cannot get them to line up
What are the size of the place cards? Are there more than one card on the page? Are
you merging information? What version Publisher are you using?
Mary Sauer MSFT MVP
"Pauline" <Pauline@discussions.microsoft.com> wrote in message
>I am helping friend...Cursor on new message window but no text appears when typed?
When using Outlook 2003 for sending new e-mail, I'm unable to type text into
the message body. The cursor appears but no text shows. Text appears when I
use Word 2003 to send my new e-mail message. It is more convenient for me to
...How did I break the cell display limit? #2
If there is anyone out there who can help with this, I would be most
most grateful. Here's the facts:
- I'm working in a MS Excel worksheet.
- I am aware of Excel's 255-character-per-cell display limit. (As
understand it, each cell can hold up to 32,000 characters, but wil
only display/print 255 characters.) This is a major pain in th
petunski, as most of my cells contain more than 255 characters
Therefore, most of my spreadsheet shows cells that look like this
###############. I have to look in the formula bar to see the actua
contents of each cell.
- In cell C35, I have 1,05...Your thoughts on Money 2005?
After reading through the posts today, here are some of my thoughts on Money
2005 and how to resolve some of the issues.
#1 MS should offer a 15 year anniversary edition of MS Money 98 that works
#2 Undo all the extras. Give us a Basic Edition product that allows us to
balance the checkbook, manually download our QIF/OFX files, do a budget and
add a calendar to remind us of bills...that's it. Remove the bloat that
really makes MS 2005 slower and buggy.
#3 Allow a feature that will let us revert back to a former version. Sure,
you tell us to backup our previous data, bu...Cell Jumping
Can anyone tell me why a networked Excel 97 would jump a number of rows
down automatically when a .xls file is opened? :)
OZROB's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26617
View this thread: http://www.excelforum.com/showthread.php?threadid=398904
One reason is that you could have a macro that runs when the workbook opens. It
could be trying to help.
> Can anyone tell me why a networked Excel 97 would jump a number of rows
> down automaticall...