Can someone check my syntax please:
textbox control source: =DSum("[Session]","Clients","[session]='AM'")
Tablename 'Clients'
Field 'Session'

I have a database in msaccess with report.
I get records in form in sequency as I want.  But last record of the form
I get 1st in report.  How can I solve this problem?
a.kutty@mobily.com.sa

I have two fields - StartDate & EndDate.
Is there any way via a form by which I can insert the Start date and have
the EndDate field in the table
automatically updated??

How do you create a form that will search for items and display them in
datasheet view in a subform?  I have a table that has lots of data regarding
orders.  I want to be able to search via a PO number, Manufacture location
etc and the records populate in a subform.

I have inserted a calendar into a form in my access database.  I want the
user to be able to enter data into the dates -- like the calendar in outlook.
I know it would be easier to use outlook but my client hates outlook and
sharing the calendar with outlook has not worked.  Can ...

I'm working in a form with a combo field that grabs its data from a query,
and am trying to get the selection to auto-fill another corresponding field
on the form from that same query.  For example, here are some of the lines
from the query:

Hi. I'm attempting to create a db that is essentially like personal finance
software..
I need to be pointed in the right direction or find templates for MsAccess
2003

So I install a copy of MS Office XP I've had sitting on the shelf on my new
laptop, bring in all my data from the old machine (which was using Office
2000) and suddenly I can no longer syncro Calendar and Contacts with my home
computer nor my secretary computer's Outlook 2000.  ...

How do I open a form and not have any of the command buttons set to focus?  
I'm trying to open a type of switchboard where the user only has command
buttons to choose from.  I tried a text box with the same color background as
the form but i did not care for the blinking cursor.  ...

I've a form with a data entry field SelField and a subform. The subform
contains a combobox. Now I want to (re-)populate the combobox dependant from
the value in the Field.
The Rowsource Type of the combobox is Table/Query.

I would like to insert the button picture into a user documentation. I'm not
able to extract the button picture from Access. Can anyone help?

Can someone help with this iif statement in a query?  This is an inventory
database with two price scales.  Here are my variables:
IIf([Price Code]="Standard Pricing",[Sale Price])
IIf([Price Code]="GM Pricing", [Special Price GM])

Ok people i appreciate this might me a bit long winded but ANY help would be
appreciated.
i have a table called "Customer_Details" and i have 3 other tables calls
"tariff 1", "tariff 2" and "tariff 3".

I have my fields setup to make the first letter uppercase, however, it makes
all other letters lowercase (see code below).  Is there a way I can code it
to not change the case after the first letter...as in TX (abbreviation for
Texas), which now would appear as Tx?

I am using Access 2000.  I have a spreadsheet in Excel.  One of the columns
is zip codes.
Some of the cells in this column have 5 digit zip codes and some are the
extended ie xxxxx-xxx.