I'm trying to create a new column that includes everything from the right of
the * in the following number, what function/formula will do that for me?  
Thanks.
1*1003

I need to have a query that will check against another field (RMD) in my
query to see if the customer is 70 1/2 years old and to include any leap
year. How is this done?
I am trying to see if a customer can collect on his insurance based off a

I have 2 tables; one table with employee data (name, addr, ss#, empID, etc..)
and another table with insurance plans via zip codes.  I need to match the
employee Zip code from the 1st table with the PPO list in the 2nd table so I
can tell what PPO he is eligible to join.  What is ...

I'm looking for a way to calculate the top 20%/ 50%/ 75% of my data in
Access.  I know that you can do this in Microsoft Excel, but my data file is
too large to just run it in Excel.  Is there a way to do this analysis in
Access?

Sorry if this is too complicated, but I am desperate to work this out!  I
have two tables, the first one (ContactDetails) contains information about
clients, the usual stuff, name, address, etc, but it also contains 2 other
fields: GAStatus and RGStatus.  

I am developing an application in access to track working hours of equipment.
However in Europe, as in a lot of countries the clock advance and retard
during the summer and autumn respectively meaning you have one 23 hour and
one 25 hour day each year. Access does not appear to ...

I have a field called contract totals, I know how to use a query to choose a
range of dates, but need a total in a chosen date criteria.  What I've been
getting is just the first contract total, can't seem to get it to total the
entire field.  Simple, just the totals, don't need ...

Hi,
I have a query, and within the query I want to limit the result set by
adding criteria.
I have an if statement which says iif([debt-code]>100,True,False).  What I

I am trying to run  a query to show only those records that have information
in a particular field.  I can't seem to show only those records.  I get all
the records, and I only want the ones that have an e-mail address in the
e-mail address field.  What should I do in this query ...

I have a football league table that works fine, but I don't know how to put a
column with the position in the league, (1 - 12)

I have a table that contains the following fields:
Mailing List ID
First Name
Last Name

I'm trying to use the IN operator and I having trouble.
I am getting a list of numeric values from a form and using it in a query as
follows:
In ([Forms]![menu_reports]![txtTradeCodes])

I am running a report that lets me know if certain people do not have a
certain qualification.
All works well if the employee has no qualifications and the return is true.
However if an employee has many qualifications including the qualification

Is it possible to copy a record when a field contains three entries and
obtain
3 records, one with each entry.
The table is Colors :

I have a table with multiple customers each identified by a policy number.
Each is also assigned one of 20 HMOs.  They have had the chance to change
HMOs. I have a list of the policies that have changed HMOs.
Is there a way to write a query that will select each policy number in ...