troubleshooting Question

Insert record into a query at specific points

Avatar of ACSPanama
ACSPanama asked on
DatabasesMicrosoft Access
13 Comments1 Solution320 ViewsLast Modified:
I am using access to reformat our online sales transactions so that I can export the data to a tab delimited file that is in the proper format for importing them into quickbooks.
I have a Query that gives me the results I need formated like this:

TRNS      DEPOSIT      02/03/2007
SPL      DEPOSIT      02/03/2007
SPL      DEPOSIT      02/03/2007
TRNS      DEPOSIT      02/08/2007
SPL      DEPOSIT      02/08/2007
TRNS      DEPOSIT      02/09/2007
SPL      DEPOSIT      02/09/2007
SPL      DEPOSIT      02/09/2007
SPL      DEPOSIT      02/09/2007

What I need to do is create a query that will insert  a record with "ENDTRNS" after each transaction or before each "TRNS" so that the query results look like this:
TRNS      DEPOSIT      02/03/2007
SPL      DEPOSIT      02/03/2007
SPL      DEPOSIT      02/03/2007
ENDTRNS
TRNS      DEPOSIT      02/08/2007
SPL      DEPOSIT      02/08/2007
ENDTRNS
TRNS      DEPOSIT      02/09/2007
SPL      DEPOSIT      02/09/2007
SPL      DEPOSIT      02/09/2007
SPL      DEPOSIT      02/09/2007
ENDTRNS

Thanks in Advance!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros