Queries
in [Access]
|
How to Analyze Attributes in a Query Is there a function/formula that you can use in a query against a field to return what type of attribute the field value is? If so, can you then change that attribute just in the query output? Thanks. SHKNBKE ... 7 May 2010 15:38
Multiple fields into one Hello! This is concatenating with a twist. I have three tables: Tag: *tag Doc_ref: *DocID *GenID Document; *DocID Doc_Type GenID linked to Tag with a one to many relationship Document!DocID to Doc_ref!DocID with a one to many Now, what I need is to get one field with all the DocID values with... 10 May 2010 09:53
Microsoft Responds to the Evolution of Online Communities Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the rapidly-growing forum platform. This decision is in response to worldwide market trends and evolving customer needs. Microsoft continues to invest ... 7 May 2010 02:25
Microsoft Responds to the Evolution of Online Communities Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the rapidly-growing forum platform. This decision is in response to worldwide market trends and evolving customer needs. Microsoft continues to invest in for... 7 May 2010 02:25
Finding a function call in queries Does anyone know of a way to find if a function is being called from a query? Another words, I have a function that might be called from 1 or more queries in my DB and I am looking for a quick way to see which queries it is called from. With over 200 queries in my DB, it will take me some time to check them ... 6 May 2010 20:58
Sort Order of Update Query I have two tables and I am updating columns in one from data in another one. PnList table has a columns named as follows Pn 09950 10140 10240 020-989-014 020-989-015 020-989-016 020-989-017 step02 table as columns named Pn Shpef Socd sorted ascend as... 6 May 2010 17:38
Criteria for an email address fied Sorry, I posted my email at the Report session.. Hi, I would like to make a query that give me a list of the emails address with number in it? I tried to use wildcard characters in the query design view, but it always gives me a blank record. Ex: I would like pull out the emails like below: Chotran... 6 May 2010 16:32
Access 2007 Will not accept wildcard I have a query and in the criteria for a text field (Route), I'm placing the following statement: Like "*433" When executed, the query will not return any rows. However, if I type in each option (IE433, X433, etc.) and execute each one, results are returned. I had another query where I used this wi... 11 May 2010 11:11
Stacked vs Multiple Inner Joins Hi all, being a little slow when it comes to queries, I'm wondering if someone has any advice on which is the more efficient method to use. Consider three tables, tblOrders, tblOrderDetails, and tblOrderReleases, each with a one to many with the table listed before it. tblOrders has a fldStatus, integer, to t... 7 May 2010 21:10
Default Value-Complicated Hello, I have a Module that pulls the username of the person logged into the PC (if you would like to see this code, let me know). I have a table called tbl_WorkerIDs with all my staff's login Ids in a field called "LANIDs" and I have another field in the same table called "CSEIDs". Each person has a LANID a... 14 May 2010 10:36 |