Search results

Thanks, that has worked (the three query option) :)

hi neil, it is a transactional database of gift cards. each gift card can be used multiple times, and each time it is used it records one entry in the database. this entry will always have a transaction type (it could be one of a dozen different codes). the transaction types refer to Activation...

hi, i am querying a single table that contains card numbers and corresponding transaction codes (amongst other things). a single card number can have multiple transaction codes. i want to select all card numbers that have both 0100 and 0802 transaction codes. if i use a select query with...

oh.... my.... god!!! thank you so much for that. it'll take me a while to go through it all and if i have any other questions - highly likely - i'll post them (it just shows how steep the learning curve can be)...

ok, i can just about get my head around that! the problem i face is having no VBA skills at this point in time... i have an awful lot of data in each record, including a time stamp. i keep thinking there must be a way of applying order in a seperate field using the existing data, but of course...

thanks jon, but in the full database there are lots of other "802" transactions that are perfectly valid, and this query would select those too. that is why i need to select based on time, as every "1" transaction would be immediately followed by an "802" that needs to be removed (but only...

hi guys, some background on my data: i have a table that holds Electronic Gift Card details (those plastic store gift voucher cards). it holds all details of every transaction for every card, so the card number, activations, redemptions, dates, times, transaction values etc. are all recorded...