Search results

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.

I can do that but will have do do it eventually (possibly in a different query?) since the update to a blank field is important also.

Now I understand what you mean. Indeed, when I run the update query I see a message informing me about: the fact that I am about to execute an update how many records will be updated I will work on posting some form of the DB since it has sensitive data.

That is what I see after fully running the query. I posted the SQL above in my edit.

Here you go. As you can see, the second and third from the bottom are duplicates. This only happens when the change is from a field with input to an empty field. Edit: you can also see it on the fourth and fifth entries from the top. Edit: Here is the SQL: UPDATE [1e tbl_Select Current Month...

Thanks for the replies everyone! I looked and do not see a one to many relationship. I only see a one to one by id. I will look again though. A closer look revealed that the only entries being duplicated are the ones where the field changed from a value to a blank space (the field was...