Running & Setting Up Queries - Page 513

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
Putting values in different columns based on calculated intervalls by Bell Hi, I'm trying to do the following. I use a query to calculate the difference between two dates for a specific invoice. Then I want each customer to be shown...	September 22nd, 2005 10:19 AM by Bell	2	71
How to arrange names to create pairs of names by aeronav Hi ! I have a table of Agents with ID_Agent as primary key and LastName as text field, ex. ID_Agent LastName 1 BOBET 2 MAGNE 3...	September 22nd, 2005 10:46 AM by Baz	3	203
concateneren in access by Webmaster How can you several text fields concateneren in access in 1 query to 1 text field? Bijv. Text1 = 1111, Text2 = 2222, Text3 = 3333. the result must...	September 22nd, 2005 11:15 AM by Ofer	1	74
Query in a loop by Peet If I set relationships between my tables, my query does not read from the tables. If I delete the relationships, my query starts to multiply the data in the...	September 22nd, 2005 11:40 AM by Peet	4	100
Query-Same Line Date/Time/Min Qty by mag I have a query where I am trying to get the same date and time where the min qty occured. Example: Table: Date Time Qty 1/1/05 1:00pm 3 1/1/05 ...	September 22nd, 2005 01:36 PM by Jeff Boyce	2	114
Populate one table with values from another by Sean I have two linked tables in my db. I need to pull all the values from tableA and insert into tableB where tableA.id = tableB.id Here's my SQL query, which...	September 22nd, 2005 02:21 PM by Sean	8	100
Match Mutliple Columns by Sean H Hi, I have a shipment file where I need to match 3 columns that are the same (order #, ship date, and cosignee #). Usually there are about 10 rows...	September 22nd, 2005 02:56 PM by Sean H	4	106
Keep Count of Query Output Records by bgcpen Hello, I've got a query that is searching through the body of an email message. I have it getting the target text by using the mid function. Is there any way... ( 1 2)	September 22nd, 2005 03:32 PM by bgcpen	10	163
Count does not give me 0 by Minnow I want to count how many orders a customer placed in a month, in the case of a customer did place order in that month, I want it show me 0. Unfortunately, my...	September 22nd, 2005 03:57 PM by Michel Walsh	7	102
Why might a query drawn from three nested tables refuse to update? by Zea's Legacy The outer form is based on the 'Site' details table and the main form for all input of data. Nested in the 'Site' details form is a form for identifying each...	September 22nd, 2005 04:52 PM by Michel Walsh	1	194
Make count = 0 where no row is returned. by Roger Hembury Hi This has probably been asked quite a few times but I cannot find the solution on Google so apologies for asking again. I have two tables and I want to get...	September 22nd, 2005 05:00 PM by Michel Walsh	7	160
Switch and IIF both give me an extra data Line. by rhoisy If I use this line: Expr26: IIF(!=!,!) I get two duplicate line in my out put. One with this expression with the correct data (the data I expect) then I also... ( 1 2)	September 22nd, 2005 06:08 PM by rhoisy	12	423
Names query by Rowan -- Rowan I have a table with 50 peoples names in some of the names appear more than once. How do a make a query to extract any name that appears more than...	September 22nd, 2005 06:37 PM by Duane Hookom	1	104
Query using > and dates by emanw I am trying to write a query using #8/1/2005#, however, this expression does not produce the results I was hoping for. I am trying to pull information from...	September 22nd, 2005 06:49 PM by Chaim	2	75
Updating Multiple Fields in a Query by Will Lastname I am trying to update 2 fields in a database that match a certain criteria. The SQL I am using is: UPDATE tblProducts SET Version = "TEST" And...	September 22nd, 2005 07:32 PM by Chaim	1	71
Combination of Field not empty by YDN Hi with you all, I can't obtain what I want with my queries. I've got a table with a lot of fields witch I only want to test Not null case. Sample of...	September 22nd, 2005 07:49 PM by YDN	2	88
Creating a counter by Luther Hi, I would like some help doing this. I have created a field that would hold these values, called PLANCOUNT. I have 12 different check box fields that I need...	September 22nd, 2005 09:06 PM by Luther	2	81
Those two 'Testing' posts by Chaim They now show as having been sent on '9/29/2005 5:16 PM'. I'm using Outlook Express as my news reader. Is there a way to either get rid of them or reset the...	September 22nd, 2005 09:35 PM by Chaim	2	70
using memory variables in a query criteria by paulpenta I have a form with the field "Control_Number". I want to store the value contained in that field as a variable for use as a criteria in a select query. How do...	September 22nd, 2005 09:37 PM by '69 Camaro	3	88
Summary Report by Rod I have a tblCandidates. Calls are made to candidates. The date the call is made is stored. The result of the call is stored, i.e. "message" left. ...	September 22nd, 2005 09:52 PM by Rod	2	85

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