Running & Setting Up Queries - Page 110

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
Alternative to compound IFF statement? by wellmabt Currently I have about 20 years worth of data and each record has an occurence date. I want to append a column to the table that gives the policy year. The... ( 1 2)	August 21st, 2008 02:08 AM by Bob Barrows [MVP]	12	149
Alternative to domain functions? by BruceM[_2_] I have several queries along the lines of the following: SELECT tblInsp.InspID, tblInsp.I_EquipID, tblInsp.InspDate, tblInsp.EquipMgr,...	April 18th, 2008 07:56 PM by BruceM[_2_]	2	104
Alternative to group by by Ed[_17_] Is there an alternative to using the totals button for grouping together records by one field and totaling another? Like this: ID# QTY ...	March 26th, 2009 09:59 PM by Ed[_17_]	7	93
Alternative to GROUP BY ALL (sql server) in Access by sandokan I'm trying to use a GROUP BY ALL function in an access database migrate from sql server. Is there any alternative to the GROUP BY ALL function in access??	October 24th, 2005 01:27 PM by [email protected]	2	147
Alternatives to Nested If statements? by Twee[_2_] Hi all, I am new to Access and am having problems because I am writing a nested iif statement that has 15 conditions, which I believe, not only exceeds the... ( 1 2)	September 15th, 2008 11:21 PM by John W. Vinson	10	163
Always Displaying 10 Lines In The Detail Section Of A Report by [email protected] I have a report that looks like an invoice. The detail section is populated by the employee names that performed work related to that invoice. The detail...	February 14th, 2008 01:08 AM by Duane Hookom	6	75
Always include certain records in query results by Alex I have a query populating a combo box. The query contains joins to other queries. Regardless of the results, I need two particular records to show in the...	October 6th, 2008 11:04 PM by Alex	7	90
Always Round Down by Fee08 Hi All, I have a formula in a query that calculates commission. The formula works great however, when there are 3 numbers after the decimal place, in need...	June 24th, 2008 12:41 AM by Fee08	2	156
Always round up in a query? by Mike Green Hi all I have come across this little requirement for a database that I am writting and I hope that someone could give me the answer? I have a qury providing...	March 18th, 2007 03:59 PM by Ofer Cohen	4	228
am getting to many data while running the access database query by discussion I have linked two table from excel database. What i want is the data from both table in one table but i am not getting data i want. Once i run the query it...	June 1st, 2005 07:41 PM by Marshall Barton	1	57
Am I forcing the 0's correctly? by Dos Equis Hi all, Using this code: SELECT tbl_Carrier.CID, & " " & AS Name,Cint(NZ(Count(tbl_Complaint.Complaint),0)) AS FROM (tbl_Carrier INNER JOIN (tbl_Area...	February 12th, 2007 04:36 PM by Dos Equis	5	141
Am I making this more complicated than it has to be? by LauriS Here's my data: Workstation ID Product Name Version 87878787 Word 2000 87878787 Excel 2000 99999999 ...	August 1st, 2007 04:46 PM by Darhl Thomason	4	72
Am I missing a refence for the Tools=>Confirm for action query? by The parawon I'm trying to run my queries so I can have others use macros in order to run the queries without being asked if they are sure about running the query. This...	March 17th, 2005 02:31 AM by The parawon	2	68
Am I on the right track with taking data from one db and putting it into another by Dave Here is my synatx with the error: Error Type: Microsoft JET Database Engine (0x80004005) Could not find file...	August 31st, 2005 09:19 PM by MGFoster	1	115
Am I using too many filters? by Brian For some reports, I prefer to write a single report and give the user up to ten or more filters (controls, usually combo boxes) on the form that calls the...	February 15th, 2005 05:34 PM by Sylvain Lafontaine	6	109
amalagamate sites by eddiec hi everyone, We are a family owned manufacturing company that has been bought by a corporation. This corporation has gone from 1 site to 3 sites for...	April 12th, 2005 04:56 AM by eddiec	2	175
ambiguous error by Jimbo I have a query with multiple tables with a one to one relationship except one table, it is a one to many. When I run the query I get the ambiguous error. If...	May 15th, 2005 04:15 PM by cpnet	2	83
Ambiguous Name Detected error by zufie I am trying to get my command button to open a Form rather than a report. I tried messing with the VBA behind the command button which gave me the...	July 10th, 2009 07:03 PM by John W. Vinson	1	114
Ambiguous name found in query by shank I get an error: Ambiguous name found in query. This used to run fine until I upgraded to Offce 2007. Am I correct in thinking ambiguous means the query can...	April 14th, 2009 03:19 AM by John W. Vinson	1	93
Ambiguous outer join by Laurel I have two tables, tblAcademics and tblScores. Each has an ID column and a date column (Student_ID in both tables, and Assessment_Date and Score_Date for... ( 1 2)	October 4th, 2007 08:31 PM by Laurel	10	144

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