Queries

Stuck on a date issue
Hi all, and thanks in advance. I have dates entered in mm/dd/yyyy format but want to sort disregarding the year... in other words, the following fields would sort this way: 03/07/1972 04/01/1930 07/12/1947 Any way I slice & dice it, I can't figure this 'un out. -- Thanks for your time! ... 8 Jul 2008 15:09

Query one table against part of a cell of another
How do I create a query that matches the records in one (tblLocationsInFtWorth) table based on part of the City field in another (tblCities)? Example: table 1 is the tblLocationsInFtWorth and table 2 s the tblCities table. tblLocationsInFtWorth LocationName Joes of Arlington Radisson TX Galviston tblCitie... 8 Jul 2008 15:09

Formulas
I need alot of help. I am new to the access software and I am trying to create a database. I need a formula from excel to work in access. blank=rates*discount how can i make a field equal one field times another field ... 8 Jul 2008 15:09

Table not in List to Append to
I must be missing something really obvious, but I want to append some rows to a table I've created, but when I change my query type to Append, the list of tables I can choose to append to omits the table I want, while showing the others. The one I want to append to does appear if I try to show a table to select ... 9 Jul 2008 07:32

using the Or criteria
I have a query that in addition to the name and address fields has 4 fields named using iif statements. I need criteria to select names based on a "Yes" entry in any of these 4 fields. I have tried putting <>" " in the criteria field in Field 1 and the same in the "or" field of Fields 2-4 and the result is na... 8 Jul 2008 15:09

IF statement
I'm not the best with SQL for Access however I want to create an IF THEN Scenario, this is how I would write it in the SQL I know (I mostly use SAS): (CASE WHEN [Age] is between 1 and 4 then "1 through 4" WHEN [Age] is between 5 and 9 then "5 through 9" WHEN [Age] is between 10 and 14 then "10... 8 Jul 2008 16:11

Union Query to a Table
I created a union query. How do I get the output to go to a new table? Do I have to CREATE TABLE then use all the INSERT INTO functions or is there an easier way to do this? I am creating a new table because I need another database to be able to link to this table. ... 8 Jul 2008 13:06

Outer Join Question - "join expression not supported"
Hi, I am trying to narrow down an outer join, the problem is when I add the condition (compares char field to fixed text) to the where clause I get no results in Access, when I try to add to the outer join I get "Join Expression not Supported". The same query runs fine in SQL Server (but I can not run it there in t... 8 Jul 2008 11:03

Duplicate values
Hello, all I have a table that have +/- 40000 records of duplicate entries. I know i need the record more recent of the duplicates (i have the field DATA_V to order the records). My question is how i delete all duplicates less the more recent record? Or any other way to solve this problem?... There is ... 8 Jul 2008 11:03

Query only showing specific records - i need all - please help
I have a combo box in a form (Based on a query) that looks up values in the Finish Lookup table. The table has the following info: Finish Description Finish Rate Finish Sq Ft Coil .45 Cutting 0 Foam 3.50... 9 Jul 2008 16:48