Recent content by kb44

This was the answer guys. Thank you!

I just read this thread and wow.. I give much praise @pbaldy for trying so hard to help someone even though his help requests seemed like demands at times. There is clearly a language barrier and that seemed to be the reason. It did not phase pbaldy. You are a VIP sir!

Good morning everyone... I would like to implement this progress meter (Option 2 - Single Meter Bar) to a series of queries which I run from a form by clicking a button. I am a newbie to Access so I inserted the code in the way I interpreted the original post. Here is what I have: Private...

Got it. I will remember that.

Definitely working now guys. Just had to flip the 1 and 0 as you said. Thanks again!

In the above sql does: field1 = table with new changes? field2 = table without new changes? does that even matter? Also, when I use <> Access does not let me go back to design view. Only SQL view because it says Design view can't interpret <>. So I would prefer using = if possible.

My apologies for the confusion guys. Both tables have the same fields. A change can mean any change between the old and new files. Including deleting of a field. But if the old and new tables both show a blank space, I do not want to show that as a change (since it isn't). That was one of...

This worked! Thanks for your help. Much appreciated!

If anything of the following change I want to display a 1: If there was input in the before field, but it was deleted in the after table and now there is a blank space If there was a blank space in the before field but now there are characters in the after field If the text has changed One...

Hello again, There is a twist. Sometimes the field change will be an empty field. Meaning that the user will delete the field contents and leave it blank. I want this change to be noted if the field had something in it to begin with but not if it was already empty (since that would mean there...

This is how I'm interpreting it: Changed_Country_Y_N: IIf([1-b Monthly_Staffing].[Country]=Nz([tbl_Select Current Month].[Country],""),0,1) With this I get 640 true out of 7xx. Changes should be around a hundred. Maybe it's reversed?

Hi all, I need to build an expression that shows a 1 if the fields have changed (not if they are not both null or have if they both an empty space in them). Meaning, if the fields are empty, I do not want the field to return a 1. I have the IIF statement, but can't figure out where to put the...

I definitely will. At my next progress meeting I'll see what they say about the project. Feels like I am making good progress. Thanks to everyone for your help and sharing your knowledge.

Wow. Thank you. I thought that it was the UPDATE query that was adding the duplicate lines, when in fact the duplicates were there already since I used the wrong table to begin with. Since I have been testing a lot and re-naming tables, that's where the error occurred.

That was the resulting table after the UPDATE query was executed.