Many of our customers are foreign and have quite unusual names spelt in
tricky ways.
When we run parameter queries looking for data on a particular customer it
is sometimes difficult to get the spelling right and the query doesn't return

I am trying to rank customers by their total sales. I have a query
'qryInvoiceSalesSummaryMargin' that has the totals for each customer with a
margin percent. I started a new query called
'qryInvoiceSalesSummaryMarginCount' that I would like to rank my customers in

I have a table with the folling fields:
REGION COMPETITOR BIN1 BIN2 BIN3 PRICE
and I am using this function to calculate a median:
Function MedianF(pTable As String, pfield As String) As Single

Using Access 2003, I want to write a query against information in the
following sample format:
Manufacturer       Item Number     Source System
Acme                  A-1                   GoodSoft

I am using the following date filter in a column on my query. The problem I
have is that it is including dates i do not want to see. For example If
DStart2 = 1/3/07 and DEnd2 =  1/4/07 then it will return all records for
1/3/07 and 1/4/07 but will also return records for 1/30/07 ...

I have several databases with queries run by multiple users.  Often they come
to me to complain that they must re-enter the criteria for a query (which is
entered at run time) more than once.  The only solution I have found is to
recreate the query.  Just copy and pasting it ...

i have a major problem with my exam database which  i have created for my IT
A2 Project.
i have a no of delete and append queries which are run together as part of a
macro, but the problem is that i dont want to append and delete all od the

To whom it may concern:
I would like to request an Access feature.
I would like to request a window that shows the status of an Access query in
process.  i.e. data load in progress, calculation in progress, processing

I have scores for given records for a particular date:
3/15/07  67
4/1/07   43
1/15/07  56

I want to be able to query a date field with the result being the record
closest to today's date.  Is there a way to do this simply?  
Thanks,
Kim

I have a query built in the Access query builder and I have noticed some
strange happenings.
My query has 2 sets of criteria separated by an OR (somthing like this: ...
having ... and..., and... OR and... and...)

Hello Everyone...
Has anyone here ever worked with an ACT! Database?  I think ACT! uses SQL. I
would like to find a way to link my MS Access Database to ACT! 2007.
Any takers?

Hello everyone...
I have column of prefixes that I need to append numbers too...
My column currently looks like this...
787-222

A simple select statement is  taking 5 minutes to run in SQL Server.  There
are no sorts, groupings or where blocks, simply a Select Field1,Field2, ....
From Table.  The table contains 606,775 records.  When a query is run from
Access that uses a linked table to that table in SQL ...

I need to either trim or replace this number: (386)851-0090
to look like: 3868510090    (no dashes or ())
Any help will be appreciated.