Hi guys, i am trying to get column information in an access database, is
there any one knows how do we write query on that?
what i m trying to do is to check on a table within the database, and
confirm that there is a column called "Name" and the datatype is text(254)

Ok, what a subject title. :-)
I am not sure what to call it, but here is what I want to do....
Query: AllOrders, about 9 fields, and 1 of them is determining what to pull
out.  It uses the BoatID (numeric) to get a list of all orders.  Example:

I'm trying to create a query using 2 tables with similar data, and 1 table
that contains a data map.
Eg. Table 1 = Users (Name, Surname, DOB, Status)
Table 2  = Persons(F_Name, S_Name, Birthday, Stat)

I have CustomerName query that retrieves the CustomerName, Address, City,
State, and Zip Code  from the CustomerName table.  CustomerName is a combo
box.  How do I get this query to put all the corresponding fields into a form
automatically after selecting a CustomerName from the ...

Good Day,
For your consideration I have the following question. Please notice the below
sample datasets....
Table A

Excel has a feature LEFT or LEFTB which only accepts a certain # of
characters from the left onward. It will turn 3115-TEYPl into 3115 by only
accepting the first four characters. Is there any way to do this with an
access query?

I am trying to write an SQL statement that is giving me some trouble, and I
was hoping that somebody here could lend me a hand.
CONTEXT
I am working in Access 2007. The tables concerned are the Students, Classes

I am attempting to compare two tables to find the differences. One table is a
compiled list of invoices billed and the other is my record of what we have
received. I'm looking to compare the two to find the difference. I would also
like to append the invoices billed with each ...

I have two fields that should match, but one includes special characters
while the other does not.
Example:
Field1 00ABCD123456123

I have a table (actually a query) joined to 5 other tables (mostly queries)
by two keys: ProjectID, and EquipmentID. While ProjectID cannot be null,
EquipmentID can.
The primary (driver) table contains a list of all project/equipment

I'm using sql 2000 and Access 2003. In Access you can run a Make Table Query.
Is there a way to do something like this using a sql View within Access?
Thanks for the help,
Paul

I am trying to run a query to find every instance that a number lower than
255 appears in a field for each record.  The query should run for several
fields for each record.  I have tried typing <255 in criteria, but I am
having a problem.  If one of the fields in the record ever ...

Thanks in advance for the assistance-the discussion groups have been very
helpful!!
I am trying to get the top 10 in a crosstab query to run a report.  I have
tried this several times and keep getting errors about the transform

I have a table that holds a master census date. I need to add this census
date to be generated in a field in another query, but obviously cannot
provide any linkage. Short of hard-coding this date (which changes every
week) I cannot get the date to be generated within the query,

I have a query in where I am tracking technician bonuses that are based on
the amount of units that they repair.  My formula is as follows:
Jan Bonus: ((([Jan]-[MinimumUnits])*[PerUnitRate])+[QuotaAmt])
In order to bonus, they need to exceed the minumum number of units required.