Hello.  I'm using Access 97.  I have a query used to export data to a .csv
file.  The issue our users have is that Excel confuses some of the data and
converts the type incorrectly.
For example - one of the fields in the query export is called 'phase', and a

Good Evening Everyone:
I am trying to logically think about what I want to do, but I can't
get it to work correctly.  I have a multitude of queries that list
retiree information.  The only thing calculated in the queries are the

how do i download microsoft access because i need it for school to do databse

I have a query which gives me in part the [JobNumber] and [PurchaseID]. What
I cant seem
to be able to figure out is the following:
If multiple records where  [JobNumber] and [PuchaseID] are the same just show

I've almost completed a database for my company to process Credit
Memo's. However, I have an issue which I've run out of options to
solve....
I have 11 rows of data in my table called 'Credit Memo Request'.  In

How do I frame a query that allows me to sum up the dollars spent with a
particular vendor or PO without repeating the field over and over?

I need help with a quey. First I have a table that has different columns, two
fields that I want to use are "CSR" and "Responses". these two fields are
lookup and linked with two tables.
Now i need a report based on query, where I can have CSR names on left, and

How can I run a Into query that contains a boolean field.
The field is always interpreted as an integer field?
ex:
Select TableA.*, false as testbool into testTable from TableA

I have a table with data like this
date          runnumber
1/1/2007           1
1/1/2007           2

For some reason referencing an unbound control on an active form from a query
has ceased to work correctly. While other previously existing references to
unbound controls in the same form seem to work fine new ones just return null
or if referencing a combo box some random ...

I have a database with 12 tables.  I want to do a simple query where I would
get the count of three different tables.
Count(TableA)
Count(TableB)

I am using the following query to return the minimum value for the "length"
field.
SELECT O1.pattern, O1.hole, O1.tag_time, O1.length, O1.rate
FROM penetration AS O1

I have a table where the DateStamp is imported from an external source as a
General Date (mm/dd/yyyy 00:00:00).  I built a query that has date
parameters, but because the date is not a short date, my parameters aren't
recognized.  I need a way to convert the date in a query to ...

I have two fields in my database, last and first
I want to combine last+first with a comma and a space in between them
Example: Hanks, Tom
How do I write a query for this?

I need some help writing a query that does a calculation with the lowest of
3 numbers.  Here is apart of the query that does a compare between 2 fields.
Here is what I came up with but I am getting an error.
IIf([SalePrice]<[AppraisedValue],[SalePrice]*[LoanToValue] ...