A table has several hundred records with populated date fields.  However,
Parameter queries for records based on particular dates results in zero
records.  But, if I reenter the dates, then the parameter query works fine
for the rentered dates (and for records with recently ...

Believe it or not, my company places an asterix (*) after the name of any
account in our list of accounts (in SAP) that is no longer active. I need to
filter these accounts out of my query but I can't seem to do so using <> Like
"*" because that would just show all accounts. Any ...

Hi, I know I am repeating same questions.  I have been trying to use other's
SQL but it is not working for me.  
I have a table with:  CCC,  90+ $, CustomerName
CCC Consist of (ATL, HOU).

I have a data base with items sold per location.  I have an expression where
I calculate the net sales and cost of goods sold.  
I want to subtotal by location and calculate the overall cost of goods sold
by location, not by item.

I am using the following code (gleamed from this Newsgroup) which
calculates financial years (1 April - 31 March).
Financial Year:
IIf(Format([LOOAcceptedDate],"m")<4,Format([LOOAcceptedDate],"yyyy")-1

I am trying to design a form that will be used for the criteria of a query.
What I want the form to do is create a list of files and have those files be
the criteria.
The query has the fields: FilePre, FileNum, FoldNum

I have an sql query that finds dates between two specified dates. Query
works fine with start date that is it starts printing or retrieving records
from the specified start date but it does not recognises the enddate that is
it proceed further ahead the enddate.

I have two queries, each of which is based on different combinations of
tables.  Each allows the entry of new records.  The fields returned by each
query are common to both queries, but the records returned are different
(because of the different table combinations).  I would ...

I am using access 97.  In my reference field, the reference I type into the
field is month & number & year the numbers start at 1 each month eg
(July01/05. july02/05)  The paramentor I have set up is: eg
Like [Please Enter Serial Number July*05]   This runs only one month off at

I have a table that collects employee time in various blocks throughout the
day (an employee may have 4 time entries in a single day).  I would like to
generate a query that shows total time worked by week for 2005.
Each record in the table includes EmpNo, Date, Hours.  I would ...

Sorry for the cross post but don't know if this is an Access or server
problem......
I just moved an Access 97 database from an old WinNT4 server to a new
Win2003 SBS server.  Now when I run some of the queries on the new server

I have a table NRL_Performance to hold the performance data of various
investments. It has the following structure:
ID
NRL_Date

I have a file that contains multiple duplicate records except that they have
a unique key.
i.e. multiple row number /seat number   and EVENT NUMBER
When I create  a query of and ask for the EVENT NUMBER as the criteria - I

Hi there I have the following query
Sales      PART      QTY   RATE   CUST NAME  VALID FROM_VALID_TO
NA         VFD2     100     1.2       XYZ             20040923  20050403
NA         VZX2     150     1.0       TEST           20040923  20050403

Is there a way to query one SQL database for ex: Customer name, balance etc
and query a second SQL database to pull some historical data ie: Customer
balance based on the criteria set in the first query?