Running & Setting Up Queries - Page 20

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.

		Home » OfficeFrustration forum » Microsoft Access
Running & Setting Up Queries

Home

Page 20 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
How can i pass a parameter to crosstab query by megeorge I want to set the criteria for the cross tab with a value entered on a form. I do this with normal queries but the cross tab won't recognize the field from the... ( 1 2)	September 3rd, 2008 04:44 PM by John Spencer	15	272
running sum in a query for a calculated field by SMT I have a qry to sum the planneddate field in my maintbl and groups it by month. I need the sum of those grouped totals in a cumulative format. See my sql... ( 1 2)	February 25th, 2008 05:45 PM by SMT	15	135
Form Combo Box - Lastname, Firstname, MI by Robert T We have approximately 4,500 students in tblStudents, and as you would imagine, there are numerous students with the same last name. I have a Find a Record... ( 1 2)	March 7th, 2008 02:32 PM by David W. Fenton	15	234
Groups by Age and Female, male by Totte via AccessMonster.com Hello Can sombody please help me, I saw the code below in another discussion group. I wanÂ´t use it but with more categories. how can i make it work? I would... ( 1 2)	March 26th, 2008 03:05 AM by John W. Vinson	15	219
Pass Through Query Code by Kevin I have the below code in a Pass through query that pulls from a Oracle DB. It is pulling data from 2002 through today. It takes 13 minutes to run and I... ( 1 2)	April 3rd, 2008 09:10 AM by Stefan Hoffmann	15	257
Summary query sum from different tables by BAC VISTA Enterprise/Office 2007 Plus situation: Two identically structured tables, and tables consist of contracts and assets with costs. there is a field... ( 1 2)	June 19th, 2008 09:46 PM by BAC	15	275
most close return by inungh I would like have a query or method to get most close value like following: Code Value A+ 95 A 90 A- 85 ( 1 2)	July 4th, 2008 09:39 PM by [email protected]	15	467
Search Date and Time by Floyd Forbes How do you query between dates and times in access? I am trying to query between #7/23/2008 6:00:00 PM# and #7/24/2008 6:00:00 AM# . How do I get this to... ( 1 2)	August 1st, 2008 12:30 PM by John Spencer	15	185
how to join similar records by confused!! example: two lists contain user ids. NT user id list is unique with only one per user. JDE user id list is not unique with multiple ids that contain the one... ( 1 2)	August 20th, 2008 10:51 PM by KARL DEWEY	15	192
Query for Parent containing only ONE type of child by Warren I am trying to find all offices that contain just ONE type of member. Each office can contain many types of members but I want to find those that have just... ( 1 2)	January 18th, 2008 03:52 PM by Jamie Collins	15	134
Marking addresses as preferred by Matthew[_2_] Hello, Here's my structu tblClients ClientID .... tblAddresses AddressID ( 1 2)	January 4th, 2008 11:07 PM by Matthew[_2_]	15	158
Query Not a Valid Name by Robert T Hello: Access 2003 I'm mystified by a series of basic queries in a database I originally created in Access 2000. They have simple names such as... ( 1 2)	April 8th, 2008 09:04 PM by Denise	15	226
When I open design view in a query I get "is not a valid name. by clopins I just upgraded to Office 2007 and in one of my database's, when I try to open my queries in design view, I get this message: "is not a valid name. Make sure... ( 1 2)	October 16th, 2007 01:11 PM by choosetolaugh	15	189
Create multiple queries in Access with a single sql statement by Corby Nichols Is there a way to create multiple queries with a single sql script, similiar to SQL Server 'Create Procedure' statement. I have a code generator that... ( 1 2)	July 2nd, 2008 02:52 PM by Klatuu	15	265
convert range of numbers in one record into range of single-number records by [email protected] I have a table of product registrations. All entries have a product number. Some entries have a single serial number, and some have a range of serial numbers.... ( 1 2)	July 28th, 2007 02:39 AM by John W. Vinson	15	141
How to set up Query? by teelee I have my database all built the only problem I have is how I would set up a Query for a Report. I have a Plan Name that can be sold to more then one person... ( 1 2)	September 14th, 2007 05:52 AM by Duane Hookom	15	93
Dynamic query problem by [email protected] Been trying to figure this one out for a while in my spare time by following an example I found in a book but it just isn't working for me. I figure if I can... ( 1 2)	October 18th, 2007 02:51 AM by [email protected]	15	172
max no group by ooxx Hi , Is there any solution for Max without grouping? There are different data and only one distinct on the row to display for the max value. For example,... ( 1 2)	November 23rd, 2007 12:17 PM by Michel Walsh	15	121
difference between date/time by dplove I have searched and found some good info but nothing is working for me. Please help. I have a query that has "Received Date Time and "Opened Date Time"... ( 1 2)	November 6th, 2007 09:28 PM by Duane Hookom	15	175
Interesting HR Database - Queries by Allie I am having 2 issues with an employee absentee database. Here is my set up -Table "Records" which contains all employee absentee information (name, id,... ( 1 2)	September 26th, 2008 02:18 PM by Dale Fye	15	176

Page 20 of 2165

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 12:45 AM.