Topic profile page for Query.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Query.
Topic "Query" was discussed 302,443 times on 8,405 sites in last 3 months
Started 9 hours, 59 minutes ago (2009-12-03 08:14:00)
by harshab6
hi All, I have query I donot think this can be done.I have tried several times to do this I have data like this A B C 50 16 57 7 22 30 18 42 68 20 20 4 50 33 57 i want to get the data in c colomn by adding numbers i s A column ...
Started 11 hours, 18 minutes ago (2009-12-03 06:55:00)
by cstlaurent
I am lost, I taught I found the light with DSUM but can't manage to use it properly. I have a table of 3 Column Project Peats Total$$$ 123 ABS 100,00 124 ABS 125,00 987 ABS 75,00 456 QEW 100,00 I am looking for a query that will have a calculated field returning the ratio of the project value over the Total of all project with the same peats...
Started 19 hours, 36 minutes ago (2009-12-02 22:37:00)
by pshah
Hi, I was wondering if it's possible to log ip addresses in the query log (like apache does)? I have multiple VMs on my site. I use one VM to run sphinx (indexing + searchd). All other VMs query sphinx on this single VM. Can I restrict searchd access to just these VM ip addresses using the config file? I know I can set up firewall rules to do the same.
Started 21 hours, 9 minutes ago (2009-12-02 21:04:00)
by funkykayli
I have two tables that I would like to take some of the data from and combine into a third table. I have started to write a union query however I think that SQL does not like spaces in field names. Here is my SQL SELECT Claimant Name as [Claimant Name] FROM tbl_AIG UNION SELECT Name as [Claimant Name] FROM tbl_Liberty; It is not selecting the first part "Claimant Name". Is this...
Started 23 hours, 34 minutes ago (2009-12-02 18:39:00)
by Thirster42
http://stackoverflow.com/questions/1831799/orderin g-query-result-by-list-of-values i'm not quite sure i understand what he's doing.... I think I might have found a possible solution (but it's ugly): tsql Line number On/Off | Show/Hide | Select all SELECT * FROM ProductGroups WHERE GroupID in ( 24 , 12 , 7 , 14 , 65 ) ORDER BY CHARINDEX ( ',' + CAST ( ...
Started 23 hours, 34 minutes ago (2009-12-02 18:39:00)
by RobertN128
It seems like I should be able to write a single LINQ to XML query to retrieve an XElement with a specific attribute value that is a child node of another XElement with a specific attribute value. I've Googled and searched this site and messed around with nested queries but I can't get it to work. Given the following XML snippet I want to retrieve the setting node with a name attribute value...
Started 1 day, 1 hour ago (2009-12-02 16:47:00)
by duckers9
Sum in Query Hi there I have a field "TotalProspectiveCredits" which is created by the following statement: "IIf([StudentModules]![Status]="Registered & Attended" Or [StudentModules]![Status]="Registered & Attended" Or [StudentModules]![Status]="Invited" Or [StudentModules]![Status]="pathway nomination",[Heas!credits],0...
Started 3 days, 16 hours ago (2009-11-30 02:11:00)
by thava
UPDATE Table1 SET col6 = t2.col1 FROM Table1 t1 LEFT JOIN Table2 t2 ON(t1.col1=t2.col3 AND t1.col4=5) The above query not working pls. correct me. Thanks, thava
Started 1 week, 1 day ago (2009-11-25 14:01:00)
by psycoperl
Multiple Counts in one Query I need to quickly view multiple bits of data and was wondering if there is a way that I can open 1 query and get quick access to the following information from my Roster Table I am hoping to not have to add many more queries to my database as it has alot in there and I am afraid of overwhelming my ...
Started 1 week, 1 day ago (2009-11-25 11:29:00)
by Trevor G
Code to Run Find Duplicate Query I am running several queries to come up with a list of records where there are duplicate records, which then needs to be checked. I am looking to automate this with a macro or vba, but what I cant get to run at this stage is the Find Duplicate query. The macro Action for OpenQuery and adding the ...
Started 6 days, 2 hours ago (2009-11-27 15:24:00)
by TFCJamieFay
Update Combo Box with SQL Query Hi all, I have a form with an option button group that, depending on which one is selected, populates a combo box with an SQL query. I've put together the following sub from various bits of code I got from the web but it's not quite knitting together. Can anyone see where I'm going wrong?...
Started 6 days, 5 hours ago (2009-11-27 13:00:00)
by EasyOne
Help with Access query Hi, I don't know if I'm missing something blatantly obvious but I have 2 tables showing the same field. I want to create a query which shows all the data that is in one of the tables but not the other. The join properties only seem to enable me to show the data which is in both. Can anyone help?...
Started 4 days, 10 hours ago (2009-11-29 08:05:00)
by Rajdip
Hi, I am getting expected raws after creating below query in access 2007 database (*.mdb). But when I am trying to execute it from Visual Studio DataSetDesinger DataTableAdaptor it dose not returns any raw. Kindly help. SELECT Salary.SalaryMonth, EmployeeMaster.EmployeeCode, EmployeeMaster.LastName, EmployeeMaster.FirstName, EmployeeMaster.MiddleName, Salary.LTA, ...
Started 4 days ago (2009-11-29 18:06:00)
by Song Su[_4_]
When export from query to Excel, I'd like to turn some columns into heading row on top of Excel sheets how to turn this: LastName FirstName SID Section Instructor Doe John 1234 0545 Su Doe Jane 2345 0545 Su into this? Class Roster Instructor: Su Section: 0545 LastName FirstName SID Doe John 1234 Doe Jane 2345
Started 4 days, 9 hours ago (2009-11-29 08:43:00)
by Pasadena-D via AccessMonster.com
Hello, I have a VBA Macro that Opens an Append Query (see below), which works great, except for the end user has to answer the following MsAccess prompts: 1) You are about to run an append query that will modify data in your table. (They have to click Yes) 2) You are about to append 1 row(s). (They have to click Yes) I'd rather them not have to answer either question. Instead I'd like ...
