Recent content by Taecca

You are correct. I was getting confused with 'And' and 'Or' All resolved. Thank you :)

Weekday cannot be Sat and Sun for the second query. I need all week long except period A (which is Mon through Fri from 8 am to 14)

Thanks for your reply but it did not work. Basically I need 2 reports: (1 for each period) Period A is weekdays only from 8 to 14 Period B is every day except weekdays from 8 to 14 The query for period A is okay. How do I do the query for period B?

Need to create 2 queries: Query 1 seems to be working ok: Select * from temp where WeekDay not in ("Sat", "Sun") and TimeOfDay between "08:00" and "14:00"); How do I now create another query to select * for the rest of the times? (Weekdays from 14:01 to 07:59 and Saturday/Sunday the entire...

Thank you

In one of my colums has data as following: Client ID: AAA2393 Client ID: AXY22228900 Client ID: 92000AZyU OPQ282822AZY NO001AZND and so on... In my query I would like to remove the words: Client ID: How can I do that?

If I receive a signal from someone else's router in my house, can I connect to it? What are the risks?

Thank you

Thank you for your answer however I think I need more details. How do I turn on my wireless network detection? I don't even know where to start. This laptop is totally new and has never been connected to the internet. Could you provide more details? My company tells me I can use the router...

I have created a form (continuous) and StudentName, StudentCity, StudentID are some of the columns. I wish to add a button at the side of a column that when clicked will filter by the value (StudentID) on the current record. How do I do it? Thank you and happy new year

I purchased an IBM Thinkpad R50. What do I need to connect to the interent wirelessly? I have connected a wireless router to use my work pc at home and while using it I detect several wireless signals in my apartment. I would like to know what do I need in my Thinkpad R50 to connect to a...

WONDERFUL![2thumbsup] Thank you

I have a continuous form with a few different columns. I wish to add a button at the top of each column for the user to press and sort by that column. I will then add a refresh to the code to display the newly sorted records. Can that be done? Thank you for your help

In my table I have records with :Section ID, Sub Section ID, Item Id and LocationName I need to do a search on my form where a user would use combo boxes to indicate Section, SubSection, Item and finally LocationName to retrieve the correct record. How someone guide me? Thank you

I am not sure I understand what you mean? When I try to create a form I have to pick a table. If I pick my table, as of now columns ItemID and Comments are empty. How do I make a form that allows the user to select an itemID, or ItemName and description from the linked tables and insert a...