How to Sum the DaysStayed column and subtract from 14 then give a message

[TLCTech]

After the sum has been calculated and subtracted from 14, I need to have a message box come up for the user to instruct them if the person on the record is <=14 or >= 14. If less than 14 display how many days they have left. If no days left have a message what date they can come back which is already a column in my tblRegistration called "NextAvailableDate




Registration.zip"

[ranman256]

in your form (or report) show sum,
another box for DaysRem,
another box for NextAvailDate. (invisible)

if daysRem = 0 then then
NextAvailDAte.visible = true
endif

[TLCTech]

How do you get the sum of the days of the records of the same person. As you see in my tblRegistration, I have a last name of Casey that has a total of 14 days in the 30 day period. How do I add his days in the DaysStayed column and subract from 14 to give me a number of remaining days?

[TLCTech]

How do you get the sum of the days of the records of the same person. As you see in my tblRegistration, I have a last name of Casey that has a total of 14 days in the 30 day period. How do I add his days in the DaysStayed column and subract from 14 to give me a number of remaining days?

[ranman256]

the form is connected to the query,
text box txtTotal = [sum]-14

[TLCTech]

I need to add the column NextAvailable Date to my query when the total days are >=14. Is there a simple way to add this? Every time I add the table column it gives me an error that it is not in the expression. Aslo when I add the column, I lose the SumOfDaysStayed. It goes back to the entry of each record instead of giving me the total days.

Here is a copy of my table, query, and form that I am using.
Data.zip

[rpeare]

You have excel files in that zip, not access files.

Access is a relational database, excel isn't.

[TLCTech]

You have excel files in that zip, not access files.

Access is a relational database, excel isn't.

Sorry for that. I thought we were suppose to send the exported excel files.
Here is the actual Database

Camper Registration.zip

[rpeare]

ug, are you using multi value fields or calculated fields in the table tblRegistration?

[TLCTech]

Multi value fields

ug, are you using multi value fields or calculated fields in the table tblRegistration?

[rpeare]

don't use multi value fields, they a titanic pain the ass to deal with. I do not have a computer that can look at multi value fields/calculated fields right now so I'll try on monday or tuesday if someone hasn't gotten to it by then

[rpeare]

If your example database does not rely on the multi value field can you take out that field and repost your example database. If it does rely on the multi value field then this will be an incredibly painful process for you and I do not think it can be done with queries alone you would have to get vba involved.