Search results

I am trying to compare dates between multiple tables and retrieve the latest date. Basically: 1 - I have a master table that records work requests given to the group. 2 - I have 9 different tables, one for each team in the group. Each team gets handed different parts of one task and reports...

this may seem silly, but I have a query in which I want to create a field called "qryLastDate" that will contain the later of two dates, Rev1 and Rev2. In the datasheet, sometimes it works and sometimes it's backwards. What am I missing? Thanks! qryLastDate: IIf([Rev1]>[Rev2],[Rev1],[Rev2])...

ok, here's something maybe a little different. first off: MS Access 2010 I have a form "Admin" used to create new records in a table "RCJ" I have a table called "Projects" that contains detailed information for projects. I have a table called "Waterfall" that contains basic information and...

My newest twist. I have a form that has multiple buttons that open various forms. All work properly except one. I open it and it opens near the bottom of the screen. All my other forms open with the top of the form. I've been comparing various form properties between the one that doesn't...

I'm sure I'm missing something simple here. This is in Access 2010. I have two databases. One called BaseData that carries the data. Multiple tables with various data sets. that's it. No queries, forms or anything else. The second (we'll call WorkingData) basically carries my forms...