can you help me
this is what i have
address1
address2
address3
address1
address2
address3
address1
address2
address3
this is what i want
address1 address2 address3
address1 address2 address3
address1 address2 address3
I have a text file in this format:
Name: Bill Gates
address1:One Microsoft Way
address2:Redmond, Washington
address3:USA
and I want it in this format.
address1 address2 address3
One Microsoft Way Redmond, Washington USA
tblInvoice
TransactionDate
Locationid
Quantity
Price
Location
Customer ID
Sales Representative ID
Contact
Address1
Address2
Address3
Discount Price
Sale
Gct
Extended Price
Card Type
ItemCode
TransNo
InvoiceDate
Number of Distributions
tblCustomer
DigiID
Sales Representative ID
Customer ID
CWID...
I have the customer info in one table and the invoice details in another table. THe option I'm looking for is code to look at the data in the table and generate an invoice number for each set of customer transactions. Numbering of the invoice would normally be done in the application the...
I have a database that generates customer transactions history but no invoice no is generated for the transaction. I need to generate invoice numbers for each line item to produce invoices for the customers problem being a customer can have multiple items per invoice. How can I update the table...
Maybe I'm going about this the wrong way. I neglected to mention that I am new to VBA. The Trim function works when I use it in a SQL statement but it doesn't from code could you guide me.
I have a table in acces which is actually a transaction history report file from an accounting program. It contains all the transactions for the last business week. I need one transaction for each item where the cost is different. eg.
I have ten transactions for the item chicken breast. of the...
I am not sure if what I am trying to achieve is possible but here goes. I want to link to a group of foxpro free tables using VBA reason being the names and the number of tables I am linking to changes periodically so therefore I want to be able to link to whatever tables are within the...
I am not sure if what I am trying to achieve is possible but here goes. I want to link to a group of foxpro free tables using VBA reason being the names and the number of tables I am linking to changes periodically so therefore I want to be able to link to whatever tables are within the...