I’m using:
Between [Forms].[frmReport].[Start] And [Forms].[frmReport].[End]
in criteria to input a date range into a query. The date is entered into the
form “frmReport” in the format of 00/00/0000.

I am trying to write a rule so my [ReceiptAmount] is >0 if my [Transaction#]
starts with 70 or my [PaymentAmount] is >0 if my [Transaction#] starts with
19. Can anyone please help?

sunnyburnoliver@clearviewcatv.net

Is it possible to easily set an option group value to a value that is not
whole a number - e.g. 1, 1.5, 2, 2.5?  I would like to use an option group
for a likert scale using a tablet PC but cannot seem to get throuh this
problem.

I have notice the last few days when I export a form or report I have changed
to another mdb that ALREADY HAS THE SAME FILE, I am not getting the "you are
about to overwrite" warning. I have always gotten it in the past and it seems
like since patch Tuesday it stopped. Anyone ...

I have two tables one has First Name and Last Name fields. The other has
first and last names combined in a "Name" Field. I would like to combine
tables via a query for sorting and mailing purposes. This problem sounds so
simple, but it is beyond me!!!!!

Is it possible to delete the data contained in an excel worksheet from Access?

nach vielen Versuchen mit verschiedenen Anleitungen habe ich endlich eine
nicht löschbare eMail im Posteingang wegbekommen.
Allerdings erscheint jetzt nach jedem Öffnen von WindowsMail der Ordner
"Wiederhergestellte Nachrichten". Selbst nach dem Löschen des Ordners bzw.

What I want to do seems pretty staight forward but in Access is seems so
cumbersom.  I cant understand why - I must be doing something wrong.
I have a table = "TableA".  With 10 columns and ~1500 rows.  All I want to
do is sort by Column 1 Ascending and then Column 2 ascending.  ...

I have a clients table on which I want to run a select query on to extract
all fields. But I also want the result-set to be grouped by Company and
Postcode to remove any duplicates. The reason I don't want to include other
fields Address line 1 etc as there could be minor ...

I was wondering if Access had an automate update log that could be
turned on that would log any changes that were made to record. If this
is not a feature that Access offers does anyone know of a Macro that
could help with this?

We have an in-house access app which runs on windows LAN. We are looking for
an email newsletter mailing solution that can work with contacts data from
the access app. Currently I am looking at this;
http://www.constantcontact.com/index.jsp. The problem is this does not

Help.
I have a Contact management Database in Access, together with various
information including email address.
I want to be able to click on a contacts details and it opens up Outlook, in

I inadvertently did something, now my photos are printing all pink/reddish.  
How do I get rid of that?

Is there a way to create a new line when merging two text fields in a query?
Something like vbCrLf