Recent content by Ultra King

I am sorry that I did not explain it clearly... Actually I want my table result look like this. As you can see, at difference date, Mark start from 1 for any user... Actually, the Do While tdyDate = Now() is meant to set the date for today date only... or do I need to use Do While tdyDate =...

HELLO ALL... I have table name tbl_TimeRecord. It has 3 fields that name EmpID, Sign_Time, and Mark. I use a form name FormUser to add new record into tbl_TimeRecord.. In this form it has 3 text box by name txtEmpID, txtSign_Time, and txtMark. User only need to key in their ID in txtEmpID and...

Thank you for your reply.. I have tried using the way from the picture, and my query look like this But the result that I get after run the query is not what I expect it should be... Result ... Can you look what is wrong with my query...

Hello All! I need help to filter my queries... It have several fields, and the fields that I want to filter is ItemNo and SellingPrice. The problem is ItemNo has many different SellingPrice. I put a parameter in SellingPrice field as >=75 only for ItemNo "49565", but still i want to show other...