Running & Setting Up Queries - Page 1061

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
Number of columns error by John Hi All, First Happy New Year to all, Second: I have a query that was working fine. The database admin changed one of the fields in a linked table from number...	January 2nd, 2007 09:17 PM by John	3	85
Missing Date due to no data in crosstab query by DMUM via AccessMonster.com hello i have a client who wants a report that shows all hours worked for each employee for the period of 7 days. They only want to put in the end date...	January 2nd, 2007 09:12 PM by Duane Hookom	7	132
DatePart qn by Monish The code below was working until this week (i.e. 2007)...hoping someone has a suggestion on what might need to be different: Week Tracker:...	January 2nd, 2007 08:59 PM by Monish	2	92
How to get lettercount for each word in field by bsgoldbg I have a field containing a description of a product and I want to identify all descriptions containing words greater than x characters long so that I can...	January 2nd, 2007 08:09 PM by John Nurick	3	103
zero's in a query by Melinda In a query I am calculating dates, in five different intervals, Expr1: -NZ(,Date())+1, i have 5 different expressions and then I am adding and subtracting...	January 2nd, 2007 07:29 PM by Melinda	5	73
Build a table depending on a date range. by CD Tom I have this working by using the parameter settings in the build table query. What I'm wondering about is there a way to use a form to select the dates and...	January 2nd, 2007 06:39 PM by Michel Walsh	1	91
Can I use a cell reference in an Excel worksheet as criteria to fi by Jasen I want to use a cell reference from Excell to edit Access Database queries in the same Excel file. I have fifteen seperate queries that will be changed on a...	January 2nd, 2007 06:25 PM by Michel Walsh	1	78
Table Update by shannyshan Hi, I was wondering if someone could help me. I'm designing a database. I have 2 fields in my table. 1 is for intermediate products and one is for...	January 2nd, 2007 06:20 PM by Michel Walsh	1	73
Make Table - Number Data Type by TimT Happy New Year all! here's my first question of '07..... I'm trying to run a make table query whereas it should create the following fldJuridiction text data...	January 2nd, 2007 06:10 PM by Michel Walsh	3	76
Saving formats in SQL view. by John T Ingato Is there any way to save SQL formatting with a saved query, Instead of the SQL all being bunched together? It is easier for me to visualize what is going on...	January 2nd, 2007 05:13 PM by John T Ingato	0	82
Need help with query by Elena Hi All, I need nelp with query i am using Access 2003 and VB 6.0, I have 2 table with fields like: TickNo Date Time Unit ID More fields ... 50001...	January 2nd, 2007 03:29 PM by Elena	0	65
Help! by tk Hi, I have 5 tables within my database: course, course leader, organisation, booking, and delegate i want to create a query that counts the no. of delegates on...	January 2nd, 2007 01:32 PM by Jeff Boyce	1	95
SQL Syntax for SELECT within SELECT by Greg Hi, I hope someone can help me here I have 3 very similar queries. QryLeg1: SELECT lngFlightPlanID, lngAirportID FROM AAFP_tbl_FlightPlanLeg WHERE...	January 2nd, 2007 12:40 PM by Van T. Dinh	9	105
Query to find results that do not exist yet by Leonard Hi I'm a teacher creating a database to store the results of my students. I have a tblStudents - listing students tblAssessmentItems - listing tests,... ( 1 2)	January 2nd, 2007 10:34 AM by Ken Sheridan	10	157
Operation must use an updateable query by Taylor I get this error everytime I run my query. I am basically trying to copy a field from one query to a table (the query and the table are joined by a unique ID)....	January 2nd, 2007 01:07 AM by John Vinson	1	66
Maximum number query by [email protected] I have a list of values that I want to change to have a maximum of 100. For example, if the value is 330, the result should be 100. If the value is 50, the...	January 1st, 2007 11:23 PM by [email protected]	3	72
Query Calculation Help Please! by DN I have asked and received great help from this list and I hope this time is the same. I need to calculate points based on the number of entries and the...	January 1st, 2007 06:52 PM by DN	4	79
Form closing problem by John Hi I have a form with a list box. The list box is bound to a query which has below as the parameter; !! is a drop down on the same form. So when a user...	January 1st, 2007 04:43 PM by John	2	68
Last transaction date & POCost by Samantha I need to get the last POCost from the transaction log from 2 tables: TrxnHeader and TxnDetail. Fields from TxnHeader: TxnType, TxnDate, TxnGroup Fields...	December 31st, 2006 06:56 PM by Ken Sheridan	1	92
query criteria that will include all by denise I have a between date field and I want to include all date if the parmeter is blank. How can I do that?	December 31st, 2006 05:50 PM by Douglas J. Steele	4	91

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