Tlou5831
Last Activity: Mar 12 '08, 05:21 PM
Joined: Feb 13 '08
Location:
-
I receive the Enter Parameter value for the TBLRoleSettings table... -
Unmatched query multiple criteria
I am attempting to compare 2 tables in my DB and find unmatched criteria.
There are 2 different fields in each database that need to be compared.
Tbl_AppUsers
Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY
Tbl_RoleSetting s
Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY
I would like to... -
Unmatched query multiple criteria
I am attempting to compare 2 tables in my DB and find unmatched criteria.
There are 2 different fields in each database that need to be compared.
Tbl_AppUsers
Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY
Tbl_RoleSetting s
Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY... -
It must have been way too early when i posted the above.
I basically am looking for my new table to look like this.
ID UserName Role SumRoleNumber
Jsmith JohnSmith INQ 28
Jsmitty JohnSmith Invest 28
JDoe John Doe INQ 29...Leave a comment:
-
Thanks the code worked great!
If I wanted to make this a Maker table query where the Sum would output to a field called "SumRoleNum b" so I can keep as few tables as possible.
I attempted to do this but when I entered the other fields of my table the sums did not work. (This might be due to the multiple instances of the same user name.)
Is it possible to show only 12 instance of each user and...Leave a comment:
-
The Table that I need to Query on is call TBL_AppUsers and in that table are fields called:
User Name, Role and RoleNumber
Basically, if the User name is the same I want to get the sum of all of the RoleNumber fields.
So if:
John Smith INQ 1
John Smith INVEST 27
The output into another Field will be 28 for John Smith.
...Leave a comment:
-
SQL Query
Hello All,
I pretty new to access and kinda stumbling my way through making a database
I made a SQL query to assign a numerical values to each role.
For example:
TNS role - WOPS = 28
App Role - INQ = 1
App Role - Invest = 27
If you add up both of the app roles it will equal 28. The issue that I am having is making the SQL expression to look at the User Name (constant)... -
SL Sum question
Hello All,
I pretty new to access and kinda stumbling my way through making a database
I made a SQL query to assign a numerical values to each role.
For example:
TNS role - WOPS = 28
App Role - INQ = 1
App Role - Invest = 27
If you add up both of the app roles it will equal 28. The issue that I am having is making the SQL expression to look at the User Name (constant)...
No activity results to display
Leave a comment: