Running & Setting Up Queries - Page 1091

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
can this be done with a subquery? by Bronson Hi. I would like to know whether the following can be done using a subquery (I 'm currently using 2 queries to get the desired result) Consider the following...	December 1st, 2006 12:30 PM by Gary Walter	5	73
Include additional fields in or from a totals qry by Dee Ok here's the issue. In order to find MFG #s with different prices (since we should always be charged the same price for said product), I had to make two... ( 1 2)	December 1st, 2006 12:27 PM by John Spencer	13	138
Union query by mike I have a table that contains records with both a time field and a date field. i have a form that displays the records, however i only dwant a certain number...	December 1st, 2006 12:24 PM by John Spencer	4	80
Query Criteria Moves by Swimgirl Below are 3 Criteria's in my query: The Total for RE CO and RE RCVERS is "Sum"; MARKET and DIV is "Group"; and AREA is "Where." The query works just fine, I...	December 1st, 2006 04:49 AM by Allen Browne	1	75
Requery in a Form by nikila40 Hi! I have a drop-down combo box in a form that lists "supervisors" names. In order for people to add names that are not in the list, I created a macro...	December 1st, 2006 04:41 AM by Allen Browne	1	89
Query problem by RobertM Here's the query: SELECT TblDL.SecNm, TblDL.CUS, TblDL.Ex, TblDL.Pay, TblDL.Grate, TblXZ.CUS, TblXZ.Ex, TblXZ.Pay, TblXZ.Grate, TblDL.Ctry FROM TblDL,...	December 1st, 2006 04:24 AM by Allen Browne	1	90
Case Statements in Access by hiteshiyer SELECT IIF( tblSiteIDs.SiteCountryCode = BEFR, BE, IIF(tblSiteIDs.SiteCountryCode = BENL, BE) ELSE(tblSiteIDs.SiteCountryCode)) As Country, From...	December 1st, 2006 01:47 AM by hiteshiyer	2	73
insert incremental row number in a calculated query field by Jason Can I add a calculated field to an adp query which will automatically provide an incrementing value for each row (starting at 1) ? -- Jason	December 1st, 2006 01:31 AM by Peter Yang [MSFT]	3	80
DISTINCT Query Help by [email protected] Hi guys, I have two tables; contact_details, and gallery - which links an advertiser to gallery photo's submitted by them. There are many contacts, and many...	December 1st, 2006 01:28 AM by [email protected]	2	171
Calculating functions in form objects by FredVN Hi, I'm an M/S Access newbie who has figured out how to do simple calculations in a form objects using the control sources for a text boxes, but am having...	December 1st, 2006 01:14 AM by AccessVandal via AccessMonster.com	3	97
Using MAX from another table in a INSERT action. by Fernando Morais Hi, i was trying to do a query that is inserting values on a DB, and one of the field should be the result from a query using MAX on antoher DB. Something...	December 1st, 2006 12:34 AM by Fernando Morais	4	68
Using form to get parameter inputs for query by jlorick I created a form with unbound text boxes and one combo box to gather multiple parameter inputs from users. I also added an OK and Cancel buttons. When the...	November 30th, 2006 11:09 PM by Duane Hookom	1	72
exponent 2^64 by Stefan889-12 in math 2^64 = 18446744073709551616 I need to figure out the exact result for 2^64 in Access,Excel or any other program. my query shows me 18 446 744...	November 30th, 2006 11:02 PM by Phil Smith	1	77
AND IF formula in Access Query by [email protected] I'm trying to do this formula in access query as a expression to create a new field and having hard time, can anyone help me...	November 30th, 2006 10:55 PM by Jeff Boyce	7	94
total a query by jomara via AccessMonster.com I have a query that lists a salespersons sales i need to have the total sales show on their main form . I have created a text box on the form but cant seem to...	November 30th, 2006 10:41 PM by Marshall Barton	1	73
Converting Time Format using expression Microsoft Access by mp80237 Hello, I am connected with view only access to a SQL database. I am running my queries needed through access. The dates/times in the SQL database are...	November 30th, 2006 09:30 PM by Basil	2	96
Complicated Query problem by Addy My MS SQL skills are under great test at the moment. I was wondering if I could get some help on this problem. So I have a Query which is pulling fields from...	November 30th, 2006 09:09 PM by Addy	6	91
Losing $ format when multiplying two fields by ChuckW Hi, I am trying to multiply two fields. The first field is called HourlyRate and the second is called Hours. They multiply to make HourlyPay. I then add...	November 30th, 2006 08:58 PM by KARL DEWEY	1	75
Updating primary key in multi-table db by KARL DEWEY Backup the database. Run reports for comparrison later. Bring in the cross reference SS#, name and ID#. Add the StudentID to the tables that now have the...	November 30th, 2006 08:29 PM by KARL DEWEY	0	74
Query issue by Jamie I am trying to do a query with several criterias. I have 10 total columns and I have created or in all columns. If the value is outside of the or ...	November 30th, 2006 08:28 PM by John Spencer	1	60

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