I have a table and a couple of the columns are "memo" data field types. Now,
when I'm querying this table, the memo fields get cut short in the query
after acertain length. I s there a way so that this will not happen; so that
I can see the whole field.

can someone tell me how to return a line in my query that shows the first
number in this field : S-7L/8L
result = 7

How can I select the records that fall in the re-order level from a
calculating field (sum in-sum out)showing the stock balance in an inventory
database?? I, m wrestling with it few days now unsuccesfully.
Thanks

We have a database of football players. One of the data fields is "Jersey
number". How do we write a query to list out all players with an Odd jersey
number.

I have a table that has fileds called customer_id and month_invoice.
One customer can be many months of invoice, but I want just the customer
that has one month of invoice.
Is this is possible using the query in access ?

I have a table that contains first names and last names in different
fields. Is there any way to write a query that will give as a result
the first name and last name in the same field?
I hope this makes sense.

Person born on 12/11/1998 and I need to calculate their age in years (rounded
down) on 22/08/2006. If I use the DateDiff function
(DateDiff("yyyy",[DoB],[StartDate]), it returns the value of '8'. Using
DateDiff in Excel returns 7.78 years as does (StartDate-DoB)/365.25...

Hi, i'm relatively new to Access to will just have to describe this problem
in my words - hopefully someone can help!
i'm dealing with a recruitment database for a study. in one of the forms on
the database there is a drop down box which displays the site the person was

hi community :)
Condition:
Every paper there are more than 1 author
trying to make queries based on 2 queries

is there any way to create an autonumber down the side of the fields in a query
please help
thanks so much

Below is the SQL Statement of my query.I sort the Fields
HEIGHT descently,But I want the query return the 10 Highest
only.
Is there some body would like to help,how to do that easyly.

I am having great trouble with what I thought would be a simple query
and hopefully there is someone out there that may be able to shed a
little light on my problem.
I have (among many other things) a table in my database which lists

I'm trying to run a query with the 5 fields, and I want the query to use only
the last entry of the 5th field. I know how to bring up "Totals" and use last
for that field, but the problem is I'm getting duplicates, and it's showing
previous entries for that fifth field.

I am a new access user and haveing problems joining tables into a query.
table A is a list of engineering spec numbers and ES_id
table B a list of details pertaining to the ES (namem rev, etc)
table C is a list of procedures numbers pertaining to a ES.  This table can

Currently I have a query that states Nights:[CheckOutDate]-[CheckInDate].
The problem is that I am putting a parameter of Between two dates in the
checkin field.
Nights: IIf(DateDiff("d",[CheckInDate],IIf([CheckOutDate] Is