Hi,
I have an excel spreadsheet that we use an Access macro
(TransferSpreadsheet) to import into a table in Access. When the data is
imported it is as text. I would like to change the date column from text

I am trying to build a query that retrieves record for any student who has
not attended our college in the last 6 semesters.  Currently, there is a
student table linked to a semester table.  Everytime a student enrolls in a
semester, a new link is created.  I built a query that ...

I accidentally checked the Attributes (Hidden) box from the file
Properties...how do I retrieve the file...
Where you have the Tables...Queries...Forms...Reports etc...I saved my file
in the Tables section.

I recall a "Having Count" query that will show when there are duplicates in a
table. I have a table that has a feild where we can have a certain value once
or multiple times. I only want to see when the value repeats itself, not when
it only shows once.

Simplified, I have a table with the following fields:
Staff_Name
Category
Hours

I'm trying to put together a tracking database for an internal
assessment system. Here's where I'm stuck:
Each question [Question name] we're assessing has scores [Score]
associated with assessment dates [Date]. Since scores can go up and

My job is sending me on a number of trips this summer so I created a simple
flat file table to track my expenses such as Airfare, Hotel, Train, etc. I'm
going to all of our regional offices and each one has a number such as 01,
02, 03, etc.

I have 250 school districts in my district field. All of them say Jones
School District or Smith School District. I want to return just the Jones or
Smith and not the school district. Thanks, so much!!!

Hi I am wondering if someone could please advise me on the following:
Below are two examples of iif statements driving two of many fields in a rec
query I have created. You will note the dates for the period are hard coded.
I would like to have the date as a variable which is ...

So i am attempting to create a complex query and i can't figure it out.  The
database i am working with has participants.  The records in our database
refer to students. For each record in our database there is information on
both the student's home and work addresses and which ...

Dates have been the hardest thing for me to pick up in Access. I don't know
why I struggle with them so much but they confuse me. I have start dates,
progress dates, and end dates. Projects start, have several steps, and then
end. So a project may start 1/1/2008, step 1 is ...

I need to split up  an email address that is stored in a table.  For example
if the data is "info@msn.com"  I want my query field to display "msn.com".  
What would the calculated field be?

My delete key is suddenly not working, is there any way to turn it back on?

I need a query to extract only that records which have a word "Transfer" in
remarks field.
Plz help me,
Hassan

I have a query as below and can't figure out what's wrong with it. It returns
only a '-1' if the conditions are true irrespective or how many cases it's
true in i.e. i made 2 records have the conditions of this query so it should
have returned '2' but it just returned '-1' ...  ...