I am not a guru with access and this problem has me puzzled...
I have a table wiht multiple months of data.  The key fields are a cost
code, report date and then several values (Budget, Actual, Forecast, etc.)  
All data is in the same table.  I would like to create one query that ...

Hello, I am attempting to make an If-Then type expression that will give me
multiple "Else" values.  (doesnt have to be If-Then, any variation that will
work is fine)
For instance, I know this isn't correct language but I essentially need

I have reports that list the All Invoices for the "Current Month" & another
for "Last Month". With the "Last Month" Query I have the date parameter
recorded in the criteria of the Query (eg Between #01/02/06# and #28/02/06#)
but I have to update this at the start of every month. ...

Hi
I have been trying to create a query that will find the duplicates accross
and number of fields to bring back the values that need checking for example.
I have a table with the following fields

When you create an action query in design view access provides a popup widow
that allows you to select "Current database" or another database for Append
queries and Maketable queries. However, it doesn't provide this option for
UPDATE queries.

Hi,
Is it possible to insert all the fields from a query into a table using SQL
code? For example, I have QueryA with 30 fields, but I don't want to have to
create the table with all 30 identical fields as QueryA. If it is possible,

hi..
I want to ask how to calculate day from date. For example 21/05/08 -
21/06/08, how many days between these dates and how to calculate days
from these dates.What is the format to convert date to day and format

Hi- I would like to be able to go to a record in a report from the record in
the table. For example, if we are talking about a specific record, I would
like to jump to that record in report view as oppose to opening the report
and scrolling to the specific record. I am using ...

Is it possible to use one of the Date Functions in a query grid to group my
employee attendance records by the Week of the Month?  There is a record if
they are absent with their EmpID, Date Absent etc.  I need to give them bonus
points (or not) depending on whether they were ...

I have two tables INFO1 and INFO which have same structure and how can
campare the data of a particular field in INFO1 with same field in INFO

In the qbe window, I would like to chose to select groups of records, For
example, in the FORM LETTER field, I want to select groups of records of
either j,k, or L that would select all of the j and k and L records, OR type
in either b, c, or d to select only, but all of, the b, ...

I'm evaluating the possibility of upgrading to Access 2007, but have run into
a problem.  A type of query (involving joins between linked ODBC tables) that
used to be updatable in earlier versions (at least Access 2000 and XP) is no
longer updatable in Access 2007.  When I try to ...

A previous employee set up a tool that takes all of our Ops Plans and
combines them all into (what becomes) an Excel sheet called ALL.
She is unable to maintain this "tool" and now I need to add the 2009 Ops
Plans Append Queries, but I don't know how.

This is a repost, unfortunately I posed this question about an hour ago and
it still wasn't listed, so here it goes again. I am trying to do this in a
QBE query screen. I have a field in my table called "FORM LETTER". The
results/data elements in this field are A thru L. In the ...

I'm trying to find a way to summarize some data.  One of the summary items I
want to show is the last time an event occured.  
The data is a list of scan data that shows a Label, then identified with
this label are several events when the item was scanned.  For the pourpose of