Running & Setting Up Queries - Page 490

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
Iff statement - current or expired contracts by Chey I have a query and I am trying to add this columm to analyse if the contract is current or expired. Somehow does not work. Please help Expr1: IIf(="Cont."...	July 23rd, 2008 07:06 PM by Chey	3	83
Data Collection from Two tables by Lisa I have two tables that have some of the same data types and i want to bring them into a query together with a new column that indicates what table they came...	July 23rd, 2008 06:00 PM by Bob Barrows [MVP]	2	97
Slow running queries/macro by blavine Just switched over to 2007 from 2000. I have converted all my databases to 2007. One job that I run (8 queries in a macro) used to take about 5-7 minutes on...	July 23rd, 2008 05:10 PM by blavine	0	66
Limit query to one result by Stickman64 Hi and first let me say I am a new user so thanks in advance for your patience and help. I am trying to run a query that will list the next available meeting...	July 23rd, 2008 05:07 PM by John Spencer	7	79
max. # of "AND operator" in criteria by sb2008 Have been asked at work to find out the maximum number of AND operators you can have in the Criteria field of a query in Design mode (Access 2007). Have been...	July 23rd, 2008 04:03 PM by sb2008	4	80
ACCESS 2003 Data entered thru form not picked up by query by mrsapj I am working on a database started by someone else. It consisted of a table with data already in it. All the data was entered directly to the table. I...	July 23rd, 2008 03:48 PM by mrsapj	0	87
Is there a way to make positive numbers appear as +XX ? by MC Hi, I have a query with two calculated fields with the following formulas: Usage Change over Quarter: nz(,0)-nz(,0) Percent Change in Usage over Quarter:...	July 23rd, 2008 03:45 PM by MC	4	97
Create a BOM query by Jasper Recto I am trying to create a query that drills down and creates a parts list. We have a database that has their parts in one table (tblParts). There is another...	July 23rd, 2008 03:10 PM by Arvin Meyer [MVP]	1	106
Complex group and sort query to find top record for each group by pb100 Hi, I have 2 tables, a project table and project status table. My project status table has a record for each time the status of the project was changed...	July 23rd, 2008 03:01 PM by pb100	1	90
Parameters in Query by Anthony I have a query and there is a trans time field and it is in the form of 7/22/2008 8:30 PM and I would to make a parameter query that asks you for the start...	July 23rd, 2008 03:00 PM by Rus925	3	74
Union Query Based on Two Crosstab Queries by ryguy7272 Is it possible to do a union query based on two crosstab queries? I have 639 records in one crosstab query and 225 records in another crosstab query, for a...	July 23rd, 2008 02:06 PM by Bob Barrows [MVP]	4	123
Dividing by zero in a calculated field of a query by MC Hello, I'm a first time user of this forum and most of my Access 2003 knowledge comes from trial and error, so please be patient :-) Here's my problem. I'm...	July 23rd, 2008 02:02 PM by Bob Barrows [MVP]	4	80
Calculation wrong in sum query by HeatherD25 I think this should be a simple query to do, but I can't get the sum values correct. Here's my query: SELECT qRpt_EmployeeCOS_1.EmployeeID,...	July 23rd, 2008 04:47 AM by HeatherD25	8	77
Changing text field to Date by metalone I am linking to a text file and I need to change the date field "Posting Date" to a Date type. I am trying to use this code that I found on this site: Expr1:...	July 23rd, 2008 04:38 AM by metalone	3	92
Time in 30-minute increments by caloy I have intraday data with Date/time values. I want to be able to aggregate the time into 30-minute segments. What functions or expressions can I use? --...	July 23rd, 2008 04:13 AM by Allen Browne	3	91
Display Relationship Name so I can drop it by Alan Rose Hi I need to find the name of a relationship between two fields in different tables in access, so I can drop the relationship (constraint). How do i find out...	July 23rd, 2008 03:42 AM by Alan Rose	4	149
Query records that expire (date) in XX days by 4saken I have a table that holds a field called "Expiration Date." On the query, how can I get a pop up that prompts the user to enter the number of days left...	July 23rd, 2008 01:57 AM by smartin	5	143
A tricky select Query for me by swark Running MS Access 2000 ver 9.0.3821 SR-1 I have a table thus: (ID)(project name)(level) 1 xxx 1 2 xxx 2 3 xxx 1 4 xxx 1 5 xxx 1 6 xxx 2 7 xxx 2	July 23rd, 2008 01:52 AM by Bob Barrows [MVP]	5	95
ID numbers in Access records. by theIThombre Question Gang, I am new to Access 2007 and had a question about the id numbers that begin every record. I noticed that once I delete a record, that the...	July 23rd, 2008 12:35 AM by John W. Vinson/MVP	1	96
error msg by aubrey Hi, I've created a form and i'm trying to enter data. Whenever I try to save that data i get an error msg, "Error â€˜Error evaluating CHECK...	July 22nd, 2008 10:28 PM by John W. Vinson/MVP	6	100

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