Search results

Hi, Merry Christmas to you too! You, Mr. theDBguy, solved my problem. Excellent work. Thank you so much! Happy new year!

I know it is a little bit different. But That's what I need for now

Hi every one, Thank you all for your posts and help, but none of the solutions helped me in solving my problem. In the attached file you will find the exact example which I mean by increment and reset every new month. When opening "Table1 Query", you will find 1,2,3,4 and 1,2,3 depending on...

So sorry if I didn't reply or see your questions. 1- Yes it was existing data not an input file. 2- It's a select query not an append query. Just simple data need to be incremented and reset at every start of the month

I just use Windows 10 and Office 2019. Can I do it? Many thanks for your time and help.

Yes, but this is not what I want.

1- I need to do this with any part of the program. I know that Query can do it easily but don't know how. 2- It's an on going process when adding new product every day, I'll got Automatic number for year and month. When adding product in the first day of the next month, the program resets to the...

Hello, I need to create these conditions using Access query. I tried many solutions in this forum but didn't work with me. I'll be very grateful for any help. Thanks!

Yes. I need to create the conditions in Access query.

I need to create it in a simple steps to the example I attached and not by modules as other examples.

Yes. Didn't work for me.

Hi there, I need to create a query to solve this problem: When entering a new product in the month it has a new serial number starting from 1. This number increments with every new product till the end of the month. A new product in the new month will get a new serial beginning from 1 again. I...

Clear, definite, and excellent. Thank you so much. I got another problem hope to help me in it. When entering a new product in the month it has a new serial number. This number increments with every new product till the end of the month. A new product in the new month will get a new serial...

Hi, I'd like to create an auto number for every month and reset it (begin from 1) every month. Kindly help me in that. Thanks in advance for your help.

No, no combo box. I need to apply the below example in Access: What I need to make is putting data in ascending order under three conditions: 1- Date Entrance 2- Date Registration 3- Shipment Code If duplicate date entrance, THEN add date registration, If duplicate date registration, THEN add...

No, not from combo box I’ll explain below and kindly find the attached file: Forget any system complexity about the previous example. What I need to make is putting data in ascending order under three conditions: 1- Date Entrance 2- Date Registration 3- Shipment Code If duplicate date...

Hi everyone, Forget any system complexity about the previous example. What I need to make is putting data in ascending order under three conditions: 1- Date Entrance 2- Date Registration 3- Shipment Code If duplicate date entrance, THEN add date registration, If duplicate date registration...

Okay. Can you help me in that? I'll be very grateful for it. Thank you!

I mean if there are duplicate date entrance and date registration. In this sample we have 10-11-21 in date entrance repeated 2 times. Then we exclude it and search for date registration. If it is okay, then show it in the output. If it's repeated like 11-11-21 repeated 2 times, we exclude it and...

I mean if there are duplicate date entrance and date registration. In this sample we have 10-11-21 in date entrance repeated 2 times. Then we exclude it and search for date registration. If it is okay, then show it in the output. If it's repeated like 11-11-21 repeated 2 times, we exclude it and...