I want to do a query based on zip codes but want the query to only consider
the first 5 numbers of the zip code, so if a zip code is entered as
12345-6789, the query would only consider 12345.  How can I do this?  Any
help would be appreciated.

I got this nice pease of SQL from Duane
Showing the total for each valid quote:
SELECT  Sum([quotelines].[TotalPrice]) AS tPrice,quotehead.QuoteNo
FROM Quotehead INNER JOIN QuoteLines ON Quotehead.id =

I am having no success with a task that I have been given in work.
The .csv that is required contains 20 fields and for the most part
these fields can be added to the query by double clicking.
Where I am completely baffled though is there will be 5 columns within

I don't know what this would be called so couldn't really have a discriptive
title....
I have a database where we record all of the IT equipment used in our team
at work.  When someone leaves or someone new starts the database gets updated

How can I round a whole number? ex: 253,678 to 254,000.
Pls. help.
Thanks,
Franco

I am trying to calculate two date fields minus each other.  If one of the
date field is blank, I want to be able to add a date.  This is what I have so
far.  Any ideas?
Nights: Nz([CheckOutDate],Nz([Enter Date for Blank

Can anyone recommend any good reference books for learning SQL.
But only as it relates to Access (baby SQL as it's referred to at work).
Any recommendations greatly received.
Thanks,

I have a calculation in a query that is as follows
M3: [Width]*[Thick]*[Lineal]/1000000
The "Lineal" feild refers to a calculated feild in the same queary as this
new "M3" calculation but everytime I run it in datasheet view I get the

I have a database which lists duplicate records.  I want to delete all
duplicates records that have the same info in a specific field.  I think if I
use the addr field it should work.  Here is the sql
SELECT dbo_comps11.title AS dbo_comps11_title, dbo_comps11.addr,

I have 2 tables (OLD and NEW) with identical formats, and I want to extract
only records where the ID is in the NEW table but is not in the OLD table.
for example:
OLD table:                                        

Hello
i have a continuous form based on a query with a student table and parent
table. that gives me parents of students that were accepted to the college at
any time.

I have database having a  column content a 9 digit number , each value in
the field is unique. . I need to send it to the database to external company
, so I need to do something with this column like encrypt or I have an idea
but I do not know how to do it; convert the numbers ...

I have an anniversary date for some folks in my contacts database & want to
know how long these folks have been married.
YearsMarried:=Int((YearsMarried: Now()-[AnniversaryDate])/365.25)
I get an error message.

I am trying to follow an example for finding top N values using VBA given at
this link:  http://support.microsoft.com/kb/210039/en-us#appliesto
I've had success with this in the Northwind example database (with my own
tables or with Northwind tables) ...

I know this may be answered somewhere but I am new at this and need very
specific steps.  Screen shots also help.
I am running a query.  In one of the fields "addr: it has information like
this example.