Search results

Sorry for that. Luckily, what i am really doing is for the small printing company! Thank you very much for the help. Let me check the attachment now...

Sir could you please give me an example database for this? So i can have easy comparison for the needed structures and formats. Thank you very much in advance...

thank you sir. I will try to look at the tutorial...

Sir that maybe is my problem here. I am not able to get the right structure because i cannot achieve the right result. :confused: Could you please help me on how to solve this? Or maybe you may refer some sample database similar to what i am looking for? Many many thanks in advance...

:osorry...

Good Day. I am really not so good in access so please help me.:o:o:o I have this database where i entered data per job order. Each job order has up to 10 operations and per operation has different kinds of machine used. The total Operations and total machine used are depending on every Job...

Good Day. I am really not so good in access so please help me.:o:o:o I have this database where i entered data per job order. Each job order has up to 10 operations and per operation has different kinds of machine used. The total Operations and total machine used are depending on every Job...

Sorry but no help for me from that site.:( I have no choice but to create new database so i can create new forms although it will give me another long hours for this database revision. I just cannot understand why and how is that happening. All my forms for data entry is giving an...

I tried to compile the codes but nothing happens. I also tried to transfer the database to other computer to make sure the access has no problem but still i cannot edit and save the forms for data entry:confused::confused::confused:

Actually after converting to access2003 I can still use and edit without any troubles but only since yesterday that an error occured. Now i tried to create a new database then importing all data from my previous database. I just noticed that the error occurs only on the forms for inputting data...

Yes Sir I can save anything on the drive, I can even create a backup files and other things.

Hello, I don't understand why my database keeps showing an error everytime i tried to save my form. Previously i can save my forms without any trouble and then all of a sudden an error message keeps showing when i hit the save command on my project. Please see attached png files... By the...

Hi Sir Brian. My query works now, thanks for your support!:D Here is what i do, as you said i clicked the Sigma sign and selected "Expression" in replacement of "Group By" in the Total Field (which i missed previously:o). Then, when i tried to add "MonthName" into the field i have no more error...

Sir, can you give me some sample project for this? I am a little bit confused on how to do it. Sorry just beginning to learn more about access...:confused:

Sir i attached here a picture of my current form showing all the data per month. Is there a much simpler way maybe a crosstab query to show just like on the excel form i sent. Thanks again.

Please see attached png file for the sample of the formula on my query. How can apply that to show all the data for let's say January to July. Because currnetly i am doing it one by one for every month. Is there simple way for this? Many Thanks in advance:)

Sir what i am trying to say is how can i apply using that formula to show the records per month. Please see attached sample in excel. How can i apply that on my query.

Hello sir. Remember the formula you gave me? It is working very good. I applied it on my monthly report on my project. The only thing is i cannot apply this when doing on showing all the monthly summary. If you look into the attached png file the summary is for January only. How can i make it...

Hello. Can i post my question here? It is related with the inquiry above.. I also want to count the number of records per product and i want to show on my report only those product having 30data and more. When i try to input product name on my form and select "show report" it should only show...

Sir John. I tried to apply "Average" on my data but since i have so many product not just one, maybe the access got confused because i got an error when i applied . On my database we have more than 1k different products and each product having about 10 parameters. What i want on my database is...