Re: UPDATE QUERY - DECIMAL PLACES ... I suggest you need not bother with formatting the data in the table in the ... Another consideration is that your update query changes all the data from ... I cannot see how this can be happening - your FORMAT statements look OK. ... created an update query to fix this problem. ... (microsoft.public.access.queries)
Re: UPDATE QUERY - DECIMAL PLACES ... I want to pull from using queries,... queries so it display the right number format, however, some of the fields ... The update query worked well and every fields hold the right decimal places, ... queries to display the data the way you want. ... (microsoft.public.access.queries)
TXT file Import - Date / text field conversion ... I have a csv that I am importing into an Access 2000 DB. ... I tried an update query whereby I created a new date field called First ... I also used the custom format of "ddmmmyyyy" in the table design format... (microsoft.public.access.externaldata)
Re: parse some text from an inconsistent text field ... Re First Scenario... I need to construct an update query using some fairly bad/dirty data (at ... sometimes it is in zip+4 format, ... The Len function won't work, ... (microsoft.public.access.queries)
Re: Importing with the right format conversion ... use yyyymmdd format so that you do not have to write code which first will ... fields into an Access Text field and then do an update query to insert the ..."Steve" wrote in message ... > from the text file in the format dd/mm/yy,... (microsoft.public.access.externaldata)
