Every night I run a series of make tables that are based on some
transactional tables.  The field in the transactional table is formatted as a
number field which I cannot change.  I created a make table called
QuarterlySales that has the customer name and their sales which is a ...

OK. I have a crosstab query that needs to show the project name across the
top, people's names down the side, and the time on each project in the
middle. Along the side next to the person's name, I have the total time spent
on all projects for each person.

Access 2K/Win2K. Field has date/time data type. Data is only date - no time
included. Using the criteria: between date()-1 and date() but getting error:
Data type mismatch.
Any suggestions?

Im sitting at home creating a Database using MS ACCESS 2000.
i would like to use some of the dao commands in vba to create & run SQL
statements. So, i was told that i would have to go into Tools>References and
click on.....

In my DB I have a table that contains for each date the price returns
of a set of stocks:
example:
DATE, STOCK LABEL, RETURNS

ho ho ho ho
  The primary key as autonumber in the my table was out of order and the
program is to close and not save.
  The form input data from the source of the 'mytble' named

How can I take the results of a query's email address field and lump them
together separated by semicolons so that they are ready to paste into the TO
line of an email?
Thank you!

I'm trying to use the calculated value from one field in my query in another
calculated field within the same query. The first field calculates a number
for me; the second strings together the values from that field with another
(i.e. Expr2: [Field1] [Expr1]). My problem is that ...

How can I force queries in Access 97 to use binary string comparison (as in
an unmatched query) instead of case insensitive?

I have
ProductID     Qty     UP
75                  20        4.9
75                  30         4.8

I want to create a query where when you run it it gives you a pull down menu
to choose the data to query it by. Basically I want the dialog box to have a
pull down menu as opposed to just typing in a test criteria. This will help
my users to choose a selection if they don't know ...

i have the following table
year     # loans      type        percentage
1982        5           conv
1982        4           fha

I have two columns with the same data type of OLE Object. Is that possible to
update one using the other? The following gave me an error:
update table1 set colOLEObject = (select colOLEObject2 from table2 where
tableID = 1)

In a query I've
Count(sold) as yr_total
Salesman_ID
Sum(cost) as in_total

Hello!!
Sins I´m using a swedish Access 2000 I don´t know the english word for the
different expressions but I will try to explain my problem the best I can
and I hope that someone can understand and give me a hint.