I have a linked table to an Excel sheet that includes columns for the past 12
months. I need a query (or vba code) that will normalize the data into one
column for month values, and multiple rows for each month.
Starting with a structure like:

I have a table that contains a date, beginning quantity and ending quantity.
What I would like to do is to update the current records beginning quantity
with the ending quantity from the record with the date closest to its' own
date (but less than the current records date). Any ...

I am trying to calculate the warranty expiration date on some records in a
table.  WarrantyStartDate is Date/Time and WarrantyYears is Integer.
I have this expression in a query:
WarrantyExpire:

I have a simple unmatched query that looks for policy numbers in one table
(actually it's a query on a table) that don't have a match in another table
(again a query on a table).  When I use "Is Null" on the criteria of the
field that has the missing policies, I get a "Data type ...

I am using Access 2002. I want to create a function that can be used in a
query. The name of the function is 'TimeCode'. Whenever I try to run the
query, I get an error saying "Undefined Function 'Timecode' in expression".
My function is a standard module:

I'm sure that this has been asked and answered before. I have a table with a
set of graded performance results running from a to E, so, my grade could
be: a, A, b, B, c, C d, D, e, E. The small letter indicates a grade below
the median, and the capital letter indicates a grade above ...

How do I save the output of a crosstab query result as a table

I have used this code several times in other queries for reports and for
some reason this time it will not include records from the last date input
in the query/report.  Any ideas?
Not Is Null And Between [Forms]![frmReports]![edtStartDate] And

I have a problem with accented characters in indexed fields in Access.
The Database:
I created a small database using French Access XP on French Windows XP SP2.  
It has one table called Test and one field called Field_Text.  There are two

I'm trying to create a query that show the latest recorded according to the
date.  I have a table with mix orders and I would like to create a query
sorting to Group, but only show the latest record for that group.
Any help would be greatfull.

I have been using excel to do this problem, but I think it would be faster in
Access...
I have these fields FUND, ACCTNO, OBJCODE, ACCT, DR, SUBCODE, DESC, AMOUNT,
SSN, NAME, EFF_DATE, TERM, REF

I have a table in which two fields are repeated (Job Number and Service).  
I'd like to create a query that only displays the first row of the repeated
records, so that the job number and service combination will be unique
(ideally it would display it as if a job can have multiple ...

Hi everyone. I have a database of questions and answers. I have a form that
the user will answer questions on. This form is based on a query that I
would like to randomly pull questions from the questions table.
On the form, the user is populating a date field, logon field, and ...

It's been a while since I've played with delete queries, so this is
*probably* something simple that I'm just not seeing...
I have two tables and queries.  One table has a lot of rows
(tblElecRateReviewDetail).  Some of these rows I need to delete.  One

Is it possible to UNION 2 crosstab queries together?