Queries
in [Access]
|
jeramie bellmay people jeramie bellmay www.myspace.com not mach no find 11/11/09 12/08/09 AREA FRIDAY @DON HILL <S?>s PHOTOS-VIEW PHOTO ... 10 Dec 2009 17:55
jeramie bellmay not mach no find area fridays(a)don hill ,S?s photos myspace images thnik you ... 8 Dec 2009 21:58
ADODB.Connection to Teradata Timesout Hi All, I am running Teradata queries from MS Access using a ADODB.Connection. The queries run directly unsing Teradata in about 3 Min. I can't keep the ADODB connection from timing out before three minutes. The error message is: "[NCR][ODBC Teradata Driver] Query Timeout Expired" I guess that I don't u... 10 Dec 2009 14:33
Change Form/Report Query Based on User Selection I have a form and report based on a query. I need to change the query based on what the user selects on a form. Using VBA in MS Access 2002, can I change a single field in an existing query from GROUP BY to LAST? This process would be initiated by a click event on a form. Thanks in advance for any help. ... 8 Dec 2009 15:18
Displaying Yes or No rather than 0 or 1 I have a query that includes a Yes/No field. When it displays the results in a list box, I want it to display Yes or No, rather that 0 or 1. I'm sure this must be easy, but... ... 7 Dec 2009 11:48
Pass-Through Query / Multiple ODBC Connections When creating a Pass-Through Query, is there a way to create two or more “ODBC Connect Str”s in the Property Sheet? ODBC;DSN=DMH_Hub;Description=DMH_Hub on MZPRODEDWADHOC;UID=mzbrosb;DATABASE=DMH_Hub;Trusted_Connection=Yes ODBC;DSN=DW1;Description=DW1 on MZPRODDW;UID=mzbrosb;Trusted_Connection=Yes Or bette... 24 Nov 2009 17:55
how do i perform a Count(Distinct) query for 2 different column va how do i perform a Count(Distinct) query for 2 different column values using GROUP BY I have this "source" table like this.... |------------------------------------------| |ROLLUP_ID | GAP_ID | REQ_ID | COST| |------------------------------------------| |001 | 001 | 002 | 12.00 | ... 18 Nov 2009 16:53
how do I print out query criteria I created a query and now I want to print out the query criteria. How do I do this? ... 19 Nov 2009 17:30
Web based news browser Don't know what has happened lately, but the the MS web based news browser functionality has decreased lately. Up until recently, searching on my name in a particular group or in the groups parent (microsoft.public.access) would return those posts that I made or replied to on the current date at the top of the... 19 Nov 2009 17:30 |