Running & Setting Up Queries - Page 999

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
Excluding information from queries by scott5 Hello, I am trying to run a query using two different fields which both contain dates. I am running the query to determine the total number of individuals...	February 22nd, 2007 07:43 PM by KARL DEWEY	1	140
IIF question by Sung I am trying to use an expression to pull data based on a date range. If the date range is null, then I want the query to pull all records. I have a form...	February 22nd, 2007 07:43 PM by Sung	3	115
Selecting multiple "maxes"/latest actions? by Richard Perry OK, folks, I'm stumped on something. I'm putting together a vehicle service database. For multiple vehicles, there are multiple service actions required at...	February 22nd, 2007 07:32 PM by Richard Perry	4	136
Self-joins by Alisa I have a table where we need to select unique records based on three fields (i.e., those three fields are acting as a primary key). They are not true...	February 22nd, 2007 06:38 PM by Ken Sheridan	2	139
Rating system: Query to get a rate for each entry found. by [email protected] Hi I currently have 2 tables with this information: MoviesTable: ID - Autonumber Title - Text Rate: RID - Autonumber ID - Int	February 22nd, 2007 06:15 PM by Jason Lepack	3	128
Checking against input mask by Jason I have a field imported from an external database that is often entered incorrectly. I would like to have a query to pull all data that doesn't meet a...	February 22nd, 2007 06:10 PM by Jason	2	139
Need a healthy dose of query vision by stephanie Hello. I have a query and report that worked well until the situation changed. Always the story! Length of service was calculated by MemberDate against a...	February 22nd, 2007 06:08 PM by stephanie	1	119
automating pay rate changes by speederpro Hi I have two tables. One that track number of hours that an employee work (tblHoursWorked) and has a date field on it. Another table that show the hourly...	February 22nd, 2007 05:17 PM by speederpro	2	111
Queries/Reports not showing records by TracyM Hi, hope someone can help I have created a database that logs projects coming into the dept, it all works fine. I have also created a data access page so the...	February 22nd, 2007 05:15 PM by Jason Lepack	7	166
SQL to update a table from values within same table by Steve S I am trying to update a field in a table with the first corresponding value in a small (30-40 records) subset of records in the same table. Any and all help...	February 22nd, 2007 05:08 PM by Steve S	0	120
Parameter prompt and constant exclusions. by Jim Moberg Hi, I am setting up a query that will prompt the user to enter one of our clients to filter for each time it's run. My question is in regards to when a...	February 22nd, 2007 05:04 PM by John Spencer	3	161
Adding Sequence number based on Date by [email protected] Adding Sequence number based on Date I am trying to update a "table" by adding a sequence number that increments by 1 but resets upon a change in...	February 22nd, 2007 04:25 PM by [email protected]	0	117
Query sorting problem by sarah hi I'm having a problem sorting a query and I'm not sure why. The query's fields are : ID, A1,A2,A3,A_fin, B1,B2,B3,B_fin, C1, .... , D3,D_fin, ...	February 22nd, 2007 04:04 PM by John Spencer	5	142
Basic query questions concerning a linked FoxPro table by Seth Schwarm First I will qualify - this is the first time I have ever linked to any type of data via ODBC. So the root of my question may lie in my inexperience with...	February 22nd, 2007 02:53 PM by Cindy Winegarden	5	172
Lookup Function by msandomir I was wondering if anyone knew of a function in Access 2002 that will allow me to look up a date within a date field, determine which start and end date...	February 22nd, 2007 02:53 PM by msandomir	0	130
Blank Form by KenP I have two tables in database. One table holds individual demographic data and a 5 digit record # field. The record # field is unique in the demo table....	February 22nd, 2007 02:52 PM by Jerry Whittle	2	131
how do i make my criteria for a query where a field = x character. by mdkryptoking how do i make my criteria for a query "where = x characters in length"? I figure it has to do with the Len function but i cant figure out the syntax. Thank...	February 22nd, 2007 02:41 PM by Van T. Dinh	2	127
Forcing an expression to be a number, not a string by John T Ingato I have included the SQL below: This is a total query that calculates total dollars sold out of each of the 1800 stores. As some of the stores have just... ( 1 2)	February 22nd, 2007 10:38 AM by Jamie Collins	11	243
SEPARATING DIFFERENT DATA TYPES STACKED IN THE SAME FIELD by jlc I IMPORT FROM A SALES DATA PROGRAM THAT STACKS SALES ORDER# AND SALES PRICE IN THE SAME FIELD. I USE AN AUTO ID WHEN I CREATE THE TABLE. THE IMPORT LOOKS...	February 22nd, 2007 01:56 AM by jlc	6	139
Web Based Discussion Groups by Dale Fye when you search the discussion groups using your website (https://www.microsoft.com/office/community/en-us/...) the results of the search do not appear to be...	February 22nd, 2007 01:34 AM by Dale Fye	2	170

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