I have a form with a frame with 5 choices.  1,2,3,4,5
I want a query to retrive data based on what they pick.
Can someone please let me know how to fix this.
IIf(([Forms]![frmAssignedtoo2]![Frame0]=2) Or

I am building a database to act like a bank account statement. I have a query
(called Daily Credit Debit) which total all of the transactions on each day.
I want to create another query (rather than a report) that will provide a
cumulative total of the daily credits and debits. ...

I have a table with SKU sale by store and want to build a query that pulls
the skus that make up the top 75% of sales by store.  I'm a fairly basic
Access user, most comfortable with the Query design tool, not so fluent in
coding in SQL text (or VB for that matter).  Is there a ...

I have a database of investigations that are open and closed.
I am having trouble creating a query/chart that is able to run a cumulative
total (running total)  for all open investigations. So the chart will keep
count of the open investigations until they close, then they are ...

<Name> is not a valid name. Make sure that it does not include invalid
characters or punctuation and that it is not too long. (Error 3125)
The specified name does not follow standard naming conventions or is not a
valid parameter or alias name. Check your entry to make sure you ...

I need to update a field with the durrent date using an update query. It
needs to be in the YYYYMMDD format. I'm using Access 2003.
TIA
Rick

Is there a way to search for a unique ID across all tables?  All ID's are
unique throughout the database and I need to search the entire thing for a
single ID.  Using Access 2003.

Hello, you were kind enough to answer my question regarding date criteria in
queries using data from a works database where there are several dates in the
format dd.mm.yyyy in one field.  Could someone please help me to develop the
query so that years between say 2002 and 2007 ...

I am trying to create a find unmatched query in access 2000.  I have a
table that has values for months 1-12.  I want the query to look at
the value in one table that I have an compare them to the values table
that I created.  If the value don't match up then I want a query

I have a number of fields with absence information and calculated the total.
I want to calculate [Abs_PH] as a percentage of the total. Here is a
simplified SQL
SELECT tble_employee.WorkStat, tble_week.Period, tble_hrs.Dept,

I have a crosstab query that has 3 select queries that run before the data
reaches the crosstab.  I am trying to set the criteria of 3 different fields
in the select queries to filter some of the data before it gets to the
crosstab.  I am using an unbound form with unbound ...

I am trying to create an expression in a query that says if
CONTRIBUTION BEGIN year is less then 2006 and the AUTE2 = 00/00/00
then count the number of "0" in the rown and multiply that by 58.
This is what I had thought up so far, but I know it isn't right.

After much help from people here I am almost done muddling my way through a
new db i've been tasked to create.
I've got my table linked to an outlook inbox..
Now I have an Append Query filtering out the specific data I need to update

I have created 3 queries that provide a count of all the records within my
table that meet specific criteria.  I would like to have my query show just
the total number of records.  The fields are Name/Address #1, PNC Card Nbr,
Date Mail Returned, and Date Card Mailed to Customer. ...

I'm using Access 2003.  I have a query that returns a number of fields from
various tables.  The query results for example could be:
Jim   Green   Cleveland
Sue  Orange  Chicago