Go Back   Access World Forums > Apps and Windows > Excel

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 06-17-2019, 02:35 PM   #1
DanG
Newly Registered User
 
DanG's Avatar
 
Join Date: Nov 2004
Posts: 477
Thanks: 1
Thanked 1 Time in 1 Post
DanG is an unknown quantity at this point
Tables: structured references

So I'm trying to understand working with tables by using structured references and need a push.

How would you write the formula below using only structured reference? The table name is "Activity" and the "L" column is "GA#" and the "N" column is "FlowingClients".

Code:
=IF(SUMPRODUCT(($L$2:$L2=L2)*($N$2:$N2=N2))>1,0,1)*N2
It comes down to being able to use absolute and relative references, which I'm having a hard time grasping related to tables.

Any help would be appreciated

__________________
You just pick up a chord, go twang, and you're got music
~ Sid Vicious

I use A03
DanG is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Structured data Rupa Queries 1 01-30-2011 09:04 AM
Question How to convert one mdb to another differently structured mdb GrandiJoos General 9 06-24-2009 06:37 AM
Question Name chnage of tables, queries and autom. corresponding change of references to those panchitocarioca General 3 09-14-2008 04:23 AM
need to see structured organization with query raydan Queries 2 11-14-2005 05:42 PM
lookup tables references maxmangion Tables 2 04-12-2004 10:35 PM




All times are GMT -8. The time now is 01:03 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World