Queries

Query results where gaps exist Min & Max do not work
Hello all, I was using a min and max on the specimen id here to show the first and last specimen worked on, however; that doesn't work when a gap in the specimen id exists. Here is an example of the data: Year SampleID SpecimenID 2009 200999137 001 2009 200999137 002 2009 200999137 003 2009 200999137 004... 12 May 2010 15:53

Calculated field
I need to calculate many fields based on one start date and I need the calculations to count by month. For example first visit is 4/25/2010 The first calculated field must be 5/25/2010 +/- 7 days This is the first time I've had to do a calculated field where the next visit must be the exact day of the next mon... 12 May 2010 13:37

Append only new records/entire record makes unique identifier
Hello,   I have been searching the existing posts for an answer to my issue.  Many have similar suggestions, but none of them quite fit my problem, so I apologize if you feel this is redundant.  Here we go:   The ultimate goal is to append new records (and new records only) to an existing table.  When the query ... 12 May 2010 15:53

The not "Max" records
Hello, I have a query that finds all records with a particular "Case#". I changed the query to do totals and grouped by Case#'s. I have another field called "PrisonID" in which I want to see all records except for the Max (except the highest number PrisonID). Eventually I need to change this query into a delet... 12 May 2010 17:00

Query, linked tables
I have a table called tblPA where all personal data of Personal Assistants (PA) is recorded, being PaID the primary key. The second table linked by PaID as foreign key, is called tblavailabilitytowork, it has a y/n field for each time frame they can work, e.g.: on MondayAM, MondayPM, MondayOvernight, etc. When ... 13 May 2010 07:11

subtotal in access?
Subtotal ?? Access ??????????? scot wrote: Access Subtotal in Query 06-Jun-07 I have a simple query that uses 3 fields. Location, Person and Value. When I group by location and person and sum value, I get all the results I need but I would love to see subtotals for each location. I'm using Access 2003. ... 12 May 2010 06:58

Crosstab column data count
I have a crosstab query with Well Name as row heading , site visit Dates as column headings (formatted as "yyyy"), and averaged water level measurements data as the values. The column headings range from 2004-2010 and some wells have no measurements during some of these years. I need to create a dataset from ... 14 May 2010 11:43

RelationShips Queries and joins
Not sure where to start and the posts I have read I do not fully understand I created 2 tables (remitt and Billing) and for each table I created a query--Because I needed to create a commmon expression (1st 10 digits of a name & a w/e date & Pay code). The names never match 100% I want to make a final query ... 12 May 2010 14:45

Join on a calculated field
I am trying to provide a SQL query to the rowsource of a combobox. I am trying to use two tables to do this but am not sure how to go about it. The table for the combobox list is a contractor list and has two fields pertinent to what I need to do; ContractorName and ContractorKey. A ContractorKey data exampl... 14 May 2010 19:26

Daily Make Table Query
I have a Make Table Query that I will need to run every morning. Is there anyway to have the query add today's date to the name of the table (without going in and changing it everyday) so that the new table won't overwrite yesterday's table? ... 11 May 2010 19:03