Recent content by shieriel

I created a query with monthly performance. The problem is the arrangement for monthname is alphabetical so the first became the month of April considering its first letter. How can i make it arrange that January is the first and so on....

It works perfectly! Thank you very much....:)

Can you give me some sample database please?:)

I have a database with an average monthly performance summary. How can i format to show the summary per week in a month? For example in January, instead of showing the January average from January 1~31, how can i format to show the average per week, say Jan1~7;Jan8~14;etc. Please help me...

I am sorry to say that it's hard for me to understand the codes. I am not very good on codes since i only learned access through self research and study. Can you please give me a sample database that uses workweek summary? Many thanks in advance.

Ok let me see that. Thanks....

I have a query that creates average data per day and also summarized on a per month basis. But i am now requiring to create a summary where instead of monthly summary, the database will show per workweek. For example: Workweek1 is 1st week of january, that will show an average; workweek2 is 2nd...

up` for help...

Sir, I am confusing with the formula. Please correct me if i am wrong: I put the formula on the textbox but nothing happens, it always shows error or "Name?". What is wrong here?

I see. Ok will try it again later. Many thanks...

I put this code on the "after update" event, and when error occurs I tried to create new textbox and put this formula also but with the same error result: DLookup("[OrderDate]", "[OrderTable]", "ProductID=Forms!NewOrder_Form.ProductID AND DateDiff("m",[OrderDate], Date()) < 3")

When i tried to put the formula, I got the following error: Compile error: Expected: list separator or ) and then the letter "m" on the formula is highlighted. What is meant by that error?

Thanks! I will try this on my database....

I have a database for product ordering. What i want to do is a code to check if a specific product have order history for the last 3 months. I dont know how to translate it into code. Something like, when i input product name on the order form, a code will check that in the database table and...

Hi, may i just ask how to modify the code such that the excel file name will be the name of my query, also with the sheet name? tia