Running & Setting Up Queries - Page 193

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
Table subtraction by mattia How can I display the values in a field that are NOT in a table but are in another one? E.g. Table #1 ID 1 2 3	July 22nd, 2009 09:13 PM by mattia	3	206
Query within a report by briana.askew[_2_] Here's what I have so far: Every month I pull a bunch of reports from a website. I work for the Army and it is a list of names of people in different Army...	July 22nd, 2009 08:55 PM by John Spencer	1	133
Create a new table and set the fields type by mattia Hi, I need to create a table B based on a table A and set two new fields. The new table field shall have Numeric and Yes/No as data type. Here is the query I...	July 22nd, 2009 08:44 PM by mattia	4	123
query grouping issue by pat67 Hello All, I am running a pool league and I am trying to create a query to show each player's record vs other players. By the same token, each team's record...	July 22nd, 2009 08:00 PM by pat67	4	185
QueryDef Field Properties -- CAPTION? by DonS I used to extract the CAPTIONS property from the fields in QueryDefs. I was hitting Access 97. I was using code like... ...	July 22nd, 2009 07:14 PM by Dale_Fye via AccessMonster.com	1	165
Including form controls as fields in a query by jaf I have converted an Access 97 database to an Access 2003 database. I have queries that include the value of controls on a form (i.e. StartDate & StopDate)...	July 22nd, 2009 06:55 PM by jaf	5	194
Wildcard parameter query not working by Ann Scharpf I'm running Access 2003. I've looked at the posts here and thought I had done the wildcard correctly but I am getting no results for data that I know does...	July 22nd, 2009 06:12 PM by Clifford Bass[_2_]	5	144
show text instead od ID by Miami5 via AccessMonster.com hello. I'm trying to get the query and report to show the sport (ex Football instead of the sport_ID which is what is stored in the table. sport_ID is the...	July 22nd, 2009 05:34 PM by KARL DEWEY	1	149
Query that will display record if it has 3 or more YESes by ghostman via AccessMonster.com I have a training record query with a YES/NO field. I want it to display the YES answers ONLY IF the records has 3 or more YES answer... ex. if i have 5...	July 22nd, 2009 05:10 PM by ghostman via AccessMonster.com	7	181
Rounding up .5 in a calculation by zombeese I am running a query which is used to audit billing amounts. The billing program rounds numbers up when the is .xx5. In other words, 163.50 * .71 = ...	July 22nd, 2009 04:48 PM by MGFoster	1	108
Convert dense_rank and row_number sql server functions to access by Hatic Hi, How can I convert these two rows to access sql? dense_rank() over(partition by field1 order by field2) as name1, row_number() over(partition by fld1,...	July 22nd, 2009 03:31 PM by vanderghast	2	624
Calculate hours worked outside regular shift using date/time and iff condition by access_learner via AccessMonster.com Employee Shift_Starts Shift_Ends Regular_Shift_Starts Regular_Shift_Ends John 06/01/2009 06:00:00 06/01/2009 14:30:00 06/01/2009...	July 22nd, 2009 03:26 PM by Allen Browne	3	122
Problem with Query Calculation by Rene Good afternoon, The query has the following six columns (Totals Query): Column 1 (Group By) Month: Format(,"mm") Column 2 (Group By) Year:...	July 22nd, 2009 01:51 PM by vanderghast	5	151
Today's Date in Update Query by Irwin109 Ok, yet again a problem with Access! These queries have been working until yesterday (which is the mainly baffling part). Using Access 2003 and Windows XP Ok... ( 1 2)	July 22nd, 2009 12:41 PM by Irwin109	10	230
Student classes completed by Tony I have a query that returns student listing of courses completed. I would like to prepare a query or report that results in students who have completed a...	July 22nd, 2009 05:22 AM by Duane Hookom	1	140
Combo box automatic number propogation by Mary I would like to have a combo box automatically generate the numbers 1-110 rather than having to type them in. Is this possible? Thank you for your help and...	July 22nd, 2009 05:10 AM by Marshall Barton	4	123
Display in Landscape by Pepe Lepew IAM I am trying to display a Query in Landscaps mode when it comes up. How do I do that? I tried the help that comes with the program and that does not help me.	July 22nd, 2009 02:37 AM by John W. Vinson	1	99
Selection Criteria: Problems with Or by Sagebrook I need to select records where a field equals "091s" or "091S". Here is what I've tried: If I use "091s" Or "091S", I only get records with "091s". If I...	July 22nd, 2009 12:00 AM by KARL DEWEY	4	177
Top 5 grouping of material based on usage by Matt I have a table that has material, customer name, region, and 24 month usage. Primary keys are set on material, customer name, and region. What I'm trying...	July 21st, 2009 10:04 PM by Matt	3	154
'Database has reached maximum size' by John F. ACCESS 2007 query Two months ago, I created a small database (20MB), consisting of two tables - '34rows x 5columns' and '353rows x 6columns', I have now...	July 21st, 2009 06:25 PM by Jerry Whittle	4	160

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