Queries

Really weird query responses.
Right, this has been confusing me for days now and I have thrown in the towel and need to get some advice. I am getting some really weird results from a query. The background: I have a table that amongst other fields has fields for the total annual spend in years 1,2 and 3 of a contract. All the fields are in... 4 Jul 2008 07:57

Subtract positive number from negative number
I have a query similar to this: SELECT Sales.ThisYear - Sales.LastYear AS SalesDifference FROM ThisYear, LastYear; This works fine if they are both positive. However, I have an instance where the sales for this year is negative and last year is positive: ThisYear: -80,000 LastYear: 20,000 Result in Acces... 4 Jul 2008 05:55

Query Join on Multiple Field Indexes
I have one Table with a 2 field Primary Key. A second Table has a 2 field Index. Each of the 2 fields is defined the same in both Tables. I want to Join the two Tables in a query on these 2 fields - one a Primary Key in one Table, the other a 2-field non-Primary Index (known as a Secondary Key in other databas... 6 Jul 2008 03:48

Can you create a table from the output of a query?
Using MA 2007 ... I would like to create a new table from the output of a query. Can this be done ... if so how? Thanks Bob ... 7 Jul 2008 11:28

Record Count
This is a field in my query Field Eligibilty Date: DateAdd("m",7,[Start Date]) Table Total Expression Sort Show Yes Criteria Format mm/yy that returns the following example correctly: Start Date Eligibilty Date 01/01/2008 07/08 But what I dont know h... 3 Jul 2008 19:43

Ranking (tried a solution by John Spencer, but didn't work)
This is my current table "allunitbatch". Want to automatically rank the batch Ids within each MD Batch Id group so it gives the results shown in the Rank column below. Batch Id MD Batch Id Rank APPL-MOM-309-07-01 APPL-MOM-309 1 BANA-HTL-120-06-01 BANA-HTL-120 1 BANA-HTL-1... 3 Jul 2008 18:41

how do i use input parameters with criteria
I have a select query which is mainly made up of expressed columns based on "IF" statements comparing the two table in the query then returning a value. I have input paremeters based on a [Warehosue location], [Audit Start date] and [Audit end date]. In which I have identifeid what to return in the event any of... 3 Jul 2008 16:38

query tables using multiple listed values from another table
We are trying to set up a query where we have a table with static data that is all located in the same column and we want to use this data as a search criteria for another table. We are NOT linking the tables at this point. The goal is to be able to build a query that will use the static data from table 1, wh... 3 Jul 2008 19:43

Ranking query
I've gotten this to work for me, but the sequence is reversed. The entry with the highest # primary key is listed 1st, then down to the oldest. What have I done wrong? SELECT FormalCharges.UniqueID, Count(FormalCharges_1.UniqueID) AS Sequence, FormalCharges.DefendantID FROM FormalCharges INNER JOIN FormalChar... 3 Jul 2008 19:43

Count number of times an entry for list B shows up in List A (cont
Hello, MS Access 2003 on XP Pro. I have two lists, A and B. B contains a comprehensive, unique list of all possible CCC codes. A contains records of work elements. One piece of data for each work element is its CCC Code. Since each Work Element can be binned to several CCC Codes, I have a problem. I want... 3 Jul 2008 14:34