Hi everyone
I have a table that has a column of codes (1-10) that never change. Within that table I update the number of products completed for that particular code. I would like for my final results to only consist of May production, currently though, I still have Aprils numbers if there wasn't a change in May. I realize thats what an update query is so I'm asking for suggestions.
I did try a delete query so I can clear the outdoor and indoor fields before I update but that also deletes the code field.
Bookmarks