Recent content by Harrold

Hi What criteria shall i use to look for transactions for whole year of 2011 in date field when it contains other year also? Thanks

Thanks Plog, sorry to trouble you again. How about 9986? when i set the criteria as "*9*","*8*","*6*" , again 9860 also come out. Would you please provide me with solution? Thanks again

Thanks Plog, I used your second method. But all the figures contain 6, 5 and 9 are shown, ie 6590, 15691 etc. How can i only have 3 digits?

Hi Say i want to find an amount of $659 or a word 'Christine'. I suspect the amount or word may key in wrong, eg 659 becomes 569. In query, what can i put in criteria to search for the digits or words in different order? Thanks

Thanks Paul. How about two criteria? say, rey and salary?

say in the cell, it has "rey - salary for Jan 2012", "rey - comm for Jan 2012". etc and i need to extract all the transactions that contains the word 'rey'. so that i can see the entries belong to rey. Can just put down "rey" will extract for the above transactions also? Thanks

Hi i would like to look a word, Rey, in a column and to display the result. What should i write in the criteria in query? Thanks

hi, how to change the value from -$### to [red](#,###.##) in query? Can someone please advise me? Thank you very much

hi, I used the below formula for a new column, AMOUNT: IIf(NZ([jd_cc_debit])<=0,-[jd_cc_credit],[jd_cc_debit]) and some of the amount in jd_cc_debit are not captured and show as $0 in the column. Do you know why? Thanks

Hi, say, i have a list of staff bank account number and 1) i want it be shown in query except for one person. How to set a criteria for this? 2) i only want to show one person and the rest not to shown. How to set a criteria for this? Thanks

Hi 1) When is lookup required in queries? 2) What is the difference being using the original source and using lookup? eg in Query 1, both TblSalary and TblEmployee_Detailed have Employee ID. Hence does it matter where i select the employee ID from? Thanks

Hi In table, my figures are positive. But when it comes to query, i would like to change it to negative. Could someone please advice me how to do it? Thanks

Hi I read book that query datasheet can edit data. But how come the query i created is unable to edit? Thanks

Hi John, Please see my attached file. It shows my query selection. My problem is like for Employee A, there are salary and allowance for Dec 2011 for him. hence, by right, in the query datasheet, the entry shall only appear once. but it appears twice for the same person. So i dont know...

Hi I have use those left join method and it works. But it has another issue. For those has salary and allowance, their names appear twice for the same entry. How so? and how to rectify this problem? Thank you so much