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!
-
Trouble using memo field
Beginner Alert!!! When I try using the Memo datatype as a parameter in my append query it tells me I "need to remove the DISTINCT keyword, memo field or OLE object when selecting unique values" or something to that effect. I changed the query to unique records, Top Values to 1 to...- extractor
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
Form parameter for query
I've been trying to get this date range qury to work for some time now. SELECT tblTrackingInfo.Date FROM tblTrackingInfo WHERE (((tblTrackingInfo.Date)=IIf(nz([Forms]![frmSearch]![txtFromDate].[Value],"")="",[tblTrackingInfo]![Date],([tblTrackingInfo]![Date] In (SELECT...- extractor
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
Cisco modem 721 error
We are currently using a Cisco 2600 router with a sixteen port analog modem bank. The machine worked for a year at one location with not one problem. It was moved to a new location and immediately started to give trouble. Some ports would go off hook when dialed to, but just not answer...
