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

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

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 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...

Hi When an employee has promoted or changed its designation, how can i update in my data? What shall i add to the below table? Thanks in advance

Hi Attached is a file with the raw data i designed and pivot table is the info i required. Can someone please advise me which filed should be included in table? Based on employee's request, the repayment amount for the whole instalment can be different for each month and the amount is agreed...

Hi Can you please see the attached and provide comment about my table structure? Thanks in advance

Hi Say i have serial numbers and would like to fill the column in table by using "fill series" like excel. Is it plausible? Thanks

Hi I read http://access.mvps.org/access/lookupfields.htm and not fully understand it. But i would like to clarify 1) Lookup is fine as long as i dont use it in queries/form/report. 2) if i dont use lookup in table, how am i able to record the entry in related table? with just ID is...

Hi I can think of: tblSalary ID(PK autonumber) EmployeeID(FK) PayPeriod(FK) SalaryAmount tblPayPeriod ID(PK autonumber) PayPeriod (eg, Jan 2011, Feb 2011,etc) i know something is not right, i believe i need another table as junction table. But i dont know what to include in it. Can...

Hi Is it required to understand table/query/form/report before building a database? The reason i asked is because when i post question on the forum about my design, you guys tend to tell me to do it at form/queries, etc. Hence, i would like to clarify the matter. I dont want belatedly my...

Hi In salary table, employee names is lookup from employee details table. How can i to show the current employees only in the drop down list in salary table? Thanks

Hi From the link, http://www.databaseanswers.org/data_models/payrolls/index.htm, 1) In a table Ref_Calendar. What is day_number? 2) In Employee_Pay, why there is a pay_period_id? How those relationships relate? Thanks