Search results

try is null with out quotes like this: Is Null sam

Hi, I have an employee table(s) from which i would like to do retention analysis. i have a few queries. one query gives me all the active employees based on a form (start and end dates). I limit to either those who are still active, those that were terminated after the startdate, and who were...

amazing!!!! it worked. i am working on this all day. not the join thing, just putting together the reports i need. this solution rocks. i will apply this to other applications. the short commings: 1. i needed to put an ending date for rates that are current. so i pushed them till 2007. i...

thanks for replying. it sounds like you understood my dilemma. first, i am not sure, will this technique work for mulit ple updates. i was actually thinking of doing this, but i wasn't sure if this will work even for many price updates. second, i think i have already designed queries as you...

i would like to have a table where i can track price changes, however i don't want this to based on an inventory order. i have a table which has the amount of hours to be charged. i then have another table which has the price per hour charged. the price keeps on changing. both tables have the...