How do I query the maximum size of the contents of a given text field?  Also,
any suggestions on how to write a query to return the maximum size of the
contents of each text field in my database?
I'm using Access 2003.

I currently have a database that contains some information such as:
File number, date ordered, date closed, gross income.  I have two queries
that I would like to combine, the first is as follows:
SELECT Year([OrderDate]) AS [Year], Month([OrderDate]) AS [Month],

Here's my challenge:
I'm processing a customer info file with your standard demographics -
first name, last name, age, address etc.
The last name appears in all of the 'last name' fields; no problem.

I have a subform which is filtered based on the main form. The subform
is based on a table, which holds the primary key of the main form
table as a foreign key. The default sort is ascending (by autonumber
primary key in subform table). I would like to sort this descendingly.

I have an access database with a customer table listing various details, such
as customer ID, Name, date joined, main contact, etc.
I need to update specific information, for specific customer ID's.  I
therefore have a maintenance table showing the records (by customer ID) that

I have a make table query. One of the fields has the following expression:
“Total : IIf(Nz([Sum Defects Current Month].[SumOfDefects])=" ","0",([Sum
Defects Current Month].[SumOfDefects]))”.  
I set up the field parameter in the query to a general number.  

My nested query is giving me the Access 2003 error, "At most one record can
be returned by this subquery."  So obviously I didn't choose the right kind
of nested subquery because I need to be able to return more than one record.  
The purpose of the query is to find employees on ...

Hello I am using query with excel to copy columns from an excel file (lets
call it f1) to another one (f2).
It works fine but when there is alternatively figures and letters in the
column rows in f1 query will only import either figures or letters or cells

I have two tables: my main table and a cut-down version of the main
table with newly updated values:
Main
-------

I have an AS 400 ODBC file with multiple sku's and prices with various dates
stored as YYYYMMDD           
I want to select ALL sku's but only the "Last" price within any given sku
PER YEAR           

I have a make table query. One of the fields has the following expression:
“Total : IIf(Nz([Sum Defects Current Month].[SumOfDefects])=" ","0",([Sum
Defects Current Month].[SumOfDefects]))”.  
I set up the field parameter in the query to a general number.  

Is there a way to design a query so that it will query fields that ONLY have
information in them? .. I am trying to weed out my records of employees who
DO NOT have email addresses? .. I would appreciate the help :) ..
Many thanks!

My client has a few dozen queries, most of which prompt for a date
range. The current solution is to use:
SELECT ...
FROM ...

I am attempting to rank values and assign a number to each.  I have sorted
the values assending, but I can't figure out how to start the first record at
1 and add 1 to each record until I get the maximum number.

Hello every body..
I have apb in my DB. I designed a DB in Access and all stuff is ok. But nwo
i want to give serial number to my records also. Yes i use the auto number
utility but the auto number it gives form 20 and onwards. bc i have already