Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Join a query with one of the Tables used to generate the query
- Hi to everybody,I would like to know if it's possible to do this in MSAccess SQL:Select * FROM (table1 LEFT JOIN table2 ON table1.field1 = table2.field1) LEFT JOIN table2 ON table1.field2 = table2.field1Note that table2 is being used twic
- Tags: join, sql, programming, access, software, microsoft, windows, Table2, LEFT JOIN, rayasta@..., Table1, Table1.field1
- Discussion threads 2006-12-13
Additional Resources
- Access Query
- Hi all, hoping you can help me with a probably simple task.In running a query i would like to be able to submit any amount of a parameter to bring back all information related to one or many ObjectID's.Any ideas how i can perform this task?Sample code looks likeSELECT Field1,...
- Tags: jim@..., Microsoft Access
- Discussion threads 2007-03-16
- Asking twice on MSAccess 2003
- Hi to all!I've an issue that I really have no idea why is happening...When I FIRST run the query shown below, it's asking me twice the field "[PLC]". When this happens, I only need to insert the value I'm looking for on the second pop-up window.SELECT *FROM Table1 SWHERE (((S.Field1)...
- Tags: PLC, rayasta@..., S.Field1, S.Field2
- Discussion threads 2007-02-01
- Access-AutoNumField on ImportSpec
- How do I add an AutoNumber Index Field on the Import Specification in MS-AccessChris, you can't add an autonumber field to an import spec.You need to add the field after the importrun imporrt then to add an autonumber to your table run the following SQL, modifying as required.alter table table1...
- Tags: Field1
- Q&A 2005-06-27
- extract text from comma seperated values in a text box
- hi guys, girlsi have users entering words in a text box seperated by commas. i need to use those words as values in a search. there might be only one word, but then there might be twenty or only three. i need my code to extract the words there and...
- Tags: carterlangley@..., comma
- Discussion threads 2007-05-02
- SQL Question: When the Pivot data contains a Key Column (and character data at that!)
- I recently wrote about pivoting (or is it unpivoting?) some data. A new wrinkle has been added.Let's say that the data now looks like this:INSERT INTO X ( FIELD1 ) VALUES ( 'row1,1,2'); INSERT INTO X ( FIELD1 ) VALUES ( 'row2,2,3'); INSERT INTO X ( FIELD1 ) VALUES...
- Tags: Field1, INSERT, SQL, VALUES
- Blog posts 2006-07-06
- Changing field properties on tabular form (MS Access)
- Hi,How to change field properties on the tabular form depending on values of certain fields?F.ex. if the Field1 on record1 has value 0 then I want to show the Field2 value on the same record in red. If I use the following VBA code for the onCurrent event on that...
- Tags: Microsoft Access, Microsoft Corp., oguintch@...
- Discussion threads 2007-10-15
- Reset ID Autonumber counter field on Table in Access
- Hi, I import data from a text file into an existing table. The text file has no column headings, so I delete all records from my existing table and populate it with data from the text file each tim. I need the ID autonumber field. However, the...
- Tags: chris.chetty@..., DAO, ID, ID Autonumber, Microsoft Access, software, SQL, text-file
- Discussion threads 2005-06-24
- Access report w/conditions
- I am working on an access report that displays records depending on the conditions of multiple fields from a query. If ([date1] [date2]) and [fieldA] is false. The fields in the report are the same for each of the 3 sections. It should look something like this:Report Header (once...
- Tags: Microsoft Access, birdbyte@..., Records Field1 Field2 Field3, Second Group, fieldA
- Discussion threads 2007-08-13
- summary query?
- Right now i have a query on top on another query for a certan count. I'm wondering if there is a way to turn it into a single query.the data is say 1,2,3 time day count.For report/query I need to pull 1,2,3 into say 1-5 and add them together...
- Tags: natasha.epperson@...
- Discussion threads 2005-03-22
- Raffle Tickets
- I want to have it so that if some one pledges £5 on one table. At the click of a button another table is updated with 5 tickets allocated to this person.check out how this is done with the indispensible northwind.mdb sample database free for download from microsoft. the really...
- Tags: simonevans31@...
- Q&A 2005-01-26
- Performing a search of my DB in Access using data access pages
- Hi all -I am trying to run a search of my DB through a query using a couple of fields as a front end wild card search. Ex. DB Field1: NAMEwild card entry1: FUNDB Field1: AGEwild card entry1: 23SEARCHI am creating a WHERE statement of [NAME %FUN% AND AGE...
- Tags: Microsoft Access, aczocher@..., data access, wild card, card
- Discussion threads 2007-03-26
- Nested Select statements
- Has anyone ever used a statement like this:Select column1, column 2, (select columnA from table2) from table1 where....?This is contrary to anything I have ever seen in SQL (especially ANSI/ISO SQL), and I would appreciate your comments. ThanksSKNo I haven't, not once in in 17 yearsmore to the point...
- Tags: Databases, shelley.kuebler@...
- Discussion threads 2007-11-19
- how to optimize a update query
- i am using sql server , and try to update a table a single field with a update query " update table alpha set field1='23' where field2='asd'"now i have to run this kind of query 70 times/sec .Now in some cases query takes 7 ms to complete , but some...
- Tags: Databases, amitbharadwaj@...
- Q&A 2005-07-01
- create select query with diff. mdb files
- i created two ms access database to hold my data.how can i create a select query that will include the table from the other database?can someone please help me..............?any strategies/techniques/ideas will sure be of help.thanks.You need two Queries. One with Select command for one table, other with select command for...
- Tags: Storage, Databases, database
- Q&A 2006-01-06
- SQL code in vb join > 3 tables
- how do i code in vb6 joining 3 or more tables in. it would be ver helpful oif you can help. thank you..SELECT whateverFROM (table1 LEFT JOIN table2 ON table1.key=table2.key)LEFT JOIN table3 ON table1.key=table3.key;
- Tags: LEFT JOIN
- Q&A 2005-07-18
- Passing parameters from VB6 to SQL
- Dim intVal as Integerintval = 2020qconn.Execute("Select * from Table1 where userid=intval")The question is how can I make sql recognize or accept intval as a predefined variable in VB6 and run the query with resultset based on the value of intval?You need to ensure that the substitution takes place before the...
- Tags: Table1, SELECT
- Q&A 2005-11-10
- Unable to add date to access database
- Hi I am trying to add a date field from vb 2005 to access database. However when I try to run the following code I gets error message that reads "Syntax error in INSERT INTO statement." Any help regarding this is highly apprecited. [code]Imports System.DataImports System.Data.CommonPublic Class Form1 ...
- Tags: Databases, database, hemant.mukherjee@..., Table1, ByVal
- Discussion threads 2007-10-28
- Trouble Querying Database
- I have a table with a list of issues includes duplicates associated with a file name. There is a separate query that's linked to this table by file name and includes about 10 calculated fields associated with the file name no duplicates. I would like to create a query that...
- Tags: CR2
- Discussion threads 2006-08-16
- Parameter Passing to Crystal Report
- I am using Crystal report 10. I developed report with subreport. I used sql queries joined with union all having different selection criteria. I need to pass from & To Date as parameter to main report & same parameter to sub report also. But I am not using simple condition...
- Tags: riteshkhare@...
- Discussion threads 2007-04-09
- << Previous
- page 1 of 1
- Next >>
