Search results

Hi! O.k. this will take time to check as vba is not quite my strength and I am facing a very busy time at the moment. Thanks for helping!!!!!!!!!! Stefan

sorry, I'm not in office this week - will try the procedure given above next week. thanks for your help!

You're right, I'm not from the USA - but I'm sure you've heard from Austria (the little country which made 8 gold medals until now during the Olympics in Turin ;) I'll try my best: *) 9.15 is exactly what I mean *) we have designed an analyse db in access to provide some users with reports...

procedure: I run a query which writes the result sets into an existing access table in which I defined the columns as needed - here the first mistake happens - truncation of values (e.g. 158,45 --> 158,00), so actually within access; the "result" table is then exported by a macro and generates...

Access2000 converts data to Excel2000 in the following way: I have specified a column data type as long integer with no "null" decimal place - whenever I analyse the table with Excel the mentioned column suddenly has 2 decimal places?????????? On the other hand when I convert data WITH 2 decimal...

Well that’s exactly what we are doing right now - just trying to save paper as we use the printouts for validation purposes and therefore a solution would have been nice. Thank you anyway,… Stefan

Hi! We have a problem with analyse reports generated automatically since we are using Access2000. Attached to this mail you may find a screenshot of the desired report. When we try printing query analyses with the sql syntax exactly that happens (see attachment). Thanx for your help,... Stefan