Recent content by L1882

Working a treat thanks. One final point, some of the entries contain within them CHB B or DWP and I'd like to exclude these as a criteria but I'm struggling to create a criteria that excludes records containing either of these strings - again any ideas?

Hi, Thanks for that. That would seem to give me ones that do match as well but I guess I could then exclude the null values. Many thanks, will give it a go

[Solved] Query to return non matching records Hi All I beg your forgiveness but my Access knowledge is limited so this is probably going to be a really obvious thing to most of you but I'm hoping you can help/point me in the right direction. I'm using Access 2007 and in my database I have 2...

big thanks to both of you - you've solved in minutes what I've spent (on and off) 2 weeks trying to sort out

Thank you - that is excellent and I now understand why I was having the problem. I'm using 2007 and it doesn't seem to like 'where' with 'show field' but I'll work on that now - hopefully I can sort it from here, if not I'll come back for help.

Yep, that sorts the issue. The only problem now is getting the latest ledgerbal is the main purpose of this query. Is there anyway I can now add the ledger balance field back in?

Hi and thanks for the reply. I have tried that previously, and just tried again, but is still returns multiple entries for each card, the sql looks like this: SELECT Max(Transactions.LOGDATETIME) AS MaxOfLOGDATETIME, Transactions.CARDNUM, Transactions.LEDGERBAL FROM Transactions GROUP BY...

Hi All I'm a new member and far from an expert on Access so thanks in advance for your patience. I have a database with 2 tables. One contains customer records and one contains transactions. entries in each table can be linked via a unique number (which is a 'credit card number'), with a one...