I am using this
WTime: (DateDiff("d",[HireDate],Now()))/365
and this
VacHrs: Switch([wtime]<1,"0",[wtime] Between 1 And

I am trying to create a parameter query to let me enter the sales person I
want to query.  However, it isn't prompting and it doesn't show any records
(like it's taking the parameter literally as a string).
Here is the SQL query:

I am trying to filter multiple tables with a query using a date that is in a
field combined with the time. I need to be able  to use criteria to filter
out the appropriate date and not the time. I have used all types of
combinations using the wildcard characters and the "Like" ...

I have created some parameter queries to search by product or category, but I
am looking for a way to allow a remote user to search a large text field by
keyword/keywords.  Is this possible?  (I am not proficient in HTML or Visual
Basic, so if it needs to be done as code, I'd ...

Can please someone help me write this Query:
tblServices:
ServicesKey
ChargesKey

It seems that a make table query has no way to assign a primary key.  Does
any body know a nother way to get this to work maybe VBA.
Thanks

I have a query including fields job #, job name, DBuser, date entered.  It
works fine until I enter criteria [Please enter job number] for the user to
enter the job number to view a record.  When I enter the criteria it show me
about 50 "copies" of the same record.  I have never ...

I have a table with duplicate Customer IDs but multiple address types.  If I
want to select type MA or PR- but NOT BOTH, how do I write the query?

Where would I find the best information (tutorial) on working with Queries?  
I have several tables that I want to be able to print a single report from.  
I have found that I need to make a query of the tables in question then pull
my report from there.  So far all i am getting ...

I have a text field that needs to be sorted alphabetically.  However, it has
a hodge-podge of mixed cases and roman numerals.  For example -
003 (A) (3) (c) (iv)
003 (a) (3) (c) (v)

I have a form based on a table with 20 fields.  My clients want the ability
to search all fields to find the record they are looking for.  Is there a way
for me to create a form (with all 20 fields) where they can chose which
fields to search by and those records come up?

If I have a query that is pulling from a table with multiple months worth of
records. I have 2 columns with a "month" number, and a "week" number. My
query then asks which Month you want to view.
I have a pivot table based on this information, but can not seem to export

Currently, in order to edit the SQL of a query, you need to EXECUTE the query
OR open it in DESIGN view.  What if there is an error in the query that you
need to fix????  The query will NOT execute and it will NOT open in DESIGN
view.  Hence, there is NO WAY TO EDIT THE QUERY and ...

Okay, I have posted my question here on two previous occasions, and either
I'm doing a terrible job of explaining myself, or the people who have read my
posts are extremely busy and didn't have the time to read and understand my
post. I also admit that I am SQL ignorant, and ...

I have a table called List and a table called Zips.  I want to pull
customers from the List table, and assign them a region based on the
information in the zips table. I have a query set up which pulls the names
from List and the region from the Zips file.  This works, but there ...