Search results

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

Hi Marlan, Thanks for your advise. But sorry that i cant really get it. Can you give me a link or detailed instruction?

Hi John, Thanks for your prompt relpy. I attached a copy of relationships for your review. What does default value mean? Thanks again

Hi in my payroll, two of the tables is for salary & period tblSalary SalaryID(PK) EmployeeID(FK) SalaryAmount CalendarID(FK) AccountsCode(FK) tblCalendar CalendarID(PK) DateFrom DateTo I realise that, in salary table, i need to repeat the same data for different period, ie Nov 2011...

Hi I have a few tables about salary. When i use query to show data for salary and allowances, the datasheet only come out with those result where both salary and allowances have figures together. eg employee A has salary and allowance, so his data show, but employee B only has only salary and...

Thanks for your explanation, Plog. After given it a thought, i am confused again. Say employee A was a clerk in November 2011 and been promoted to officer in December 2011. Hence, in my query/report, i shall populate the data by selecting 1) employee name in tblEmployee 2) designation...