Format in Access 2000 gives me a headache!

[dirkg]

I have two problems with the format in Access 2000:

1. none of the formats I use work in queries for example if I want the text-string 124534 be shown as 12:45:34 I used the format 00:00:00 in previous Access-versions which worked fine. In Access 2000 this does not work anymore and in fact none of the formats do work anymore (not in queries and not in table-definitions)

2. when I make an SQL-expression via code and I use the data-type doudble, I get an error because the decimal sign is converted to a komma which gives an error. I know I can solve this by changing the regional settings in Windows but I wanted to solve this via a format so that that error never occurs since I'm working on a client-server application and I do not want all the users of my application to make that change in their settings.

Thanks a lot in advance for your help!

Greetings,


Dirk

dirk.news@yucom.be

 

[Guiri]

I'm not sure I can help with that problem but I am having a similar problem.

I have a report, quite a complex one, calling on a variety of functions. The report onload runs a make query which creates the table the report and functions are based on.

It all works fine but now I want to change how some of the figures are calculated so I've created a new series of queries and for some reason the query has decided to produce the numbers in text format.

I have tried over riding this in the query by typing in General Number in the Format box for each column however although when you preview this it looks fine when you run it, the columns are created in text format again.

There is a major problem as the functions in the report get confused when they do get text as oppoosed to numbers.

Has anyone come across this before??