Running & Setting Up Queries - Page 406

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
Relationships in a query by RipperT[_2_] I have tblHearings (one side) and tblCharges (many side) joined on 'HearingID'. tblHearings also has a 'HearingDate' field and a 'Select' checkbox field. I...	October 22nd, 2008 06:02 AM by Marshall Barton	3	90
Export Pivot Table to Excel by Jasper Recto I have a form with a another pivot table form embedded in it. I want to create a button that will export the pivot table into excel. I created a macro to...	October 22nd, 2008 04:13 AM by Duane Hookom	1	63
TOP N Records with 2 tables by TheIMan Hi, I've been having trouble getting this query to return the values I need. I have two related tables that contain raw material purchase information....	October 22nd, 2008 03:36 AM by Allen Browne	1	65
Data Normalization by R Tanner On Oct 20, 4:38*pm, John W. Vinson wrote: On Thu, 16 Oct 2008 17:35:11 -0700 (PDT), R Tanner ...	October 22nd, 2008 12:54 AM by John W. Vinson	1	89
strSQL by auujxa2 via AccessMonster.com I have a form with a bunch of combos and lists. In this case, I'm trying to accomplish simulating a store/department. So, as an example: If I have store #1...	October 21st, 2008 11:28 PM by Lord Kelvan	3	64
Display numbers to the left of a decimal sign by AccessIM I am trying to break down a calculated field () to display only the numbers to the left of the decimal. I am using the line below based off similar entries...	October 21st, 2008 11:24 PM by AccessIM	2	72
Parameter query not returning all results by thedrumdoctor I have a stock table that I need to run a query on to see if a product actually exists. The table contains the following fields: StockNumber...	October 21st, 2008 11:09 PM by thedrumdoctor	4	60
If Statement In My Query by SunflowerdBGirl I have a query that I've designed to open a form and just display one project's information. The user has a form in which they select the project from a list...	October 21st, 2008 10:03 PM by SunflowerdBGirl	2	51
How to check for duplicates? by Amin So you have a table that has multiple fields. Records in one of the fields duplicate. As in, in Field "A", there are the numbers 24, 56, 74, 24, 24. What I...	October 21st, 2008 08:51 PM by KARL DEWEY	7	56
Data Normalization by R Tanner I understand what the purpose and value of data normalization is, but I just have one thing I am confused about. If you split up a table, then it will create...	October 21st, 2008 08:17 PM by R Tanner	9	78
Problem with "OR" by bladelock I have a problem with thi query. I'm trying to display all the data except for PRO and NICK. When I run this query it still displays them. How do I exclude...	October 21st, 2008 07:39 PM by Duane Hookom	2	71
Update query by Noel I need to take two fields and subtract the two and then the total I want updated into a field. QuarterlyCost - QuarterlySubsidary=TotalCostwithSubsidary. I...	October 21st, 2008 07:31 PM by John W. Vinson	8	66
Access is compiling query results rather than creating a new set by [email protected] I have created a query which displays the results in a list box. Within this query there are a couple of fields which criteria is linked to combo boxes. When... ( 1 2)	October 21st, 2008 07:27 PM by Jeff Boyce	10	131
Appending Data to a Table with 3 lookup Columns (Foreign Keys) by R Tanner Hi, I have a table with around 350,000 rows. I have 3 lookup columns to parent tables. I imported another 30,000 records of data to a new table. It is the... ( 1 2 3)	October 21st, 2008 07:27 PM by R Tanner	21	168
Creating A Lookup Column That contains the Foreign ID to a ParentTable by [email protected] Hi, I just created a relationship between a parent table, called 'Trade Specialists', and a child table, called 'Tickets'. This is a one to many...	October 21st, 2008 07:20 PM by R Tanner	3	77
DateDiff by les Here is my formula: CAST(EVAL_DT - CAST('07/01/' + LEFT (POLEFFDT, 4) AS datetime) AS float) / (365 / 12) It is giving me the developments months in a...	October 21st, 2008 07:13 PM by Bob Barrows	5	69
Cannot edit data in a Query by Bruce I am running Access 2007. I have written a query to a linked table (AssetMaster) that resides in a SQL Database (SQL Server 2005). I can enter or change data...	October 21st, 2008 05:41 PM by Bruce	6	62
Pulling Active Suppliers by year by Marc I have a database that holds suppliers data. In my my table I have radio buttons "active", "inactive". If the supplier was active since 2005 and I wanted...	October 21st, 2008 05:40 PM by KARL DEWEY	4	67
Cut off part of a text/date field by TJT I have a date field populated with "8/18/2008 1:10:32 PM" my goal is to update the table field so that just the "8/18/2008" is retained. ( 1 2)	October 21st, 2008 05:37 PM by John W. Vinson	14	164
Lost data? by Fluke[_2_] Hi. I've got a main database, and I've created a separate deferment database that's linked (in a different front end) to the main by Item, as the deferments...	October 21st, 2008 05:35 PM by John W. Vinson	4	59

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