One query pulls all info from field[co-number] and then field[divn-number].  
(co-number is Company Number and Divn-number is Division Number)
I need to pull multiple divn-numbers from the [divn-number] field. What I
mean is when I hit the button it prompts what co-number, I enter ...

Is this query as efficient as it could be, especially the "WHERE" clause?
PARAMETERS DATETO Text ( 22 );
SELECT CUSTOMERS.CUSTNO, (CUSTOMERS.LNAME+", "+CUSTOMERS.FNAME) AS CUSTNAME,
AgingSummary_Charges.CURCHRG-AgingSummary_Payments.CURPAID AS CUR,

Hi, I need my query to prompt the user to type what they are looking for as
criteria.  I have done this before by typing the message for the criteria
promt in speach marks such as: "Please Type Name" but this doesnt work i
think i need to type a word before it but i cant remember ...

I have an database I use to summarize time cards for my company.  This
summary is then sent to to our payroll processors ( another company).  I use
the employee id as a primary key in the following tables:  Employee, Time
Card, Stat Pay.  Unfortunately the other company sets the ...

I have a query that essentally pulls loan and deposit activity for the most
recent quarter from a table. The query totals some of the activity for the
entire quarter, and is *supposed* to pull the most recent month's numbers for
Deposits Outstanding and Loan Portfolio Outstanding ...

I have a Table (Mdef) with columns (Measueres and BuildingS) containing
Buildning numbers that are comma delimetered AND also includes Arrays
like=>
Measures: BuildingS

I would like to be able to convert URL text like http://google.com into an
active url.  The text is in a memo field of a table.  The text is updated in
the table via cut and past from word or word perfect.  The memo field is
viewed on an html page along with other fields via asp. ...

I have two tables. I need to extract the last 4 digits of the SSN from table
A to a new column in table B. I have tried Right([SSNFieldName], 4) but could
not get it to work. Any suggestions would be appreciated.

I have an unbound report with 3 subreports. The source for all the subreports
are crosstab queries. The data for the crosstab queries are 3 select queries.
If I put month(now), month(now)-1, and month(now)-2 in the select queries it
works. Is there anyway to pass parameters to ...

I would like to merge several spreadsheets (each with several tabs) into a
single table.
I know that I have some duplicate records, so I would like for the query or
process to remove duplicates.

I have two databases linked by ODBC to two separate file libraries on an
AS-400.  The file structure in both libraries is exactly the same, but the
data is different.  I only want to maintain one database, so I usually update
database 1 and then copy any of the queries, reports, ...

I have created a small Access database that has at present only two tables. I
would like to find all the records that appear in one table and the other as
identical matches i.e. identical postcodes in both tables.
How do you find all the records that appear in both tables?

I have a query with the fields "Spouse Name" and "Spouse Date of Birth" from
a another query called "Families. There is also another field called "NEWMG
Spouse Premium" from "NEWMG Premiums" query. I would like to make it so if
the "Spouse Name" field is blank the "NEWMG Spouse ...

Hi: I have 2 tables in a db.  Each one has the same 2 Field Items I am trying
to compare.  Basically the entry table where the 2 Fields are entered need to
be compared against a master table to see if they exist.  If they do not
exist I need the query to tell me that these 2 ...

Is it possible to use some sort of Top property or another command to
limit the number of records per column?
For example:
In this query...