Running & Setting Up Queries - Page 516

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
IF THEN query in SQL by richardb I am trying to write a query in Transact-SQL to create a user view in my SQL database. I am trying to populate columns for each "aging" category (30, 60, 90,...	September 25th, 2005 03:43 PM by TipTop	4	128
Append "current record" query by Aron I need to be able to copy my current record and then paste most of it as a new record, I don't want to duplicate all fields, I just want to duplicate some...	September 25th, 2005 03:55 PM by Allen Browne	2	101
Copying a record by AkAlan I need to be able to copy a record and then paste most of it as a new record using a form.	September 25th, 2005 06:31 PM by Marshall Barton	3	106
Use of global variables in Queries by aspgk Is there a way to set global variables in an Access database and use those variables in queries, without having thoes variables reside in a table or query...	September 25th, 2005 07:56 PM by Amy Blankenship	6	118
Append Query & Linked Tables by Karl Burrows I have an append query that worked great pulling in data we are converting from another source. As the fields in our database increased, I split it into some... ( 1 2)	September 25th, 2005 10:15 PM by Sassy Baskets	10	137
help with sql by John I keep getting enter parameter value for all the mods.whatever I tried to enter a FROM paymenthist, mods but then I got a different error UPDATE...	September 26th, 2005 03:13 AM by John Spencer (MVP)	4	92
Using Access to try SQL codes by J_J Hi, How can I try some SQL commans or codes with access? Regards J_J	September 26th, 2005 06:45 AM by J_J	7	121
How use the query to find unit stock? by pipath How can I query in order to find the inventory unit? If my purchsing units and sale units are in seperate tables. I can use query to find the purchased unit...	September 26th, 2005 01:41 PM by MChrist	1	400
SQL For Next by SLeach Could someone help me identify my error in the following SQL statement: Public Sub DailyRun() For x = 1 To 2 DoCmd.RunSQL "SELECT into tbl1 FROM WHERE...	September 26th, 2005 02:46 PM by SLeach	2	65
Vague match/match partial information by frank I have two tables and each of table has several fields. The first table contains information about news stories (date, time, headline etc). The second table...	September 26th, 2005 04:56 PM by John Vinson	3	88
Help to append flat file table to two tables by Victoriya F via AccessMonster.com Hello, Can anyone help me with this problem? I need to append a flat table to two tables. I have two tables Observations and ObservationsB that are set up... ( 1 2)	September 26th, 2005 05:30 PM by SteveS	11	1,115
How do I automatically return data from last two days? by waybomb What would I use in the Criteria section of a querry that would return only data from the last two days? We ahve a small database of work orders for our...	September 26th, 2005 05:43 PM by John Vinson	4	113
Using Select Distinct with * by quartz I am using Office 2003 on Windows XP. The following SQL string will create a new table containing a unique list of account distributions only: SELECT...	September 26th, 2005 05:44 PM by Michel Walsh	4	99
Query with more than one table by paulpenta I have a query using 2 tables. There is only one field from the second table in the query. Works great but will not let me edit the values in any of...	September 26th, 2005 05:48 PM by Michel Walsh	2	79
Retrieve Cumulative infor by JOM I have a table that has a date field in in it. I would ike to create a query that uses that date field and collects a total of all the rqsts upto that date...	September 26th, 2005 07:41 PM by JOM	6	150
Update Query by Mary M If you have a text field with a length of 10 ex. 1234567890. How can you write a qurey that will update a field with a length of 4 with the 3rd,4th,5th and 6th...	September 26th, 2005 09:15 PM by Brendan Reynolds	1	86
Select latest recorded record in Access crosstab query by mgidron I have a table that logs timestamped records. How do you select the latest timestamp records for all items? Example: With Item id 3, listed below I want only...	September 26th, 2005 09:26 PM by mgidron	2	92
Searching for Peoples Names by Ambu-Al I am creating a database where I need to search for a person (patient) from a list of patients in a table. I have set up a form with a textbox (SurnameFind)...	September 26th, 2005 10:03 PM by S.Clark [Access MVP]	1	85
Interesting Question by Blaze I have a pretty interesting situation where I need to compare database elements against eachother. Db1 = data feed from jailnet.us(can NOT write to) Db2 =...	September 27th, 2005 02:00 AM by Blaze	4	129
Change attributes from "read-only on CD-RW by Lucky How do I change the attributes on a CD-RW from "read only" so I can edit?	September 27th, 2005 02:09 AM by fredg	2	118

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed