I have a form which inputs data ("Unit') in a drop down box (into the main
table) This data in the drop down box is based off of a separate table.  In
addition, this table also matches other data to it.  Example:  Unit1 also has
Location1 and Battalion1 listed in the same record. ...

Here's my question...
I want to create an IIF statement that results in the following:
If Type = S1 or G2, then Value *-1, if not, then Value.
So, if the type is either S1 or G2, Value should be multiplied by -1, else,

I have a text box on a form where I intend the user to be able to type in eg
Sarah and retrieve from a list where sarah might be listed as Sarah or
sarah/works, or indeed accounts/sarah
(the list of names is an action list and is stored in a table)

I'm having a hard time with this, and I don't know if it's possible.
1)I have an excel file that queries a SQL table, then proces it. <--no
probs
2)I want the process data to go into a premade Access query as a

I have a update query. When I run the query, it always pop out three windows
to ask you to confirm you are runing the query and some data can't be updated
because some calculated data missing. Is there any way to make these windows
do not pop out every time when run the query?

I have a scenario that requires a little more knowledge than I have at this
point.  The Table below contains gross revenue information for our facility.  
I basically need to calculate Gross Revenue per day using a 3 month average.  
The formula is as follows:

How do you do a search based on date, for example I have a database,
which is log shipping contacts. How can I search for all entrys logged
which are 6 months old.

Would appreciate any help with designing a query(most probably queries)
based on the following table:
Product Line    Customer    Whse Variance    Whse    Mode    Mode Variance
PRD1                    6164          -10                    One    RAIL    30

Can help me on how to group the query by Month. Currently it is grouped by
date.
SELECT [TNHEADER MASTER].[SALES PERSON], [TNHEADER MASTER].DATE, [TNHEADER
MASTER].STAFF, Sum([TNHEADER MASTER].XNLINES) AS SumOfXNLINES, Sum([TNHEADER

Seems to be a common problem. I've read through many posts and guess my
problem is referencing the second table. My query for duplicates references
two fields and I can't seem to make the subquery. Can anyone help?
DELETE CCC1998.*, CCC1998.Address, CCC1998.[List Date], CCC1998 ...

Is there a way to set a defalt to pick up the last 13 months?
I am using a between date range and would like to have a code to avoid
changing the dates...
If so please assist...

Can an Access query be created to update a database table on a certain month
in a year without having to remember to run the query?
Thanks

I have 5 tables (source) and one target table. What I want to do is if there
is an entry into any of the fields that I have in my grid I want that record
to be updated into my target table when the query is ran. Here is an example
of an expression I am using under each field.

I have a query where in a field I have a results from several fields. I want
to know how to show the result if negative in ( ) and not with a -.
thanks

I have a commission table which lists the commission of employees biweekly.
So, there are two dates for each month in the table. I want to find the total
commisssion of each employee by month. Is there a way to do that using a
Query? I know it can be done by reports. I was ...