Search results

I have a table stored in 3NF such as this: ID GROUP TOM DIAL TOM BROADBAND TOM WIFI SAM DIAL SAM BROADBAND I'm trying to create a query that goes back to a denormalized table where the output would look like: TOM DIAL...

Hi, I was wondering if anyone could help me out or give any suggestions on this network design I've been working on. It's for my Network+ class. The situation is this: There are 2 buildings separated by a roadway, each building has 4 floors holding 30-50 people at each building. One building...

Hi, I'm trying to compare 2 name fields to see if the last name of one field is found in the last name of the other field. In table A, the name is stored as LastName, FirstName. I've used the Left and InStr function to extract the last name successfully. In Table S the name is stored as...

Hi, I tried to search this, but it returned too many results each time I searched, "LIKE" I am trying to use the SQL command: name LIKE 'M_ _ _ _' meaning there are exactly 5 characters, beginning with M... this didn't work for me in access, any suggestions? I found that % is replaced...

Hi, I have created a table with a column called lastlogon, which stores the date of the last logon from windows active directory for a user id. Everything is being imported from a text file. Most of the time there is a valid date of format, "6/8/2006 1:10:23 PM" . I can declare the column as...