Table relationships and lookups
Hi guys, I may be a little over my head, I've had some experience in
creating simple access db's. however this one will be extremely
complicated as far as I can tell. Some backround info - i've got an
excel spreadsheet currently that i would like to convert to Access.
The spreadsheet does multiple lookups and calucations.
This is for a Soccer club that i run to maintain roster information,
dollars, scheduling and stats. I'm currently working on the
scheduling pience. Here's what I have so far.
Club - Lists the teams in the club, home field name and ...Inventory by location list question?
I have an excel spreadsheet inventory list.
Sheet-1 of the spreadsheet contains everything we would want to know
about the inventory (what it is, where the item is located, what it was
purchased for, sold for, etc).
Example of spreadsheet sheet#1 column (field) name/layout across top.
Column A = (Item#), Column B = (Category), Column C = (Description),
Column D = (DatePurchased), Column E = (Price Purchased),
Column F = (Date Sold), Column G = (Sold For),
Column H = (Location of item), Column E = (Price Purchased),
and Column F = (Date Sold).
Rows-3 thru X following (down and across), c...Question about IF function
I would like to have every cell in column A that has value of "0.00"
be changed to "NO" and every cell that is > 0.00 to have number values
changed to "YES". What would the formula be?
Thanks in advance.
Not sure why you're thinking IF() function.
If you just want to display "YES" or "NO", choose
Format/Cells/Number/Custom and enter:
excel_21 <firstname.lastname@example.org> wrote:
> I would like...Concatenation Question
I have a form in which users fill in three fields as part of the form. After
this is done I want them to be able to click a button and have the data in
those three fields combined with the primary key and this concayenated data
to be loaded into another field on the form? How would I do this? Thanks for
I can't imagine why you would do such a thing. Each data item should stand
alone. To repeat data in a table is not good design. It would be better to
concatenate them when you intent to use them for some other purpose. I
suggest you rethink your design. But, with that...Questions about building an offline Exchange 2000 recovery server
I know that there is a Microsoft paper that describes the process of
creating an offline Exchange 2000 server (trust relationship, etc..) Could
you please forward that paper to me? Any help would be greatly appreciated!
On Wed, 27 Apr 2005 15:47:04 -0700, "Greg"
>I know that there is a Microsoft paper that describes the process of
>creating an offline Exchange 2000 server (trust relationship, etc..) Could
>you please forward that ...question related to Data Vaildation
Dear all, I have two columns. Each column contains a defined value and each
value carries some predefined details. I am trying to place a dropdown
through data validation, so that i select any value, i should be getting all
the details related to that value without any extended space. Like below-:
If i select A, I want to get the details of A as dropdown, i select B, i
want to get the details of B.
Kindly help !
Refer the below by Debra Dalgleish ..(you will need to fill the blank cells
...Invoice lookup by paid check number
I frequently have vendors call me asking for information about what invoices
were paid by a check number. Is ther an easy way to look this information up?
You could go to Inquiry>Purchasing>Transactions by Document, put your check
number in the 'from' and 'to' fields. Once the document is displayed in the
scrolling window zoom back on the 'Unapplied Amount' field. Viola! the
documents paid by the selected payment are listed. Unfortunately there isn't
a print icon on this inquiry window, but I think it's the information you
&quo...Excel Report Builder #3
I'm trying to setup security for users to access and use Excel Report Builder
and followed what the user's guide directions:
1. Open the Security Task Setup window (Microsoft Dynamics GP menu >> Tools
>>Setup >> System >> Security Tasks)
2. Enter a Task ID, Task Name, Task Description and Category.
3. Select SmartList Builder as the Product and Excel Report Builder
Permissions as the Type and Series.
4. Mark the operations that you want to grant access to for the selected
user or user class.
It grants the user access and appears the capability to build and...Lookup
Q102 Q202 Q302 Q402 Q103 Q203
How can I lookup the Q103 in the row above and then have
it pull the number to the right one cell (Q203)? thanks
If I understand correctly
where q103 is in a1
and q102-q203 is in a2-f2
>Q102 Q202 Q302 Q402 Q103 Q203
>How can I lookup the Q103 in the row above and then have
>it pull the number to the right one cell (Q203)? thanks
> Q102 Q202 Q302 Q402 Q...Workflow Manager Question
Trying to create a rule that will copy the street address into a "ship
to" address field for leads.
Any idea where I might find instructions on how to do this?
Thank you if you can help.
...A Question re Protection: hiding / deleting rows
First: you folks are great!
I have workbook with a bunch of sheets. I protect the sheets, but want to
let the users hide rows that apply to their needs; I've tried unlocking the
rows, bbut once I protect the sheet, I can't hide or delete the rows. Any
ideas? Thansk! RN
which Excel version are you using. Depending on the Excel version you
can for example allow formating rows in the protection dialog
Random NumNuts wrote:
> First: you folks are great!
> I have workbook with a bunch of sheets. I protect the sheets, but
> w...Design Question #3
I have a company Acme.com, using Exch03 Enterprise.
They have a small remote subsidiary omegasales.com These users vpn in to the
main office at acme.Omegasales wants to have their email come into this Exch
server, and yet be transparent (appear to send/recieve from omegasales.com) .
Aside from the obvious -mx entry with the ISP, any suggestions for the best
approach on Exchange?
This is one AD domain and Exchange org., right? If so, all I would do for
the user who are using omegasales.com is make their primary email address
"email@example.com". also make sure y...PeekMessage Question
I have been using the following code in an MFC application and it has worked
// Check for user cancel
if ((nLoops++ % 0x1F) == 0)
// Check for escape key
if (::PeekMessage(&msg, m_hWnd, WM_KEYFIRST, WM_KEYLAST, PM_REMOVE))
if (msg.message == WM_KEYDOWN && msg.wParam == VK_ESCAPE)
m_bAbort = true;
nLoops = 0;
It is used to detect Escape within a tight loop.
I now want to use the same code, but while a modal dialog box is displayed
(the code is not part of my dialog box class but is called from t...Help with LOOKUP function
This function is in a workbook with 2 sheets. It _almost_ works
perfectly. These "C" columns in two different sheets
'2005-2006'!C:C,'2004-2005'!C:C, contain names of people. The D column
in one of the sheets - '2004-2005'!D:D - contains a date associated
with the person's name from the C column of 2004-2005 sheet.
This formula is in the "D" column of Sheet 2005-2006.
The concept is for the formula to lookup the value (person's name) in
column C of 2005-2006 a...Questions On Access 2007 Runtime...
I currently have an Access 2007 project that we use for our company’s
inventory system. A few months back, we upgraded some users to the full
version of office, and now I am attempting to setup some other users with the
2007 Runtime version and have some questions...
If the computer that the user is using already has Access 2007 Runtime
installed on it, should I still be making an MSI installer package for them
to run, or can I simply copy an ADE file to their computer...? I have
actually tried both ways but wasn’t sure which was the best practice.
When I tried putting an ADE...Reporting question 08-23-07
I'm trying to figure out how to use the report builder to pull data from my
incident base and from some of my custom fields in the incident extension
base. Has anyone had any luck doing this?
any reason for not using filteredincident view which contains all base
incident fields as well as all custom fields. In addition, user security is
honoured, dates are converted to local, pickup lists and lookups are
expanded to include verbose name. Bar the monstrosity of the view, a win-win
Hope this helps
CRM Certified Professional - Developer...A Lookup function does not work
Hi, This is my first posting.
I am using Exel 2000. I have 2 separate spreadsheets that have some
similar columns but not all of the data in the similar columns is the
What I want to do is take column A in spreadsheet#1 and find this same
value in Column B in Spreadsheet#2 and then insert into column 3 in
spreadsheet #1 a value from a different column in spreasheet #2 that
corresponds to the row in which the value was looked up in Column B in
What I am doing is comparing 2 different inventory files that have
stock codes in columns and quantities in another column, but n...return cell reference in a table based upon given lookup criteria
Is there a way to return the cell reference, or column/row coordinates,
of a cell within an array or table by providing lookup criteria?
Perhaps something like this:
For a table of value in A1:E10
F1: (the value to find)
Note: Commit that array formula by holding down the [Ctrl][Shift] keys and
That formula returns the address of the 1st cell containing the value in F1,
or #VALUE! if there is no match.
Am I on the right track here?
"Travis" ...Advanced Lookups
Is there any way to make an advanced lookup the default lookup? so you don't
have to always choose that option when doing a lookup?
Thanks for any help.
Advanced lookups ARE the default unless you've done something to make it now
so. There isn't any way to "choose" the option when doing a lookup that I
know of unless you have some type of customization (easy to do) that would
give the user an option.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tracey D" <...Easy question?
Let's supose that I have the following XML:
<?xml version="1.0" encoding="utf-8" ?>
<element2>some other value</element2>
<element2>some other value</element2>
We are a land reseller company implementing Great Plains.
We purchase a piece of land and divide it into smaller parts and resell it.
At times, after selling the smaller piece of land, it is returned back and we
need to resell it again.
My question is: How do I implement this in Great Plains.
If I consider the land we buy as an item, how do I split it into multiples.
The other issue here is that if every land purchased will be a unique item,
then our item data is going to grow very fast. Any ideas will be appreciated.
Here are a couple of ideas:
1) When you create the Inventory Item...Money Reports Question
I have Microsoft Money Deluxe OEM Edition Version 11.0 (according to
I would like to create a report which shows all my accounts with "Today's
Blance" and "Ending Balance", rather than the "Accounts Listing" which only
displays "Ending Balance".
How do I do this? If I can't, will later versions of money enable me to do
One doing the vendor lookup - one user sees the 'show details' information
upon lookup; other user sees the vendor list and needs to clik on the show
details - how do you get the show details window to be the default option you
Check for full stops/periods/dots on the window title bar before or after the
window name. It is possible to use VBA or modifier to open the details
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
Hi, I used CDockState in a CFrameWnd to temporarily store
my toolbar state & restore it later using
CFrameWnd::GetDockState() & CFrameWnd::SetDockState().
Somehow when the state is restored, one of my vertical
toolbar didn't display correctly, most of the buttons on
it are missing. I have to drag it into floating state to
make it display all the buttons. When I did this & return
it to the vertical docking position, everything is fine.
Does anybody know why it is so? Is this a bug with MFC or
maybe a problem with graphics card/driver?
There is an issue...Outlook 2000 won't start #3
My Outlook has stopped working. It was working fine, and then all of a
sudden, it will not come up. I have uninstalled and reinstalled and it still
will not work. When I click on it, I get the the box that says Microsoft
Outlook on the screen, but that is where it gets stuck and it never actually
loads. This was installed with Office, and all of the other programs that
were installed with Office work just fine. What can I do to get this to work?
On Wed, 20 Apr 2005 15:00:01 -1000, Ole Lang Signs"" <Ole Lang
> My O...