access17401
Registered User.
- Local time
- Today, 15:07
- Joined
- Aug 24, 2017
- Messages
- 33
Afternoon
I have made a query called "NAB Export Query", to send out a text file.
I have then created a command button on a form to run the export, with the following code:
Private Sub Command101_Click()
DoCmd.TransferText acExportDelim, , "NAB Export Query", "NAB.txt", False
End Sub
I have come across two stumbling blocks. In the query I have a field called Amount, this amount could be $150.50.
But in the export i need it to be in cents without the $ sign. The only thing I could think of was to create a
field with "Expr1:[amount]*100 which has an output of $15050, how do i go about removing the $ sign?
Secondly, I have done a lot of research but have found out how to do this, I want to define the export location to
C:\production but can't work this out either.
Any help will be greatly appreciated.
I have made a query called "NAB Export Query", to send out a text file.
I have then created a command button on a form to run the export, with the following code:
Private Sub Command101_Click()
DoCmd.TransferText acExportDelim, , "NAB Export Query", "NAB.txt", False
End Sub
I have come across two stumbling blocks. In the query I have a field called Amount, this amount could be $150.50.
But in the export i need it to be in cents without the $ sign. The only thing I could think of was to create a
field with "Expr1:[amount]*100 which has an output of $15050, how do i go about removing the $ sign?
Secondly, I have done a lot of research but have found out how to do this, I want to define the export location to
C:\production but can't work this out either.
Any help will be greatly appreciated.