Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by scott50
-
Date Functions
Where do I put that?- scott50
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Date Functions
I am trying to get when a new record is added the month and year to show up like this: June 2002. I can get the date 7/29/02 to show up using the expression builder but I am just wondering if anyone would have any ideas on how to get the month and date to show up Thanks for your help.- scott50
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
-
Finding Non-Null Columns
I currently thought I would set the db up like this Employee Info(id,first,last,staff/hourly,department,job description Then a tables for each department(20) with there required training. Also a general training table. So each table would have columns with there training and a date of...- scott50
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Finding Non-Null Columns
I am creating a database that will collect the dates when training was completed. I need to find all the the columns(training) a particular person has completed. I was considering trying to see if a column is null and then moving on to the next one. Any Ideas?- scott50
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
