Queries

using query returns to create new columns
Hi, I'm working on a project that requires something I'm sure can be accomplished with SQL, but I can't figure it out myself. Basically I have a list of names with corresponding specialty information. The specialties have a varied number of corresponding subspecialties, so it currently looks like: Name ... 1 Jul 2008 10:16

Want a counter for Access Query results
I want to create a counter for a query by selected field results Main sort - req number Second sort - Date or Name or Time ...etc Output1 Have counter start on the main sort (req number) and count until that main sort changes. I do not want just the top x results, but the top x results by sort criteria ... 2 Jul 2008 10:52

Queries without duplicates
I'm working with a huge imported database from which I needa query with employee id, last name, first name, benefit name employee cost and employer cost. I keep getting duplicates on the ID and names. How can I get rid of these so that the employee number is the key record? ... 1 Jul 2008 01:04

Query for two fields in one record that do not match
I am trying to create a query that will show me all of the records in a table where two fields in the record do not match, basically the opposite of a find duplicates query, however the find unmatched query will not work for me. I have a table listing a client ID, an activity code, a count of the units and tot... 30 Jun 2008 13:45

SQL Statement
I have a table of just months and years for example: 2008-01 2008-02 2008-03 2008-04 2008-05 2008-06 And I have another table that is storing data that contains the date of say 2008-05. I have a form with a drop down that displays the dates in the first table but I want to only show dates that are not i... 30 Jun 2008 13:45

help with a query
Hello all, I have table Customer with the field CP I have the table Cpostal with the field CP_NUM The relation between this two tables is Customer.CP 1->N Cpostal.CP_NUM This means that the for one CP code in the table Customer i have N CP_NUM in the table Cpostal. My goal is update the field CP with the f... 30 Jun 2008 10:39

Time difference between multiple times and dates
I am having a problem working out the logic for sorting out a date series that includes times as well. I have some data that looks at computer uptime, and I only want to see how long the server is off for when rebooted to work out the total time over the year. Here's some of the data I have: 07/02/2008 09:52:... 30 Jun 2008 08:36

pivot chart legend shows "Sum of"
Hello, I have a query that I want to show in the pivot chart view. The legend shows the field with "Sum of" in front. Even when I use an alias the "Sum of" stays. Can I get this removed in some other way? I know the "Sum of" is required to create a pivot, but is there a trick of not showing it in the legend?... 30 Jun 2008 06:33

Filtering for "Not Something"
I have one table which contains all my contacts i.e. fields ContactID & Name and a second table containing tasks, i.e. fields ContactID & Task. So for example: Table1 ContactID Name 1 Fred Smith 2 Joe Bloggs 3 Mickey Mouse 4 Minnie Mouse 5 ... 30 Jun 2008 09:38

Using SELECT DISTINCT
Hello All I have a table [x confirmed], and 2 of the fields are 'practice' and 'month name'. This table contains typically between 10 and 50 records for each combination of 'practice' and 'month name' values - so for e.g. there may be 22 records where 'practice' = "The Health Centre" and 'month name' = "May 2008... 30 Jun 2008 12:44