Search results

Perhaps you can post a copy of the db

With a better understanding of the requirement I also tried the function way, as suggested by Gasman. My version of it is attached.

So, I'll ask again. Can you post a copy of the db.

I had no GroupBy clause either

Can you post a copy o the db

I notice that you are using "Lookups" in your tables which can lead to problems. See: http://access.mvps.org/access/lookupfields.htm

Perhaps you could use a query to calculate the count of weekdays. Something like: SELECT Count(YourTableName.FieldNameToCount) AS NumOfWDays FROM YourTableName WHERE (((YourTableName.YourDateFieldName) Between [Start Date] And Date()) AND ((Weekday([YourDateFieldName]))<>1 And...

You could add a "LeavingDate" date field to one of your tables.

What's that all about?

Cross-Posted: https://www.accessforums.net/showthread.php?t=88649 Please read: https://excelguru.ca/a-message-to-forum-cross-posters/

Search YouTube for videos on: "access table relationships". There are lots of them. Here's one I found:

I would advise against the use of Lookup fields in tables. See: http://access.mvps.org/access/lookupfields.htm

Glad you have it working :D

Not sure that "MUST" is quite right. I thought that expressions without them would still work if the field name had NO spaces in it. I would agree that they are advisable though.

If you post a copy of the db one of us may be able to find the problem. The last code that I posted worked when I tested it.

Can you post a copy of the db with just a couple of fictitious records.

Then perhaps: Payer: IIF(IsNull(BillingLastname), Firstname & " " & Lastname & " (Student)", BillingFirstname & " " & BillingLastname & " (Billing)")

Try: Payer: IIF(IsNull(BillingLastname), Firstname & " " & Lastname & ", '" & (Student) & "'", BillingFirstname & " " & BillingLastname & ", '" & (Billing) & "'")

Try: MsgBox ("Wrong Password.", vbInformation + vbOkOnly, "Operation Cancelled")

Glad you have a solution. Always pleased to help if I can :)