Search results

Thank you all for your response, appreciated.

Thanks CJ for the info. I still leave it unresolved for future references.

Yes Josef, this is the line for new record. I just make a default value for D_Date, since the new record will always use TODAY date for D_Date

Hi, I tried the suggestion but it doest work, still showing the blank page at the bottom (i meant blank page, a new row to insert new information). SELECT Table1.Customer, Table1.Product, Table1.D_Date, Table1.P_Date FROM Table1 ORDER BY Nz([P_Date],#12/31/2999#) DESC; May I request to please...

Hi Good day to all, i sorted the P_Date in descending (thru Query1) and provided the result correctly. However, I prefer that the Blank row in RED (with default value of Date today on D_Data) should be on the top. I tried the option MySort: IIF(IsNull([P_Date],999999,[P_Date]) but does not...

Solved, we explained

Can I change it to display NA? How

HI Arnelgp, Successfully applied the solution to my DB and works fine. Just want to know: 1. why you put "D" as criteria in the query? 2.Instead of "0" value, would it be possible to be "NA"? This is already solved. Il do that after your response.

Thanks Arnelgp for always providing the solution into the DB file, il check and confirm.. Thanks June7 for your suggestion

Hi Arnelgp, Jun7 Yes this is the expected out I need. I can use it if the DB has just started. But our database is populated already and continously adding more information. It's not advisable anymore to add or change as per your suggestion or else it will require major changes. Maybe the...

Guys, Sorry but I cant translate the solutions to my DB. Im not expert in the access field. Would it be OK if you can apply the solution direct to the DB so.I can follow.

This function is possible in excel chart but I dont know how to do it in access. I'm using 2010 access version fyi.

Hi Ebs, thanks for the response. I agree with you but it is expected that due to that filtering the values cannot be generated. It's just to show that in that particular dates and with the given condition, there were no transaction with customers. For cases like that, I just need to display...

Hi AWF Team, I would like to ask your help on my database. Below is combine screenshot of table, query and chart (chart is linked to query). On the query, I filtered the "Customer" for CustA, CustB, CustC by Group (refer to the attached DB), however no value was generated due to other condition...

hI ebs, Perfect, got it now. I was bit confused when I saw the SQL format codes. Thank you very much. Subject query closed.

Hi ebs17, Thanks for your response. I'm not expert and can't transfer the SQL into my DB. May I request you to put it into the attached DB and send back to me. This way I can interpret. Thank you

Good Day to all, I would like to request your assistance to the below query. Attached is my sample DB. In the form below, there are AVG_Cust automated value from Customers. I need that the third column will have an automated value based on the value from AVG_Cust. As per below sampe if the...

Solved/ Thank you Arnelgp

hi arnelgp, In the attached using classic version, the color of the column has the same color. Trying to change the color of each column and adding the value at the top of the value but can't see the option to do it. Please advise any alternatives way to do it using classic version

I'm using 2010 access version and the modern chart seems not yet available. Can't migrate yet to latest version as this is the current version we are using in the company. Still in classic and need to maximize the option in this version. May I know if there is other way using classic version...