I have a report linked to a query. When I run the query by itself it pulls up
all records based on two criteria. When I run the report, it only pulls up
one record according to the criteria in the query, and this record is the
last record within the table that satisfies the ...

I have tried to find a clip art suitable for an 80th Birthday but have had no
success. It seems that 30, 40 & 50th Birthdays are all that is covered. Can
anyone help ?

I have a query (which I have also done as a 'make-table' - if that makes it
easier) that I want to display on a form. The fields are Assistant, Sales,
Qty etc and I would like to display them in this format:
Assistant    10        11        12        13

How to culculate the Beta which is thw risk of the return for two variables
say x and y

I want to do a query in which, among all baseball players who've had 10 or
more seasons of 500 or more at bats, I compare each player's maximum home
run season with their second highest home run season, to see which players
have the greatest "outlier" seasons (i.e., the greatest ...

New to access programming.  I'm using access 2003.
I'm programatically importing a FoxPro/Dbase table which I've managed to do
and I'll eventually want to report some findings to an access report.
However, in the interim, I need some help as to how I would programatically

I want to show demographics.  A table has data entered indicating; race,
gender, age, and other descriptive information of names entered.  How do I
sort in a report by each characteristic, then get a running total of each
characteristic?  For example, 54 black females, 202 white ...

I'm using Access with Office 2003.
I've got a key field defined as text and I need it to be sorted as follows:
00
0

Ok, i have formatted a time date field to short time, but i only want access
to display the hours part, e.g. 2 or 3 hours. As i cant format access fields
into an hour format, i want to create an input mask, or some validation to
only allow the user to enter the 1, 2, or 3 hours

In my query that picks 6 fileds ( keyword1, keyword2...... Keyword6,) Now I
also, want to merge them into  a singlefiled when I run  the same query, and
show them in on line coulum with no duplication.
thanks for your hlep.

I converted our Access 97 database to Access 2000 and made some changes to
the Design of the 2000 version (i.e. Added some extra fields, forms &
reports).  Now that the changes in the 2000 version are done, Can I copy the
data records from the 1997 database or will this cause ...

It did not creat a The only field and lined up all the records from the
list. insted it lined them up all together by record by record,
I want the end result look like his
CAT

I've been using Access 2003 for about a year now but would still consider
myself a new user.
I'm having a problem trying to create a query, if indeed the query is
possible to create.

I have been reading and asking about Access & SQL Server.
I hope this question is in the right newsgroup.
Using Access as frontend and SQL Server as the database I can link the
tables via ODBC.

Hello Group
I have a data base and would like to let those that visit my web site
do searches.
how hard is it what would i have to learn.