Hi, I'm using the issues database template with a bit of modification and I'm
tracking customer complaints.
On the issues form I have the date issue is raised and the date it is due to
be closed (i.e. within 30 days).

Access XP running in Windows XP
Just noticed that my Query lists 3 separate records twice each time it is
run. Thus the report based on this query is incorrect.
The query is pulling data from 4 tables. Could this be the problem? The data

I'm trying to retrieve the string between the 1st and 2nd occurance of the
underscore _ character.  Sample string is
ALL-REGIONS_65959_2007_07_Detail.csv.  
Here's what I've got so far.

I have a query that looks that this:
Customer1   Loan#1   Date   Rate
Customer1   Loan#1   Date   Rate
Customer1   Loan#2   Date   Rate

I am stumped.  Please help me!  I need help with syntax for an expression.  I
have a simple table which contains one column for each date of a particular
conference that medical students are supposed to attend (2 conferences per
day, Monday - Friday). These are is text fields.  I ...

I am trying to build a conditional expression in an Access query that will
tell me how many weeks of vacation an employee has based on years of service
(which is computed using a different query).
For example 1  yr of service = 1 week; 2 to >5 yrs of service = 2 weeks; 5

I created a little database to store all of our software install keys and
license codes.  The look-up form is a dropdown list which the user can select
a software application to pull-up it's associated information.
Ideally, I'd like to create a query that prompts the user with a ...

i have created a delete query based on 2 tables - one is a mailing list, the
other a list of bad addresses.  i would like the delete query to remove
records with "bad addresses" from the mailing list table.  when i run the
query, i receive an error message that says "could not ...

Is it possbile to use an * in the conditions of an IF statement ex:
Name: IIF([Name]=*ADP*,"1st","2nd"
What we want to do is find all names with ADP somewhere in the name and then
return the true statement.  How can this be done?

I am trying to use the replace function in an update query to eliminate text
in a field;  the field contains first and last names.  However, sometimes the
name contains an alternate name or unofficial name in parenthesis.  For
example the field usually contains syntax like "John ...

I have a table of rates which occur on certain dates (one a month).
It has two fields Rates.Date and Rates.Value
I then another table where each record has a date in it, and I need to
find the Value from Rates at the matching date, OR at the nearest date

I'm not that familiar with pass through queries but I'd like to write one to
avoid the tedious task of entering a username and password when querying a
certain table.  The table that asks me for a username and password resides on
SQL Server 2000. If anyone has any ideas, ...

I am not new to access but am new to some of the more detailed programming. I
have a couple of minor things than need to be solved and unfortunately I am
on my own with no one to ask. So, having said that, I have a several
"troublesome" items.

The query this is based off has many fields but the most important are:
Rep, Office Location, TotalAlert, and Conversion%
I need to create a query that will give me the top 10 reps (those with the
lowest Conversion% in ascending order with the TotalAlert in descending

I have a monthly sales report.  I would like to keep track of the 52 wk sales
dollars in a column field with the period end date AS the column header.  
Adding a new column at the end of every period.
     UPC          07/14/07        08/11/07