Replies

That’s why this question is so crazy. I’ve tried that one before. Both setting are exactly the same.

The excel file attached shows a dump of the table. The problem is that the table is linked to a text file. the text file will be automatically updated from another program. when i set the link specifications, i established “date last in” and “date create” in date format. where 00/00/0000 appeared in the field under “date last in,” access converted that field to a #num! error. i have a query written that is supposed to return date last in. if there is not a valid date there, it’s supposed to return date create. if in excel, i would do this simply as IF(ISERROR([DATE LAST IN]), [DATE CREATE], [DATE LAST IN]) I can get there because i don’t know how to get the ISERROR part to work. Let me know if you need to see the actual database if this doesn’t make any sense (probably doesn’t). thanks again.

Thanks for your response in this matter, but I’m still having a problem. the value is not null, it an error: #Num!. I need to have a formula to convert the error into either a null or a true/false statement that i could nest with the NZ or iif/then formula.

This worked PERFECTLY. You guys have been such a great help over the years. Thank you very much.

Maybe it’s just me being dumb and not knowing that I can do this in a much easier way. Also, I know that there are better ways to create forms, but based on external limitations, I have to keep with Excel right now.

I am just trying to return a list of the results to the second drop down box without the user having to scroll down. I want the selections right at the top. Thanks.

It didn’t work. I still have to refresh.

This worked perfectly! Thanks, yet again.

We are currently using that as a work around, but we’re looking for the actual functionality to work in “reply to all.” Is it available?

The highlighted yellow section is the totaled area. Those are the combo tables that I’m looking for.

YES YES YES!!!!

I think this is it. I couldn’t remember for the life of me what to do about the 2 different criteria. I totally forgot about concatenate. Thank you guys so much.

You’re absolutely right on point #1. That was an error on my part. On point #2, just to make this more fun, if the “Date Next” is greater than the reporting date (today), the status will show “future dated.” That’s the easy part of the formula so I forgot about it. It’s the meat in the middle that I can’t get. See new additional examples in the attachment.

The same event needs to be completed several times with different “as of” dates. So event 250634 for an as of date of 4/30, shows on the results with a “not processed” status. But the same event 250634 for an as of date of 5/31, shows on the results sheet with a “completed” status. I want the formula built into the yellow highlighted section of the source sheet. I put what the results should be just to identify them. So my logic (if it can be called that) is:

If the event is on the results sheet, if it matches the as of date, if it is complete, return a complete status.

I was trying to count the fact that a month could cross a 5th week, like the month of September.

well, duh!

I was trying to make this so much more complicated that it was. I should have known that!

Well, duh!!!!!! I knew that!!!!!
I guess I had a quick brain lapse! Thanks again!