txtDate Sequencing/record check

[MayaMana]

I am working on making a sequence code for complaints based on plant and date. However I run into an issue when there are more then one entered for a date from the same plant. If there has already been a complaint for that day I would like the end sequence to go in order (-1, -2 , -3... etc). The operators do not always enter in the complaints on the correct date.

I am hoping to be able to do a quick record search before creating the sequence number (which I have set up to make after the date and plant are selected), and if the record exists then change the last number accordingly.

 

[jdraw]

Why don't you use a ComplaintDate using General format showing Date and Time?

Use queries to organize Complaints by Date/Time, Subject, Complainant, Plant, ...

I think you're trying too hard to do something you don't need.

 

[MayaMana]

Why don't you use a ComplaintDate using General format showing Date and Time?

Use queries to organize Complaints by Date/Time, Subject, Complainant, Plant, ...

I think you're trying too hard to do something you don't need.

Because the complaint number is set up by using the Plant code, Complaint Code, by date (mmddyy), and the number of complaints that day. Instead of having to make the operator input this on their own I was asked to make it automatic for ease of use.
I am just having an issue with the last digit.

Basically I just want to see if the record I am trying to create is there, if so than to add 1 to the number at the end.

 

[jdraw]

Still think you're overworking this.

I realize

Because the complaint number is set up by using the Plant code, Complaint Code, by date (mmddyy), and the number of complaints that day.

that's how you do it now.

I was just suggesting an alternative that I think would make the whole process simpler. But you know your environment and I don't. I may lack some details that make it required to do it as you do, but you may be too close to the issue to see alternatives.

I am offering advice -- don't make complex coding structures unnecessarily.
You can use queries to organize Complaints by Date/Time, Subject, Complainant, Plant, ...

Anyway, good luck with your project whatever you decide to do.

 

[MayaMana]

Well thank you for your lovely help.