I'm trying to print one label for two people at the same address following
the sample  given at  
http://support.microsoft.com/default.aspx?scid=kb;en-us;207753&Product=ass
for ACC2000.

I have data like this
03/14/05 13:09:42.0     0       CON
03/14/05 13:10:19.0     1       CON
03/14/05 13:10:21.0     2       CON

I receive an Overflow message when I try to run a crosstab query. The
strange thing is the query I am performing the crosstab off of runs fine and
other crosstab queries in the database with the same number of records run
fine. I do not know how to diagnose the error. Any ...

data = Year-1 is an amount or "N/A"
data = S1 is the sign +,-, or blank for N/A
I am trying to get around an error condition which comes up when I divide my
amount by 100 to get cents on my table.  I separated the sign from the

I am trying to rank players' performances by two different fields, for
instance if a player has 6 points, it then goes by his aggregate score. I
have managed to Rank the players by their points only, but I get a tie
between players. Is there a way I can Rank by 'PlayerPoints' and ...

I am working on a fairly simple database. I want the user to use check boxes
to select the fields to show in the query  which is linked to the master
table [tblMaster]. I aleready got the query to a point where it recognizes
starting data and ending data for the generated query. The ...

I have a Table that has a date format and it is using a short date. I want to
only see the month and year. I also want them grouped. Can someone show me
the light?

I need to add criteria to a query field so that the only records shown are
those for which 14 days have past from a date in a specific field. The
expression I am using keeps giving me a type mismatch error. How can I
arrange this expression to work properly:

I've pulled two tables (EIS and 06Hires) together in one query.  I want to
exclude all information for all ppl in 06Hires table.  I've right joined EIS
on 06Hires.EmplId=EIS.EmplID.  How do I go about setting this up in the
criteria?  Ultimately this query will produce a table ...

I have a table which contains a customer database. In that table are two
fields - STATE and REP. Our salesmen periodically need to view all
customers in multiple states and for a specific rep. I plan to create a
form that the salesman will open and choose his states and rep and ...

I need to get a count of how many calls a person logged by month.  My field
names are Staff and Call_Date.  I know how to get a count of how many each
person did all together using a date range but I dont' know how to do it by
month in one query.  My date field is in mm/dd/yyyy ...

I have a Querie that pulls the date from a table using a short date. I would
like to see only month and year. Can someone help?

Win 2000 Pro
Office 2003 Pro
I have a Redbrick data warehouse that includes a view of a table that has
181 fields in it. Using the Access Query grid, I get only 134 of these fields.

My code for a form requires 7 certain variables to be filled in:
Private Sub Form_Unload(Cancel As Integer)
   If Not (IsNull(Me.TR_CLOSEDATE)) Then
       If IsNull(Me.TR_DECISION) Then

Suddenly some of my file names are appearing in blue.  Why?  They are not
recently used documents.