Running & Setting Up Queries - Page 996

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
Error on Alter Table to insert identity (counter) by Greg I am receiving the following message when I try to run a simple alter table: "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry" The...	February 24th, 2007 02:01 AM by Greg	0	121
Linked Tables in a query... by Devlin I am working with a simple select query. I have two tables of related data. The first table is a list of transactions and the second is account...	February 24th, 2007 01:58 AM by John W. Vinson	1	167
How do I update varying data into an existing column of a table? by Kimba I know how to run the various queries but I am stumped here. How do I only update or append data to a column in an existing table where the update/append...	February 24th, 2007 01:55 AM by John W. Vinson	8	136
In query records returned multiple times by Serendipity Using Access 2003. Trying to make a grading report that groups on fldyear, fldquarter, fldSubject, fldLN/FN (trimmed field) and fldGradeWeight then I want to...	February 24th, 2007 01:52 AM by Serendipity	6	159
Running Total Help by OShea A mate of mine recently posted a question that was given us a bit of difficulty. We had a calculated field named FTE that maybe causing the issue, as it...	February 24th, 2007 01:08 AM by OShea	1	140
Import xls data by JK I have a excell workbook that contains 4 sheets each sheet representing a country and each have the same columns of data. Entry Date - Client- Acct Name-...	February 24th, 2007 12:17 AM by John W. Vinson	4	173
Date as "month" by crtopher I have a qry based on a table that has a date field; i want to have a column in the query called 'Month' that displays the month of the date, as the actual...	February 23rd, 2007 10:40 PM by crtopher	4	173
Figured out one-to-many by Serendipity I figured out part of my not being able to get a one-to-many relationship. To make sure that the properties of my foreign PK were the same as the PK, I...	February 23rd, 2007 10:31 PM by Serendipity	0	137
Access Syntax Error by hiteshiyer I'm trying to get three buckets of users based on their variation in number of transactions between two years. I get an error message stating "Syntax Error... ( 1 2)	February 23rd, 2007 10:13 PM by Duane Hookom	11	250
VB6/MSAccess Query Problem by Ryan Prather I created a program in VB6 and a DB in Access. The database has a Artists, Albums, and Tracks table. I also have the same the in app. I am trying to get...	February 23rd, 2007 09:59 PM by Ryan Prather	0	109
Adding records by EHOWE I have a query with Person Creating Error and a total errors column. My output looks like this: Person Creating Error Total Errors John Smith ...	February 23rd, 2007 09:52 PM by John W. Vinson	7	227
Results based on 2 expressions by JK I have the expressions below which work but now i need a second expression based exp1 which would subtract amount entered into Transactions.WithdrawalAmount...	February 23rd, 2007 09:18 PM by Duane Hookom	3	125
multiple conditions criteria iif? by Starry Hi I cannot figure out how to test multiple conditions in a single grid field as follows Grp: IIf(IsNull(),0,1) else IIf(IsNull(),0,2) etc. etc. two is...	February 23rd, 2007 09:10 PM by Starry	5	201
Filter by absence of subform record by BruceM I have a table (tblPlan) for general information about a Processing Plan for machine parts. It has a related Plan Details table (tblPlanSteps) for the...	February 23rd, 2007 08:47 PM by John Spencer	2	128
Query with sql, function and input parameter by stephanie Over my head! I need to modify a query by adding a column that needs to be calculated in a function. But I can't quite get it right. Here's the pertinent...	February 23rd, 2007 08:47 PM by stephanie	0	97
Query Wizard works on one computer, but not another with same database by Jeff I have a database that was converted from Access 2000 to 2003. The Query Wizard works fine on a computer that had Office 2K installed, then upgraded to... ( 1 2)	February 23rd, 2007 08:42 PM by John Nurick	10	212
Running Total in My Query by Dingo Can someone give a hand with adding a running total to my query, as I had a bit of difficulty with it? As you can see 'FTE' is a caclulated field. What I...	February 23rd, 2007 08:31 PM by John Spencer	5	295
Running Total in a query by Nathan I have read similiar threads on this subject but I just cannot get the syntax to work out correctly - I have a lists of items (SKU) and how often they are...	February 23rd, 2007 08:19 PM by Michel Walsh	1	136
Append duplicate invoice numbers by T I have a table that has invoices brought in from another program. The table contains duplicate invoices. I created the find duplicates query which is...	February 23rd, 2007 08:06 PM by Michel Walsh	1	119
Trying to get a text count by Frustrated in AL I am trying to count the number of instances that a particular phrase appears in a field. I have been able to have the phrase identified, but I cannot get...	February 23rd, 2007 08:01 PM by Duane Hookom	1	137

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