Queries
in [Access]
|
using "Last" in query desgin I am trying to build a query that sorts data ascending order by date, so that when I select "Last" in the Total row for other fields in the query I will get the newest value (I have an account field that doesn't change but I want to retrieve the newest account description which can change from one day to the ne... 10 Mar 2010 17:35
How to populate a column in a row based on a value in another colu I have several tables and I'm having a problem with my last one. I have two columns in this table, 'License', which are populated using combo boxes, and these combo boxes are populated from using queries on other tables: I have an 'Entitlement' table with has and Entitlement ID (different to it's primary Key ... 11 Mar 2010 12:19
Column for line numbers... Can an expression in a column be used to generate line numbers? 1, 2, 3, etc. Thanks David ... 10 Mar 2010 17:35
Count of Unique Values in Access Field In the query given below which is done in Access SELECT [Q Test].[Lead Business], [Q Test].Region, Avg([Q Test].[Cycle time days]) AS [AvgOfCycle time days], Count([Q Test].[Contract ID]) AS [CountOfContract ID] FROM [Q Test] GROUP BY [Q Test].[Lead Business], [Q Test].Region; The field Count([Q Test].[Contra... 14 Mar 2010 13:10
Is it possible and how can it be done? I have a table looking like this: Id TaskLeader PreviousId .... 4 Hans 2 5 Kari 7 6 John 5 7 Jim 4 8 Kari 6 I'm wondering if it's possible to make... 11 Mar 2010 03:28
Look up by Date issue I have a date field that I want to filter based on a date. However the date contains the date and time. I want to allow the user to enter the date to filter the date. When we enter the date in the criteria - it comes up with no records. However there is data when not filtered. What can I do? -- Matt Campbell m... 9 Mar 2010 19:16
Comparison Query - How to write it! I need to write a query which will make one table's worth of information (Labour Hours Table) look up its corresponding fields in another table (Rates of Pay) and report back the resulting “rate” per hour Table: Rates of pay Field : ID / Autokey Field : Labour ID Field :Customer ID Field : Job ID Field :Shi... 10 Mar 2010 14:13
recursively retrieve records from 2nd table based on records from I have two separate queries, that show the wanted results. I tried hard but i cannot "merge" them into query/subquery. I am not sure if subqueries are the right way to solve this. I keep having errors or results that aren't the ones expected. Below is the query , with simplified table/field names. SELECT... 9 Mar 2010 07:50
Nz - need code - I have a crosstab query that yields no value where I need a 0 value for further calculation. I do not write code: This is the SQL for the crosstab. TRANSFORM Sum(qLeaseEndDataAllDatesStatusJoin.Count) AS SumOfCount SELECT qLeaseEndDataAllDatesStatusJoin.[Lease Month], qLeaseEndDataAllDatesStatusJoin.[Leas... 9 Mar 2010 07:50
Brain Freeze help with combobox and query Hi, I have a personnel form with typical personnel data. On the form is an combo that has a data source of employeeID, LastName, First name. The first (0) column is bound to the combo. The query that feeds the form references the combo as criteria against the employeeID. =[ME].[cboEmployee] Or Is Null ... 9 Mar 2010 11:12 |