Ajuda - Busca - Membros - Calendário
Versão Completa: Exportar Arquivo Texto, Mascara Para Valor Monetário
Fórum Ativo Access > Componentes do Access > Tabelas e Relacionamentos
Mrsilva
Ola pessoal.
Preciso de ajuda, procurei aqui no fórum e em outros lugares, mas não consegui fazer o que preciso, se alguém puder me ajudar fico muito agradecido

Tenho uma tabela vinculada a um arquivo texto (.txt) os dados referentes a valores de notas fiscais são importados com 13 dígitos, exemplo 0000000119900 que representa em numero padrão 1.199,00 após fazer a atualização da tabela vinculada faço uma consulta de acréscimo que joga esses dados em outra tabela, mas o campo que contem o valor que esta em texto não estou conseguindo transformar em numero, exemplo 1.199,00 já tentei criar mascara de entrada, mas mesmo assim não consegui.

Caso alguem puder me ajudar fico agradecido.
Roberto Pires
Se os 2 últimos caracteres desse campo são utilizados para a casa decimal, mesmo quando for ",00", crie o campo a seguir na sua consulta acréscimo:

ValorNF: Cdbl(Esquerda([SeuCampo];11) & "," & Direita([SeuCampo];2))
Mrsilva
QUOTE(Roberto Pires @ Jan 14 2011, 12:42 PM) *
Se os 2 últimos caracteres desse campo são utilizados para a casa decimal, mesmo quando for ",00", crie o campo a seguir na sua consulta acréscimo:

ValorNF: Cdbl(Esquerda([SeuCampo];11) & "," & Direita([SeuCampo];2))


Obrigado Roberto.

Consegui o que precisava através da sua dica, mas quando eu exportava os dados para outra tabela os dígitos decimais ficavam todos com dois zeros após a vírgula (,00) Será que é por que quando fui criar o novo campo que você orientou - ValorNF: Cdbl(Esquerda([SeuCampo];11) & "," & Direita([SeuCampo];2)) a palavra Cdbl mudava automaticamente para CDup? Para resolver esse problema fiz a consulta de acréscimo para nova tabela sem acrescer o novo campo (ValorNF), criei esse campo na consulta da referente a nova tabela.
Apesar de ter resolvido minha questão, se você saber porque não transporta corretamente poderia repassar para mim.

Desde já agradeço.
Doxbrieree
khrr celebrex 200 mg musewejb celebrex 200 mg kqkp, celebrex200.lo.gs riugkifq.
Doxbrieree
zwji what is celebrex yrytotlf celebrex medication kkun, http://celebrex200.lo.gs hclshboc.
Bousasksnub
This post will report how to go about locating the optimal Lakeway eyes middle by using an array of over the internet systems. While using the ways in the following paragraphs, you will be on the right path to looking at
norsk casino

the various Lakeway eye facilities and finding the optimum facility on your vision.
online casino

When it comes to searching for medical care, it's normally significant to obtain the the right way physicians for all our healthiness. Considering that, there aren't many things which happen to be more vital than our overall health, and
casino reglerne

this is especially valid for our own view. We trust in these people to see day after day. Shouldn't we have the optimal attend to our eyesight? This article is aimed towards those of you who are searhing for the ideal eyesight facility in Lakeway area. You will understand just how to go about finding online the Lakeway eye center that is right for you, by the end of this article.
nettcasino

When working any internet search to get the best of something, it's never fail to vital that you
gratis casino spinn

initial know what your options are. Your first intention in locating the optimal Lakeway eyesight locations will be to original become acquainted with the various features which may be used. In the end, you don't wish to leap on the firstly eye doctor Lakeway which you
netent casinos

get a hold of. So, by developing a list of the many different eye doctors that are available in the Lakeway area, start off. One can learn about the various solutions which can be found by executing crucial lookups on google, along with evaluating commercial blogs like Angie's Checklist. In the
norsk kredittkort casino

60 minutes, it is best to speedily have a directory of the various attention doctors that are widely available.
casino bonus norge

The next step in locating the optimal eyeball heart will be to set out to researching equally medical physician separately. This can be accomplished
gratis casino spinn

throughout an array of strategies. To illustrate, it is best to center on looking through very own recommendations from beyond individuals, that can be found on a large number of
casino kortspill

company listing blogs. You should also evaluation the state site for each medical expert. In this manner,
gratis spilleautomater

learn in respect to the education and learning and connection with every single medical professional. Remove any doctors from your list that have a history of poor reviews. Alternatively, who you feel will not be a good match for you.
casino pa internett

The final step before selecting the best Lakeway eye center will be to contact any clinics that you remain interested in. Thus giving you an amazing possibility to construct a rapport on the center, and find out how cheerful or valuable they will be. In addition, it provides you the ability to

discuss with any extra inquiries which were not replied world wide web. This tends to put complications pertaining to your medical provider, together with ability period of time which you would be able to

also come in and talk with your physician. Most centers may well be more than prepared manage all of the questions or concerns, so it's vitally important to utilize this.
casino classic

Now, it is enough time to simply select the eye hub that you choose to look is the greatest. Have all of this exploration which you have handled and then use it
norsk automat

to pick out a doctor which will be best for your needs. In just a few working hours, you possess just made a decision which can likely benefit your little brown eyes for decades into the future.
casino red

Attempting to find some top rated your hair medical treatments for stopping hair thinning ailment? If yes then the secret is all here! Flowing hair

natural powder! An awesome method or it is possible to connect with a ace in the hole for lifeless and dull hairs. These superb foods are great for every last women and men for stopping the trouble of receding hairline, baldness or perhaps to
norske spilleautomater pa nett gratis

cover the scarring or bald sections. For the people battling for greasy hairs, this curly hair treatment method truly being a blessing in conceal. This happens because just one particular clean on their behalf per day is not at all acceptable. Within this strategy,

the situation might be remedied before you know it. This item is qualified to process the entire exorbitant oil and dirt in order to make your fizzy wild hair inside good shape.
gratis slotmaskiner

Hair natural powder is wholly consisting of very small micro fibers. They might put by natural means to every single strand of head of hair within the manner of fixed

power. This formulation actually works among the realistic and natural processes to hide out out your thinning hairs. The materials slowly but surely comply with a tress of 5 mls in length. It is recommended to keep the natural powder available with gel or hairspray.

Some Terrific Features of Using the Procedures
boyle casino
casino rewards
punti poker
maszyny hazardowe za darmo
bukmacherzy
kasyna w warszawie
casino bonus online
gry internetowe za darmo
vegas casino
mini roulette


Completely easy and simple to make use of.
y8 poker
boyle casino
poker time
newest online casinos
wirtualna ruletka
gry losowe automaty
online casino guide
promocje u bukmacherow
casino on line italiano
kasyna w warszawie


Is able to offer you thicker and fuller hair in exactly few secs.
gry losowe automaty
bukmacherzy
jennings bet
zaklady millenium
zaklady sportowe przez internet
swiss casino bonus
on line casinos
royal casino
poker time
online casino bonus


Can provide feel upto your roots making it possible for the hair color choice to go on for much longer time.
promocje u bukmacherow
american casino
newest online casinos
cleopatra slot game
zaklady sportowe przez internet
online roulett
roulette assault
zaklady millenium
roulett
kasyno wirtualne
Bousasksnub
This document will report how to go about locating the optimal Lakeway eyeball center while using a wide range of via the internet solutions. Making use of the strategies herein, you may be well on your way to evaluating
casino norsk

the many different Lakeway vision locations and finding the optimum center for that little blue eyes.
online casino

In regards to looking out for medical, it's commonly key to locate the most desirable health care professionals for your physical health. In any case, there aren't several things that have been more vital than our overall health, and
online casino guide

this is especially valid for view. We count on these to see day-to-day. Shouldn't we have now the most beneficial care for our little blue eyes? This information is targeted when it comes to those of you who want the most effective focus facility by the Lakeway field. You will understand just how to go about finding online the Lakeway eye center that is right for you, by the end of this article.
nettcasino

When accomplishing any searching for the greatest of an item, it's perpetually very important to
free spins casino

primarily know exactly what your options are. Your first agenda in finding the optimum Lakeway eye stations may be to very first fully familiarize yourself with the various alternatives which can be used. Naturally, you don't wish jump in the initially eye doctor Lakeway that you choose and
novomatic casino

seek. So, by developing a list of the many different eye doctors that are available in the Lakeway area, start off. You can study about the many different various options widely available by running general queries on engines like google, and browsing through organisation internet websites like Angie's Identify. Within the
casino

hour or so, it is advisable to effectively have a long list of the many different interest medical professionals that are available.
casino bonus

The next step in locating the optimal eyesight facility is to come to investigation every individual medical professional one by one. This can be achieved
gratis casino

during a variety of practices. Such as, you should give attention to looking at exclusive testimonies from past years medical patients, that can be found on nearly all
nettspill casino

work itemizing web-sites. You should also analysis the state online business of every physician. By doing this,
spilleautomater

discover within the education and knowledge of any healthcare professional. Remove any doctors from your list that have a history of poor reviews. Alternatively, who you feel will not be a good match for you.
live kasino

The final step before selecting the best Lakeway eye center will be to contact any clinics that you remain interested in. Thus giving an incredible chances to come up with a partnership while using facility, and figure out precisely how friendly or handy they are. In addition, it will give you the chance to

question any other basic questions which were not resolved on-line. This could certainly contain factors with regards to your health care provider, as well as a ability period of time that you really would be able to

can be found in and consult the surgeon. Most clinics may be more than willing to home address your complete requests, so it's necessary to employ this.
maria casino

Now, it really is the perfect time to decide on the eyesight facility you ought to get is the greatest. Choose all of this studies that you may have executed and use it
norske automater

to purchase a doctor which will be best for you. In just times, you may have just created a conclusion which will certainly probably perk you and the eyesight for years to arrive.
casino red

Seeking out some advisable head of hair treatment methods to cure baldness hassle? The secret is all here if yes! Frizzy hair

powder! An amazing technique or we can speak to a ace in the hole for dull and lifeless hairs. These very good solutions and products are great for almost every men and women to stop the matter of receding hair line, baldness in order to
norske spilleautomater

cover up the scars or hairless spots. For anyone hurting for greasy hair, this curly hair medication is unquestionably say for example a great thing in disguise. For the reason that just one rinse out for the children in one day is not enough. Using this formula,

what the problem is is often settled in no time. This remedy is eligible to digest each and every too much oil and dirt making your fizzy curly hair on a good condition.
slots spill

Head of hair natural powder is absolutely made of little micro fabric. They will adhere of course to each and every strand of frizzy hair using the manner of static

electrical power. This method really works among the realistic and natural processes to obscure from the thinning hairs. The materials step by step remain faithful to a tress of 5 mls in size. It is recommended to retain the natural powder in its place with gel or hairspray.

Some Terrific Potential benefits of Utilizing the Proper care
paradise casino
bukmacherzy
mini roulette
american casino
darmowe pieniadze
punti poker
gry darmowe hazardowe automaty
poker time
roulett
promocje u bukmacherow


Astonishingly simple and easy to put on.
profesjonal bukmacher
vegas casino
free online pokies games
burswood casino
jennings bet
casino mobile
poker time
y8 poker
zaklady sportowe przez internet
wirtualna ruletka


Will offer you fuller and thicker hairs in barely small amount of moments.
kasyna bez depozytu
free pokies no download
darmowe pieniadze
online poker bonus
gry losowe automaty
profesjonal
free online pokies games
roulett
online roulett
boyle casino


Affords stroke as high as your beginnings giving your hair color choice to last for a lot longer time.
bukmacherzy
free online casino
kasyno online free
milenium zaklady
kasyna bez depozytu
boyle casino
online roulett
maple casino
kasyno za darmo
wirtualna ruletka
Esta é uma versão simplificada de nosso conteúdo principal. Para ver a versão completa com maiores informações, formatação e imagens, por favor clique aqui.
Invision Power Board © 2001-2019 Invision Power Services, Inc.