I've searched all around the net, but no "solution" seems to do what I'm
trying to achieve.
I have a database that imports data from a group of Excel spreadsheets. Due
to the manner in which these are generated, some duplicate information will

please help me...

I know I can do this using a sub query but I'm trying not to Basically I got
three feilds of data.  One of the feilds is a dat feild and I'm trying to
group the data on the most recent date.  For example:  In the data below, I
would like the query to display for each category, ...

Is there a way to have a query create a new table each time it runs without
having to interact with it?
For example: I set up a macro to automatically run the "export" query each
day at 10am and want to have it run again tomorrow without overwriting the

Hello -
I am having trouble with this expression in my query:
ExpiryDate: CDate(Format([ccExpMonth] & "/" & ([CCExpYear]+2000,"Short
Date")))

My boss wants to extract every 9th, 18th, 27th etc. record from the table in
the database.  He is utilizing this information as a verification check on
the records that have been entered into the database.  Can this be done in
access and how?

Hi...hope someone has an idea about how to do this easily.
I have two tables.  Table1 has ~75 fields/columns.  Table 2 has ~50
fields/columns.  The two tables have columns named the same (I would estimate
approximately 30 fields have common names).  While there are common fields,

I have a Public Function that is working just fine and returning back the
correct data as expected.
What I cannot figure out is the syntax to use it as criteria for a query.
Can anyone point me in the right direction?

I am working on updating 853 records regarding BA Majors. A good chunk have
been sporadically done according to a standard three letter code. I wish to
write a query that will pull up all the records EXCEPT for the 40 standard
three letter codes from my table.

I am running a make table query against one DB2 table and then running an
append query against a separate DB2 table to join data from the two tables
together. In both queries I use a between operator to select the period of
time for the data. The dates for both queries are always ...

Hi, I have a file in which I have an order date column, the date is in the
form of MM/DD/YYYY, what i am trying to do is to find all files More then a
month old from the current date. ie ( Todays date 10/11/2007) - 1 Month) and
then give a list of files which fit the criteria.

I need to create a query based upon the anniversay of employee hire dates.  
Records should be limited to only those employees with anniversaries within
the next 60 days, so we can do annual reviews. How to I create another field
in a query that extracts just the month & date from ...

A query with two fields.
Field 1 = Name
Field 2 = Amount
How do you group the query by name & add up the amounts.  What code would

Hi -
I need to run a query for a mail merge and I need a field that will either
return “her” or “him” depending on my “sex” field.  My sex field is already
established, either M or F, so I need a new field where if sex=M then

I am trying to exclude text data that originates in a lookup field in the
table, in a query (in other words there are about 6 things in the lookup and
I want to design a query that will only contain 3 or 4 of the values in the
lookup). I have tried: