Date            term 11-Oct-99      1 11-Oct-99      5 11-Oct-99      9 11-Oct-99      10 11-Oct-99      15 08-Nov-99      1 08-Nov-99      5 08-Nov-99      9 08-Nov-99      10 08-Nov-99      15 15-Nov-99      1 15-Nov-99      5 15-Nov-99      9 ...

I have a table called data that has a date field, called DateOf, in. What i am trying to do is this. I need a query to show me what records are 0 to 7 days old(1 week old), 8 to 14 days(2 weeks ...

INSERT into Table1 (points) values (40) where Level="H" AND Result="D"; this is kinda what i want to do. points is a new empty integer column. i want to insert a value based on two other fie...

Hi Guys! I have half a dozen tables with fewer than 50 columns each. They are vary sparcely populated. Most cells are either NULL, blank, white space, or zero equivalent ("0", "0.0", etc.). Give...

I have a form with a Tree View control, a check box and a subform, which displays as many as 16 categories and numbers for each. The Tree View control shows the organization structure using DeptID,...