Running & Setting Up Queries - Page 142

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
not = to in a query by LG I have a query and I would like not to include 142, 20441,16, and 101 from a field named CLT_ID. What would I need to put in the criteria in order to get...	October 6th, 2009 09:49 PM by John W. Vinson	1	124
Finding record between two Dates Queries by ashhush I have table named challenge and it has many fields such that ID, First Name, Last Name etc I want to find out the total number of challenge records that are...	October 6th, 2009 09:29 PM by Guitarzann	2	126
How to create a query to Concatenate by DawnTreader Hello All I need to take this: COID WOID 54621 04858 54621 04859 55106 10000 55106 10388 55384 10007	October 6th, 2009 09:26 PM by John W. Vinson	1	123
Count by lmossolle I am trying to get a Count where is less than 100000 i am trying to use the below listed but I am getting errors, could some one please...	October 6th, 2009 09:24 PM by John W. Vinson	2	98
query for max per item by rbeach I ahve a query with the itemID and Cost as per example below: ItemID Cost 1 1.15 1 1.25 1 ...	October 6th, 2009 09:23 PM by John W. Vinson	2	113
What is the best way to feed Form selection criteria to a Query? by Brad We are starting to investigate the use of Outlook to obtain data from various data sources. In most situations, we will have a simple â€œSelectionâ€ form in...	October 6th, 2009 08:35 PM by Marshall Barton	5	143
(And) expression by lmossolle I am trying to use this command i am getting an error; SAT to 1M=IIF(AND(100000,{KT Value]1000000),,"")	October 6th, 2009 07:30 PM by KARL DEWEY	1	96
Grouping data/Aggregate functions by MsDYJ I'm working with data that deals with deliveries. Items are shipped by different carriers each week. The carriers always remain the same but the data does...	October 6th, 2009 06:21 PM by Marshall Barton	2	97
Allow 0 in Avg expression by ladybug via AccessMonster.com I have this in query field Average: Avg(tblProductionDetail! intNew_Scripts/tblProductionDetail!intScript_Orders) This worked fine before, but the data now is...	October 6th, 2009 06:18 PM by John Spencer	2	119
Time Difference Between Records from the same field by Kevyn1980 The web site my company uses date and time stamps any journal entry a user will place in the web site. This data is kept in same field, how can I calculate...	October 6th, 2009 06:10 PM by JBW	2	89
FileSystemObject Type mismatch by NuBie via AccessMonster.com Given this declaration i got runtime error: 13 Type Mismatch. variable origin is a string containg the folder location. Dim fs As New FileSystemObject Dim f...	October 6th, 2009 05:43 PM by NuBie via AccessMonster.com	1	97
Creating automatic dates for renewal from 2 possible fields by Beech I am setting up a training database. I am trying to create a query from which to run a report that will show 3 columns next to staff names; one will show...	October 6th, 2009 05:30 PM by Jeff Boyce	2	107
MS Access Expression typed incorrectly or too complex by Ken Lewis The MS Access query below requires a date input. It runs perfectly with the dates 9/30/2009 or 12/31/2009, but fails with the subject error on dates of...	October 6th, 2009 04:15 PM by Ken Lewis	2	144
Parameter Query by RH Why is my parameter query asking for the same information (2) times. Example: AND . I have to input the information twice to get an answer from the query.	October 6th, 2009 04:01 PM by Jeff Boyce	3	112
Help book on access by Sarah I have beginner knowledge with Access - but I want to purchase a book that will take me to the next level and is easy to use. Can anyone recommend a good book...	October 6th, 2009 03:10 PM by S.Clark[_2_]	2	130
Keep name of source query in Union by William McNeill I have created a Union query combining the queries CEg, CMg, CSg, and CWg. Works great. I need to know if there is any way to keep the name of the source...	October 6th, 2009 03:09 PM by William McNeill	2	88
Problems when deleting data by Laurel I have a table that has a dropdown text column called "membership". If I enter data into the column, the person is marked as "non-member" or "associate...	October 6th, 2009 02:16 PM by John Spencer	2	97
Running Balance by Abdul Shakeel[_2_] Hi, I have a query in which I have fields TransactionID, AmountDeposit, AmountWithdraw I want to make an other field named Balance which shows diffrence of...	October 6th, 2009 02:05 PM by John Spencer	5	129
Limit the results from a calculated field in a query by Helen Smith I have a field in a query which calculates items in stock ie: Balance: - but I only want it to return values greater than 0. If I enter 0 in the criteria...	October 6th, 2009 09:59 AM by Helen Smith	7	118
showing records where one field is duplicated and another is not by tdp How would I write a query to do the following? Field X Field Y 1 A 1 B 2 C 2 C 3 ...	October 6th, 2009 03:35 AM by tdp	2	89

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