...Relation with tables problem (continue)

Hi Kon,

I think you will find this article by MVP Allen Browne most helpful:

International Dates in Access
http://allenbrowne.com/ser-36.html

Also, in a previous message in this thread, you made the following statement:

"I have the table headmaster with 2 primary keys customerid and date Another
table master with 3 primary keys customerid, date and work description"

A table can have only one primary key. A primary key can be made up of one
or more fields. When more than one field is involved, we call it a combined
field primary key.


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"kon" wrote:

I found the problem but how can I fix it.
In the headmaster the date entered as dd/mm/yyyy witch is ok for me. Greek
date format. But in the variable
when I tried to create the sql string is mm/dd/yyyy. How can I change it to
dd/mm/yyyy ; shall I use the format function? or do i have to check an
option in Access