Forum Discussion

Andy28348's avatar
Andy28348
Copper Contributor
Jan 11, 2022

Having a date issue in a query

Got a odd issue.  What I'm trying to accomplish is to have the user enter the date from what's printed from the text column PaySchedule in this example every 15th.  They would enter whatever date the...
Access 2016
date and time
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Jan 11, 2022

Andy28348 

 

To be honest, I'm having trouble following the process, so before attempting an answer, can we get a bit of clarity.

 

You have a field called "PaymentDate". What does that represent? Is that the date a payment is actually made, or is it the date the next payment is due? Or???

 

You have a field called "PaySchedule". It appears to be the day of the month on which payments are due. Is that correct? 

 

So, if the payment date is 1/6/2022 and the PaySchedule is "every 15th", why is the payment NOT on the 15th?

Also, the first line shows the number 6 in the PayScheduleDate, but the second line shows the number 8. However, the other two fields are identical. Why are rows 1 and 2 different?

 

Rather than dive right into examples, please explain why you need to do this. What is the goal? What is the process being modeled? 


Thanks.

Andy28348's avatar
Andy28348
Copper Contributor
Jan 11, 2022
I must've labled the fields bad. The payment date is the date the user made the payment. So basically I had the pay schedule text field entering things like "every 1st of the month". So what the user needs to do is just copy the number from the pay schedule field and it would subtract the date they made the payment from the numer that was entered. I.e. showing x days late/early.

Resources