Search results

  1. I

    Finding last row/detail of page

    Hi I am currently making a line placed below a textbox disappear if the contents of the textbox is NULL. I have done this through VBA and it works fine. I would like the line to be made visible (visible=TRUE) if the textbox of the current detail section is at the bottom (the last detail...
  2. I

    count 1-many and group by the many side

    Hi I have a many-many relationship between a “promotions” table and a “trading periods” table. This relationship is resolved with a 3rd table called “tblPromo_TP” The promotions table has 2 date fields that store the start date and end date of a promotion The Trading periods table has fields...
  3. I

    Filter query through form

    Hi, I have a projects table with projects that all have start dates and end dates in the same table PROJECT ID Project name start end 12 Grand sale 27sep2010 10oct2010 18 Sony clearout 14oct2010 15oct2010...
  4. I

    Hidding duplicates

    Hi I have 2 tables, 1 for temp (records imported from excel) and 1 for permenant records appended from the temp table. I'd like to: 1. compare IDs from both tables and if I find a match then i compare 3 fields in these tables. If tmp tables field are different, then append record from tmp to...
Back
Top Bottom