Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to format a table using formulas/VBA in MS access?

1 view
Skip to first unread message

Wije

unread,
Aug 17, 2009, 9:28:01 AM8/17/09
to
I am trying to work out a way to format a table imported from a text file. It
currently looks like follows;
Field1 Invoice Value
Batch No: 43214141
1 5364542 $232
2 3434414 $767
3 4464747 $676

Field1 Invoice Value
Batch No: 686968899
1 1368623 $898
2 88787787 $787

I need to get the batch number to show against each invoice number instead
of grouping at the top for the whole batch. How do I do this in access?

0 new messages