2 table fields into 1 query field

[Coatezy]

Hi I have a table called "table1". within that table I have 2 fields.. "paymentdate" and "refunddate" I need to pull both these fields in to one field to consolidate all payment transactions and refund transactions for the current day in to one field. This data is then to be exported to excel for our daily banking.. What would be the easyest way of linking these two fields in to 1?

Thanks in advance
Tom

 

[Rich]

NewField:[Field1]+[Field2]

 

[Coatezy]

Hi sorry maybe I didn't explain what I'm after very well..

Say I had 2 refunds and 5 payments in 1 day. Need a query that takes each refund and each payment and puts them as individual rows in one field. I can when in one query import the data in to excel.. of course I will just be using the date so I cant then set the criteria as date () to pull the current date.

I dont want the two dates joined together I want to pull all refund transactions for the current day and all payment transactions for the current day in to one report and have all the matching info in the same fields.. i.e payment/refund date, payment/refund trans no., cust name.. etc etc..

Sorry still dont think i have explained what im after overly well.

Tom

 

[neileg]

The problem is that your table design is wrong. It would be better to have these transactions all in one field from the outset and use another field to describe them as refund or payment. If you make, say, the payment amounts positive values and the refunds negative, all you need to do is to sum them to get the net position.