This seems simple but I am hitting a brick wall.  I have a customer
visit table that lists each visit I make to a customer.  I want to be
able to run some reports that will show the last time (not each time) I
visited each customer.  My original thought was to create a crosstab

I have a csv file with a date field, how could I format this; 20061002120000
[0:GMT] into a real date like 10/21/2006 so access will understand it?

I have data generated from a query in the format below:
Hours | Month_#
------------------------
534 | 0

As a practice, I am working on a todo list web application.
I have MS Access database called Tasks.mdb, which contains a simple
table called Tasks that looks like so:
TaskID    Name                Completed

How can I count the number of records in a table so that I can use the
number obtained in a calculation ? I cannot use the ID autonumber for the
last record input as from time to time records get deleted and there are
numbers missing in the ID number sequence. I need to know the ...

flag1:iif(ht,iif(avg>t,iif(hu,iif(avg>u,3,2),1),iif(avg<t,iif(hl,iif(avg<l,3,2),1),1),0)
I put the above statement in the field of my query.  This statment is
supposed to determine whether the value "avg" is on target, within
control, or out of control.

I'm nearing the end of my project, and I have a query problem that is
holding up one report - the Business Sources report.
I work in a real estate company that tracks their business sources.
They have an annual report they run that provides the total number of

I'm a huge fan of these groups and hope you can conitnue helping me
out.
I started my databse with one query that had no parameters and copied
it a few times, rearranged the information, changed the name and

I'm having a problem with some queries i'm running. It queries on Stock
Code and some of the stock codes contain ". e.g MJMII1.5". I dont want
to eliminate the quotation mark because this may effect the accuracy of
my query. Any help would be really appreciated.

I'm trying to pull Access data for a web page.
I want a query that will pull all dates for the current month plus all
future dates.
For example, December 2006 onward to January or February 2007...

I would like to make a query on a table on one field to 'sum' or 'max' the
field based on 'if' another field is null or not.  Any idea on how I would go
about this?  Please be generous as I am not an Access expert :-)

I have 5 seperate excel file that I imported into access.  Now what I want to
do is 4 are where I want to search from.  So the first file I want to get a
query for mached numbers for matched and non matches.  Is this possible?
Chad

Hi every one, how can I make this happen?
I have a table like this:
Student     Math           English            DateTaken
Lisa          90              92                   10/01/06

I'm a huge fan of these groups and hope you can conitnue helping me
out.
I started my databse with one query that had no parameters and copied
it a few times, rearranged the information, changed the name and

I have a query that brings back data from two tables joined together on
StudentID.  The data is absolutely beautiful as long as I'm bringing
back all the columns as "group by".  However, when I change the hours
column to "sum", the SumOfHours is double what it is when the data is