I use the following query to get the last order of each Cust ID with help
from Allen Browne's tips site.  Now my requirement is slightly different in
the sense, i need to have last order for each Cust ID for each Product ID
too.  If same customer has ordered 2 products, then i ...

I would like to find and replace several values in my Access table.
For example, I would like to change all "%40" to "@", but rather than
specify a single field/column of my table to search through, I would
like the code to search through all of the fields in my table (there

Hi, I have about 8 fields (all from the same table) and what i need is when i
change a value in one field is to have all the other values change to
correspond with the value that i changed.
Thanks in advance,

What are the exact situations where relationships need to be defined?  I had
a db with around 15 tables with various relationships setup.  I imported all
the tables, queries and forms to another database, as suggested for security
reasons.  Now in the new database, none of the ...

Hey, this is probably a really lame question, but I cannot seem to get the
clock (the one in the system tray) to display military time.  Any help would
be greatly appreciated.

I cant seem to send a power point presentation with my notes is there
something special i should do

I would like to add a space in front of my text data.
Old data:
E6789
34567

I have a database that pulls 4 records from a table.  These records can and
may be duplicated showing different dates.  Tried using a cross-tab query to
pull both records with both dates but it doesn't work.  
Does anyone have any other ideas?

I have a listbox on a form that allow multiple selection of row. The
rowsourcde of the listbox has 2 column, ID and AmountPaid (Currency).
I want to sum the AmountPaid of the selected item within a listbox. How can
I acheive that?

Users (18) have Access XP, network uses Windows NT 4.0, bk-end located in
network server.
Our system had been working without any problem for over three years. Back
-end Data got corrupted only once in those 3 years. However in the last 3

I have a table that includes an ID, a description and a check box. If I
check the test box it should make the description change colour.
Unfortunately the code I tried changes all the following records as well.
The code I tried was on the checkbox double click event and went ...

Access 2003-2007.  Is there a way for me to create an Access database
application and make it runable on the web?  I would host it on our web
server (Windows Server 2003 with Application Server).  Is this possible?  
Thanks for any help.  God bless.

I have a database with 4 tables. I want to enter the value for my primary key
field in a form and have it entered into all 4 tables. The relationships are
set up and the fields all have the same name. Is there a way to do this. Even
better, can I use the autonumber fieldtype in ...

hi when i attempt to send an email i get a window which says there was an error because i think my sending options are incorrect. how can i change the way my emails are sent thank you

The subject of this post basically outlines the question.  If I use a
Not LIKE [pattern] under criteria for a select query, will the query
pick up records with a NULL value?