Queries
in [Access]
|
postcode search, lookup, finder Anyone looking for an address finder or postcode search? Try postcode anywhere for a great range of online address management tools. http://www.postcodeanywhere.co.uk/ ... 21 Sep 2005 10:28
Fixed vs. Relative Time Periods An example of a fixed time period would be July 1, 2005 or Q1 2005, Q2 2005, etc. Examples of relative time periods would be 12 month rolling to Current Year, Current Year, Last Year, YTD Current Year, Current Quarter Current Year, Previous Quarter, 12 month rolling two years ago, and so on. Does access recog... 11 Jun 2005 21:31
Unmatched query Hello I created a unmached query where i want to see the students who not made a specific task. for example in grupo 5-1 I have 19 students, 4 students made the task nieuw. What I want to see is a list of students who did not make the task. The query is: SELECT tareas.Grupo, tareas.Nombre, tareas.Apelli... 25 Feb 2005 08:56
How do I calculate percentile in acccess? What is the easiest way to calculate percentile in access? ... 25 Feb 2005 08:25
Expression using RIGHT and LEN functions I have a table with a text field named Board 2005. It has data like "2005 treasurer" and "2005 librarian". I won't go into why the year has to be inside the field and not a separate field, but that's the way it has to be. In a query, I want to create a calculated field that will pull all data from the above ... 22 Feb 2005 09:28
Rolling 12 Month Average Could someone help me with a query to calculate the rolling average of values? I have columns in my table of Year, Month and Value. I am trying to calculate the 12 month rolling average of the Value. This is what the ouput should look like with "12MoAvg" being the rolling average. How do I do this in Acce... 17 Feb 2005 14:09
Pass a parameter to nested query Hello, I've got two queries, one calls another. The first query has a criteria to select month and year from a date field. The second query calls the first query. I want to be able to pass a parameter (a variable) through to the first query when I call the second query - is this possible? My first query ... 22 Feb 2005 10:23
Calling SQL Stored Proc from Access (with Parameters) Hi I am aware that one can run an SQL Server stored proc from Access and return records and even pass in parameters to the stored proc to get the desired result. At the moment I am doing this with a "Pass-through" query with Hard-Coded parameters. What I want to do however is have the parameter that is pas... 20 Feb 2005 23:30
Vlookup In Access I am a new user of MS Access and have in the past done all of my databasing in MS Excell. I was wondering if there is a lookup function in access that is equivalent to the Vlookup function in Excell. I've tried Dlookup but it seem to only be able to return records from a single table where Vlookup references on... 15 Feb 2005 20:39
InstrRev I'm trying to use InstrRev in a query but its not being recognised. I get an undefined function message when I try and run the query. Any ideas? Karen ... 12 Feb 2005 17:06 |