Could someone please post back example SQL to retrieve the field names in an
Access table (i.e. not DAO and not ADO, but SQL)?
Is it possible?
Thanks in advance.

If I run this query alone I can click on the PaidFromQB field and it will
update.  When I create a form, based on this query, I can not click on the
field and update it?
Any ideas would be appreciated.

I have got a field called "amount".
Currently it holds the following values 61025, 68653 etc
Is there any built in function which I can use to fill the field with
leading zeros?

Hello all,
i haven't been to newsgroups in a while, but a lot has changed!  Anyway, i
have a field in a query which contains numbers ranging from -100 to 100.  I
would like to filter out some of the numbers.  For instance, i would like to

I would imagine that it would be a crosstab query but is there any way that
I can go from Input A to Output B:
Input Fields:
Name (Text) - Any name

I have searched discussions using search terms like "simultaneous",
"simultaneity", "events" and others, but haven't run across a discussion of
what I wish to do.
I have a database that keeps track of cases.  Each case lasts from minutes

Access XP, Windows XP
I have a select query.  In the criteria field, I want to use whatever is
selected in an unbound combo box on a form.  The name of the form is
frmSenateReports.  The name of the Combo Box is Combo37.

Wondering if someone could assist an Access beginner.  I have two tables with
a one to many relationship.  I am trying to set up a SQL Query that selects
only one record from the many table but usually get multiple records from
table two

I have a parameter query that I would like to simplify so that I wouldn't
need to use wildcards when entering in partial data. The following line is
in the criteria field when designing the query:
Like [Enter last name]

I have a pretty large query that is joining 5 tables in my
Access 2000 database. When i run the query one of the memo
fields (the only one in the query) is truncated to 255
characters when the query is displayed.

I have the need to be able to have many users open a access db that only
contains a passthru query to a sql server. I do not however want to have to
visit each machine to install a DSN entry. Is there a way to do this?
My SQL7 server is named Radical if that will help in the coding. ...

  Its is possible to use it with MSADO 2.8?
'coz I saw and sample, but it use 2.6.
does anyone knows about it?

Just when you think you've seen everything.
I have a query that's been working ok as the datasource for a form. Now I
want to filter that query using a  "Where" clause string that's
concatenated when the db opens. I added a query to the form's datasource

I have a table of raw data containing some records with identical data.  I
have a second table with those records after a transaction number has been
assigned.  I want to update the first table with the transaction numbers.  
However, I keep getting only one transaction number ...

I have a question about queries in an Access Database, I'm using MS office
2000.
I have this following data and I want to find a query that will show me any
records that overlap or don't match: