i've been struggling with this for a couple weeks now and haven't been able
to find aything in the foums on it.
k, i am try to make a query that will sort by date (only displaying the
parameter date), then count the results to show on a weekly report,

I am trying to figure out if there is a problem with my usage of MAKE TABLE
queries.
I have some data that consists of 20-40 records EACH of yearly records
sorted by YEAR. I have a  query that displays this data correctly SORTED by

My function in my report : "=Sum([CountOfEmployee_id]", which works
whenever a query contains records, returns the following when a query
contains no records: "#Error"
When I try:

Hi, All
I have table with a few fields of user's activities, it looks like foloowing:
IsDate   IsTime  Id   Unit  Activity     Code
5/1/07  8:00     614  01   SignOn      SO

I'm looking for a way to restate this: =IIf([Fall]="1","Yes","No")
so that if ANY listing for Fall is 1, then it will return a "Yes" value. Is
there a better way to do this?  It's being used in a report based off a query.
(Ideally, I'd like to update the base table with this info to ...

I need to delete accounts that the 3rd position from the left is a space.

Does anybody know how to calculate dates? I believe that it can be done
however, I am not sure where to start.
I have admit date and discharge date on several hundred records. I need to
get the number of days between admit date and discharge date per record_id.

I have a field in my database that i built the expression to divide by 2
other fields to give me my answer.  The only problem i am having is that it
will NOT sort by that field in descending order.  WHY???  Is it because there
is an expression with a result?  Is there a way ...

I need to create a query where one of the fields I need to query is a combo
box. When I look at the datasheet, the field show 1, 2, 3, or 4 which are the
4 choices. Is there a way to have Access show the actual choice i.e. complete
response, progression, partial response, stable. ...

I have a table from the Bank Of England giving me the names of all the people
who are not allowed to hold a bank account. I then have our customer list. I
have put them into to tables in access. I do I crossmatch between the two
tables to find identical names and bring them to a ...

Please can anyone help me with the following query:-
I am trying to create an inventory application in Access 2007.
I have created a Stock table (info stored on each shoe), a Warehouse table
(where stock is kept). A Transactions table (info stored on each transaction).

I have a query with the text fields
[Cparty Name] [CCY]
and value fields
[P & L] [CPrgm Fee] [Revenue reversal entry from previous month] [Revenue

I'm trying to filter records from a query.  The query was created from 2
tables - both with the same userid field but one contains the first/last name
fields and the other contains the hotel code.  I need all records in this
query to show if the user is associated to more than ...

I have two tables. One contains contact data and the other contains status
information that is related to the contact data. I need to be able to import
data into the contact table and create a default record in the status table
linked back to the contact record. Any ideas?

I am trying to set up an audit database containing info on QA and H&S. I
have a table for all the statistics so far recorded in a stats table. The
table also records the type of stat (QA or H&S) and the area it covers
(welfare, risk assessments etc).