I'm importing data as follows:-
0001,652.8655,349.5133,689.3182,468.6107
0002,822.5105,468.6107,861.7672,336.9030
0003,1020.1960,336.9030,1051.0406,505.0405

Using Access2003
this function uses the date format 02 febuary 2007 and returns the wrong
results
?Format(DSum("[TotalPriceIncludingVAT]", "tblExpenses", "[ExpensesDate] >=  

I have the following data, it can appear in two forms
1 / 1450040 / ROBINSON
1 / 29220
I need to split into three separate colums, I have tried to us in Instr and

I hope I explain this question clearly.
I am trying to determine if making a change to a database option
(through Tools > Options) will only affect the database in which I am
making the change, or if the change will be propagated to all .mdb

I have a client who I built a system for in Access 2003.  This user
has a need to transfer data to a show copy of the system.  They are
not networked nor can they be.
My model was basically that when she clicked on Export Data button it

Is there a way to have the cursor automatically to the left regardless of
where in the box you click?
Example:
If using the format ##/##/## and you click in the year area, the cursor

About 6 months ago i was using Access2003 on my laptop and i noticed that the
" and @ symbols had swapped keys.
Normal if you pressed Shift+2, you get ". I was getting @ instead
ans if you pressed shift+', you get @. I was getting " instread.

I have just upgraded to new PC, Vista, Microsoft Mail, etc. Do you know how
I can access my previous email folders, etc?

Sorry to cross post, but not sure were this should be posted.
I have upgraded from a2002 to a2003 and now have a strange problem. I have a
form that has a number of fields for ads the values of a number of fields
and displays the total results in a field. This all works fine on ...

Either Access 2000 is unreasonably difficult, or I am a moron, but I need
some help.  I have an unbound form that has a subform on it.  On the unbound
form I have two text boxes where I enter a start date and an end date.  Those
boxes are the controls for a query that displays ...

I've got several triplestate boxes in my database and want to set their
defaut values to null (greyed out) but don't know how.  I've tried using an
update query and setting the update to "Null" but this doesn't work and I've
also tried setting the default value in the table to ...

I am trying to calculate difference between two different times and
everything is ok if times are from am to pm on a same day.  How do I
calculate elapsed time between for example 02/14 10:20 pm and 02/16 9:30 pm?  
I created 2 text boxes (day in and day out) where I select ...

I have a report in Access 2003 that uses data from a linked Excel 2003 file.
My 'size' field can contain numbers or text (M, L, XL, etc). All number sizes
appear in my report but the text data does not. I researched and changed the
MaxScanRows to 0 but the problem persists.

I have a database that allocates people to jobs, which is based on the
Resource Scheduling database.
The form I use to allocated the names to the a job works by selecting
a name from a listbox then when I click on the command button it

I want to double check my data entry. I created a query, Column A contains
sums of records, Col. B contains amounts. I want to compare these two
numbers, row by row. In Column C I would like to have some kind of response
to alert me if they are not equal. Or have the response ...