How can I use a delte query to delete all records that begin with a certain
letter?

Hi gang - I'm concatenating several fields in a mktbl qry and to
preserve the data integrity, I need to make sure the new field will
have the data type of "memo"  (so I don't lose text!)
Is there an easy way to do this?

I have an expression which subtracts total debit from total credit for each
account group of transactions to give the balance in a calculated field
called Balance. i.e Balance: Sum(([CrAmount]-[DrAmount])) It works OK. But
now I want to make it conditional based on field named ...

I've got a tables/records that looks like this:
ID  Comments (memo)
1  <b>Task: <b>SEARCH</b><br> To: <b>EARL</b>
2  <b>Task: <b>FIND</b>

When I run my query to make a new table using the formula below (A) I retrun
a numeric value with varying number of decimals. The field properties in the
query are set to percent. When I try to format my results as a percentage the
query returns a text value (B). Is there a way ...

I've gone through the newsgroup and tried pretty much every suggestion, and I
still results that either include every record or none at all.
I have a table with eleven (11) fields plus Primary Key. The field ACCOUNT
is repeated in the table numerous times, and each Account record ...

I'm having trouble with duplicate records in a query. The purpose of
the query is to generate a mailing list for my newsletter.
I have a table Contacts, out of which I draw a query of those who
receive my newsletter. I have another table of Groups of which my

How can I make a query not show duplicate records?  Example, I have a query
that has one field which is "type" and it is assending.  Records one throught
five may be the same, say apples and the next few records might be trees.  
How can I get the query to only show one of the ...

Here is my dilema...
I have a table that has as three columns that has has one column of a
current value and another column with a succeeding value.  There could be one
or 100 rows that have a series of these of these chains.

How to fill a datetime field by sql statement, with hours and millisecond
...
i'd like to do something like update vTable set vDate="03/10/2007
10.05.01.444" ... it works without milliseconds but i need to fill

I am designing a database for a photographer and for each client I have a
table that will list family anniversaries (wedding, birthdays). For marketing
purposes I would like to have 3 months advance warning of an anniversary.
For example, how would I find out now that someone will ...

I want to create an autonumber field but have it go in groups of 10 such as
41770, 41780, 41790 etc rather than one number right after another.  It woul
also be fine to create a field that isn't autonumber but automatically goes
up by 10 every time there is a new record created. ...

I have a first qry that selects data on two date fields from a
form ..
the query selection criteria is >[Forms]![frmMenu1]![Startdate]
This works fine

I am creating a database of plans that uses mile points for beginning &
ending.  I want to be able to search through the plans for a certain MP.  So
if I want to search SR XX at MP 3.2, How would I get the Between ( ) Function
to work.  I tried to put in the query:

I'm trying to export mutiple tables to Excel. However, in some fields I'm
getting duplicate data. Is there a function that would filter out the
duplicate information?