i have a date/time field "EnterDateTime" 11/2/2005 3:38:00 AM
i'm wanting to use the expression
Shift:
IIf([EnterDateTime]>7,IIf([EnterDateTime]>15,IIf([EnterDateTime]>23,"Night","Evening"),"Day"),"Night")

I have imported a CSV file into a an Access table, but somehow the CSV must
have had too many commas on some records because extra fields were created.  
For about 20% of the records (total over 8000), the data for a certain field
is showing up in a bogus field.  How can I move ...

I have a simple first name, last name, address, apt, city, state and zip code
table.
Should a transit strike occur in New York I need to be able to offer my
organization with a quick list of staff members that live in the same zip

I have a table of staff information and i recieve a new feed every week, i
keep the previous list as a backup and then import the new feed. I would like
a comparison that shows me the old record and the new record to show changes.
Each person has a unique identifier, any ideas?

In TSO the comment indicator is '--' at the beginning of a line.  Is there a
way to add a comment line to the SQL view in Access?

I've programmed a button on a form to import data from a .csv and put
the information into a table called "tblImportedPrices".
The data being imported is price and performance information for
managed funds.

I'm trying to make a query using the 'In' operator in criteria, but I want to
use the values taken from a textbox in a form.
The syntax looks like :
(criteria)

Dear friends
I would like to find the first and the last element of a record in a table.
Is there any possibility especially if yoy have not promary key?
Christos

I have a report with three column's, each with a number value when selected.  
They are (1)Injury with a numeric value of "1", (2)Skin disorder with a
number of "2" and (3)Other illness with a number of 3.  How can I get a total
for each column?  I have tried this in the unbound ...

I have a table with about 6000 records.
Most are part of a category (about 20 different ones)
Some don't have a catergory assigned
Can somebody please explain how to create a query that:

I have two tables that I have joined together using a left outer join, is it
possible to show in the Cell where there is no match on the join some
specific text.
Thanks

Hello to everyone,
I have a database in Access with only one table. One of the fields, called
Name, contain the first and the last name. My problem is that some of the
names are in upercase mode. I want to change the uppercase mode in a form

I have a database for postage logs at my job.  I have over 60 areas that I
have to enter postage on for.  I typically enter the information at the end
of the month, but have information for every day that I need to enter.
Rather than having to enter the date for each area, every ...

I've created a report based on a query
Tables
MonthlyFigures-- ID, Date(mm/yyyy), Figures, Manufacturer, Store
Stores        -- ID, Name, Post Code

I created a calendar type crosstab query. The row header shows the "week
of:", the column header shows the day (Mon, Tue, Wed, ...) and I'm getting
the count of records as the value.
This works just fine, but to make things easier to read, I want to show the