Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Bizylizard
- Order by date
-
Access and Excel
I have a table with the below info. I want to be able to query of off this table when M+P=Result but the problem is when I have another table and I have a M value of 109.92 and a P value of 190.87 I need as the result to be M is 110.00 + P 191.00 = Result of 219.00. Does that makes sense? M %...- Bizylizard
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Access and Excel
Excel has an Index function explained below is there a way to do the same function in Access? Returns a value or the reference to a value from within a table or range. There are two forms of the INDEX() function: array and reference. The array form always returns a value or an array of values...- Bizylizard
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Access Lookup In Excel
I apologize if I posted this in the wrong section I have a Matrix in Excel example below that includes a top row % labeled M and a first Column % labeled P. What I am trying to do is from Access go to this Excel Matrix and import a specific value or sets of values. For example if M% is 106% and...- Bizylizard
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
