Hi Access Forums Community,
I just got into a sticky situation the access developer left the firm and im stuck cleaning up the mess but I am not an access user. I have took several online trainings and watched videos but as many of you know that is not enough.
My issue: I have a table called Tracker Detail , which includes all of the AC's and AI's (type of document) in a list. But the form that is supposed to pull in the AI's is only pulling in the AC's adn not the AI's even though they are all in the table.
A part of the code that I thought would pull in the AI's and not the AC's is:
mySQL="select * from tbl_tracker_detail where (tbl_tracker_detail.[cleared from suspense]='no' or tbl_tracker_detail.[cleared from suspense] is Null) and tbl_tracker_detail.[document type] = "AI" and tbl_tracker_detail.id is not null order by [Document Number];"
So based on that code why on earth would it pull in the AC's and not the AI's as clearly written in the code. I hope this isnt a dumb questions but its really frustrating.
Also side question, one of the reports tht we pull is pulling in the right information but one of the column headers has the wrong label altough its correct in the tables. Thought I would just throw that out there as well.
Thanks so much everyone