Need urgent help
What is query to map data by combining multiple columns in different table I have two tables named table 1 and table 2 respt.. In table 1 is as shown below User Role AP.A AP.B AP.C AP.D High Low Medium Sanket Admin AP.A AP.B AP.D Abhi Man AP.B AP.C Sank Emp AP.A AP.C AP.D And [...]

Answer Question   |  October 4, 2012  7:40 AM
Query, Query Design

Mulitple Selects
Trying to isolate specific entries from a table based on Production Code: (Select (P.EntryDate) From Production P Full JOIN ProductionJobNumber PJ on P.Code = PJ.ProductionCode Where P.ProcessCode = 1080 and PJ.JobNumber = OH.JobNumber) as OkToPlate, (Select (P.EntryDate) From Production P FULL JOIN ProductionJobNumber PJ on P.Code = PJ.ProductionCode Where P.ProcessCode = 100 and PJ.JobNumber = [...]

Answer Question   |  August 13, 2012  8:12 PM
Query Design

Count IIF Statement?
In the design of a query, I noticed that under the tab “Group By”, there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I’d like to use countif(field>0) instead [...]

Answer Question   |  December 23, 2010  6:49 PM
Access query, IIF, IIF function, IIF statement, Query Design