P
PC
Hi,
I created a db some time ago which allows users record incoming invoices and
Direct Debit payments. the Db works fine but now there is a requirement to
create a report which lists transactions between 2 specified reference
numbers.
The reference numbers look like 01/06, 02/06, ... etc (i.e. Transaction
Number/Month of transaction) and the data type currently is "Text".
Obviously I can't create a "between" query on these.
Can anybody suggest some way I can format this field or some code to use to
allow me to specify between 2 Transaction Reference Numbers as the criteria
for the query
Thanks in advance
I created a db some time ago which allows users record incoming invoices and
Direct Debit payments. the Db works fine but now there is a requirement to
create a report which lists transactions between 2 specified reference
numbers.
The reference numbers look like 01/06, 02/06, ... etc (i.e. Transaction
Number/Month of transaction) and the data type currently is "Text".
Obviously I can't create a "between" query on these.
Can anybody suggest some way I can format this field or some code to use to
allow me to specify between 2 Transaction Reference Numbers as the criteria
for the query
Thanks in advance