Query not displaying correct column from a field
I have a table called Location with 2 columns,
Abbr | Location
VIL | Village
I have a field on a form that is bound to the 2nd column of the table.
I created a query based upon the form and have the location field in
the query, when i run the query it displays the 1st column of the
table. I need it to display the 2nd column.
Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"firstname.lastname@example.org&quo...How to expand a collapsed column on excel worksheet?
I have two columns that I cant see (H and I). I want to see the value in
them. How do I bring them back?
Click on G (cell header) and drag to J so that both columns are highlighted.
Right click / Unhide.
If my comments have helped please hit Yes.
> I have two columns that I cant see (H and I). I want to see the value in
> them. How do I bring them back?
How do I select noncontiguous columns?
Select the first column/range
ctrl-click on the subsequent columns/ranges.
> How do I select noncontiguous columns?
CTRL + Click
Gord Dibben MS Excel MVP
On Tue, 2 Feb 2010 14:20:01 -0800, Barnsie
>How do I select noncontiguous columns?
Hold down the CTRL key when you select
> How do I select noncontiguous columns?
...Powerpoint font size
In ppt 2007, is it possible for the font size to automatically reduce when
more info is being typed. I had this feature previously but somehow have
"BK" <BK@discussions.microsoft.com> wrote in message
> In ppt 2007, is it possible for the font size to automatically reduce when
> more info is being typed. I had this feature previously but somehow have
> lost it.
Office button -> PowerPoint Options -> Proofing -> AutoCorrect Options ->
AutoFormat As You Type tab -...Re: Two Outlook 2007 issues..
Forgot to mention, help about shows 12.0.6514.5000 sp2 mso 12.0.6529.5000
"Anonymous User" <email@example.com> wrote in message news:...
> Issue 1 : Dismissing a reminder will not permanentely dismiss it. It will
> go away then, but come back later.
> Issue 2 : When sorting the inbox on something other than received date,
> the ability to delete messages is impacted. You can try to delete a
> message, and sometimes it will delete, but many times it will act as if it
> did delete it, but the message is still present...making a column with working hyperlinks?
I was wondering if there is a setting to make it so the hyperlinks in a
column would be real hyperlinks and not just text?
I looked at formatting and did not see anything there.
Ctrl + K will bring up the Insert Hyperlink dialog box. You can navigate
there by going to the Insert (menu) | Hyperlink. Or you can make use of the
HYPERLINK function. An example would look like this ..
Zack Barresse, aka firefytr
"Robert Anderson" <nospam@nospamn...Printing A2 size using A4 paper size
I have created a timetable in a worksheet (Page Setup A4, Landscape)..
I wish to blow it up to A2 size (which is equivalent to four A4 shee
As my printer (HP deskjet 5550) restrictions only permit upto A4 siz
printing, how may I setup the worksheet to be printed onto four A
sheets so it merge into an A2 size sheet
Message posted from http://www.ExcelForum.com
...No NDR's when exceeding mail size limit
I have problem with NDR's (I'm not receiving them!)
We configured Exchange 2003 so that the mail size limit is 5120kb and that a
copy of the NDR is sent to another mailadres. When the mail size is exceeded
the mail ends up in the badmail directory but the users or the mailadres to
which a copy should be send are not getting a NDR. Does anyone have an idea.
Take a look at:
On Tue, 22 Feb 2005 06:03:09 -0800, BSG Helpdesk
>I have problem with NDR's (...Dialog window size
Is there a way to change the size of dialog window without editing in
text editior, the resource file ?
i don't want too, to increase size with mouse using handle.
something like property editor could be very interesting.
"Maileen" <firstname.lastname@example.org> wrote in message
> Is there a way to change the size of dialog window without editing in
> text editior, the resource file ?
> i don't want too, to increase size with mouse using handle.
> something like property editor could...Booklet Size
Is 24 pages maximum size for a booklet or can this be reset. I had a
slightly larger booklet and had to split it.
You can have as many pages as you need. Are you getting an error? Do you have
lots of illustrations? It could be a memory limitation.
Mary Sauer MSFT MVP
"shawnews" <email@example.com> wrote in message
> Is 24 pages maximum size for a booklet or can this be reset. I had a slightly
> larger booklet and had to split it.
...displaying data within column
hi there i'm having alot of trouble trying to display data within
here is a screenshot of what i am doing:
the x axis is phase so each column in the graph are phases. the y axi
is time - how long each phase lasts.
but within each of the phases (columns) i would like to display data
the final data column in the spreadsheet - "% of cost in phase". so th
phase (column) is broken down into its deliverables (the 2nd data colum
in spreadsheet) accordi...Sumproduct where cell values are the same in a sorted column
In cell C2 I have the following formula that works fine for what I need it
In the cells in column J i have a list of numbers that are the same in the
following different ranges as follows
J2:J23 = 123456
J24:J30 = 123457
J31 = 123458
J32:J33 = 123459
I copy the formula in cell C2 down the column and then I have to manually
change the range in the formula to match the ranges of other columns. So the
following cells will have the following formulas in. The rest of the cells in
the range are ...Reducing file size #2
I have a worksheet/file that is 20mb because it contains a lot of links,
formulas, and apparently some embedded coding. I think the coding is there
because the file uses Hyperion Essbase to retrieve data from a financial
In order to reduce the file size, I highlight the entire sheet, select copy,
then paste values into a new worksheet in a new file. This leaves me with
approximately 8,000 rows and 20 columns of data. The size of the new file is
I would expect the new file size to be much less than 12mb. Is there a way
to further reduce the file size, or am I ...RE: Outlook 2000 .pst file over 2GB
My Outlook 2000 crashed because my .pst file is 1.96 GB.
According to MS knowledge base article 296088, I truncated
some 25MB, it worked but I lost some very important email
Is there any way or any data recovery tools I could use to
recover all my original 1.96 GB .pst file.
Thank you very much for the HELP!!!
No, but what you can do is open the pst-file in a HEX editor and delete a
porting of the file, save it (under a different name) and then repair it
with scanpst.exe. Once you've recovered that you can do it again by deleting
another portion of the file and...Outlook Express: Re Inbox
I am unable to delete e-mail messages from the inbox. I
highlight the e-mail message, click delete, does not
delete. When I double click the e-mail message then click
delete, a message box reads, "This message can not be
deleted." However,I can delete sent e-mail messages. I
can 'Blocksender' the e-mail message adding it to the
Block Sender List but will not remove the message from the
I have up-dated Outlook Express and Windows.
Still unable to delete the e-mail messages in the inbox.
Colleen Wiens <firstname.lastname@example.org> wrote:
> I am unable to del...Move rows into columns
I have an Excel sheet that has 8000+ rows that include contact information.
I'd like to move them from all of those rows into 6 columns. Currently it
And I'd like to create a formula to move it to 6 columns that look like this:
name title company address city/state/zip phone
I'm still an Excel novice but would appreciate any suggestions you might
You will need VBA code to get this done. If you would like I could whip up a
code for you if yo...Re: proverka
"alex vashurin" <email@example.com> wrote in message news:...
> zxgchjch proverka
"alex vashurin" <firstname.lastname@example.org> kirjoitti
> "alex vashurin" <email@example.com> wrote in message news:...
>> zxgchjch proverka
...Excell: Column Changes
The Excell program changed the Column labels from alpha characters to numbers. This makes it somewhat difficult to use formulas. Any ideas on how to changes back the numbers to alphabet characters ???
Tools|options|General Tab|Uncheck R1C1 reference style
> The Excell program changed the Column labels from alpha characters to numbers. This makes it somewhat difficult to use formulas. Any ideas on how to changes back the numbers to alphabet characters ???
Tools -- Options. On the View tab, under Settings, uncheck R1C1 style.
And...Default column width opeing *.csv in Excel
How do you set default column width when opening a *.csv in Excel?
Changing files in \XlStart directory did not help.
As it is a csv you will only be able to do this in code. If it is the same
file layout each time, why not record a macro in your personal.xls file and
run this each time
Microsoft MVP - Excel
"Netnathan" <firstname.lastname@example.org> wrote in message
> How do you set default column width when opening a...Adding columns to "Look Up Records" window #2
In certain places in CRM (specifically highlight a Lead, click New Email, and
press the looking glass lookup button to the right of the To field) when I do
a Lookup for contacts or accounts, the window "Look Up Records" appears with
a list of entities at the top, a search field, and two lists below. The left
list is available records and the right is selected records.
The Available Records list only displays a single column, the name of the
account or contact. I want to display more columns, and scollbars are OK.
My specific issue is that I have 4 "Rick Johnson" c...Re: jeremiah
"owner" <email@example.com> wrote in message news:...
> hey my new movie will becoming at jluy 13 2008
> so we are letting let you know that you can join us by
> my texsing www.tylerperryjogebrown.com
> in you can e-mail if you what to join me
...How do I change the width of a column?
I am using Access 2007. I have a database with over 30,000 records. Is there
any way to change the width of a column where that it will accept more than
62 characters? I can change the width of the field, but not the number of
characters accepted. Any help would be appreciated. Thanks.
On Sun, 22 Apr 2007 16:51:59 -0400, "Terry Watson" <firstname.lastname@example.org> wrote:
>I am using Access 2007. I have a database with over 30,000 records. Is there
>any way to change the width of a column where that it will accept more than
>62 characters? I can change the width of the fi...How to align new text in columns with existing text
I have text where I need to put the translation in a second column to line up
with this text. How do I create blank new column without the existing text
jumping in it?
A two-column table would work better than using the "newspaper" or "snaking"
If you already have snaking columns, you can easily convert the text to a
Turn off Columns and remove any Continuous section breaks you may have.
Select the text, Table, Convert, Text to Table, check the Tabs at the bottom
of this dialog, change the number of columns to 2, OK. You should now have a
...RE: Row to a Column
I have a group of rows and want to transpose them to a columns.
say I have column of address
zip) and each address is saperated by blank rows.
I want to transpose each address into a column. Is there a way to do this in
wilde wood ave
Little rock rd
Result after transpose
wilde wood ave Lake land FL 90010
Little rock rd San diago CA 92345
any help appricated.
Select the 4 cells in the column. Copy (control c). Select 4 cells in a
row. Ed...RE: Check that critical package from the MS Corp.
Content-Type: multipart/related; boundary="vkmrndrkhckopwqt";
Content-Type: multipart/alternative; boundary="hbvvvkpkl"
this is the latest version of security update, the
"November 2003, Cumulative Patch" update which eliminates
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to ...