Running & Setting Up Queries - Page 901

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
Selecting the top 1/3 of a table by ASP.Confused I have a table with 306 records. If I select the top 33.333333333 percent, it's returning 101 rows. It should return 102 rows. Thinking that this was...	July 17th, 2006 12:49 PM by Jamie Collins	4	135
Correct Profit Margin (%) by LJG Hi Guys, This might be a really dumb question, but can anyone advise the correct way to calculate profit margin % I have / i.e £4.19/6.98 = 60% (no...	July 17th, 2006 01:12 PM by LJG	2	104
Query Code and Form by Russ I created a simple database that will be used to track company purchases. I created three tables (main, list of departments, list of vendors). I created a...	July 17th, 2006 01:12 PM by Russ	6	198
Performing expression on all (varying number of) fields by [email protected] Hi, I've created a crosstab query, sorting machines by row and parts by column, with count of each parts as the value. Not every machine has every part, so...	July 17th, 2006 01:42 PM by [email protected]	3	135
Borders disappeared by Shely Hi My webpages no longer show their borders! Last week, for no apparent reason, the web extensions "turned themselves off". This has just been fixed at the...	July 17th, 2006 03:12 PM by Rick B	1	88
What should be a simple table comparison... by [email protected] Hello everyone, I have a simple dilemma that I just can't seem to solve. I have two tables: tblfromXLS and tblwebmaster. I need to use an SQL statement that...	July 17th, 2006 04:56 PM by [email protected]	2	108
Export to Excel?? by Ket Hello, I am using Office 2003. I have an access db that contains a number of tables. I have been asked to export two of these tables to Excel. The issue...	July 17th, 2006 05:15 PM by Ket	0	97
Access 2003 Query by form by Nightfall Hi! I hope I have this in the right discussion group. Here is my problem: I have a form which is to be used to enter query criteria for up to 14 fields. I...	July 17th, 2006 06:14 PM by Nightfall	2	153
DateDiff Calculation Off By One Year??? by Ronster I'm running a query that requires that I convert a YYYYMMDD text formated field to a valid date, then use the converted date to determine the person's current...	July 17th, 2006 06:14 PM by John Vinson	5	153
Update query only works the first time by Jacine I am having a problem with an update query for an inventory control form. There are several bin locations with a numeric field for how many there are in each...	July 17th, 2006 06:28 PM by John Vinson	4	126
Using Totals w/ an Updateable Recordset by Jamie McD I have two tables with a one to many relationship, well call them A and B. I have a continuous recordset form based upon this relationship. The issue I'm...	July 17th, 2006 06:31 PM by John Vinson	3	85
help with sql query by [email protected] Greetings I have a table arranged thusly Reason Status Est Comp Date PMDate Tool# ...	July 17th, 2006 07:31 PM by [email protected]	2	101
Multiple Query Parameters by Sheenalis I have a query that pulls project numbers, task numbers, and cost types. I want the parameters to ask for two project numbers, and task number and a cost...	July 17th, 2006 07:55 PM by Sheenalis	4	163
Global Var in queries by Scott Burke I have a global var "G_NAME" I would like to use it in a query. Is it posible????????????????? Scott Burke	July 17th, 2006 09:06 PM by Scott Burke	2	103
SQL Syntax Bug by In need of assistance I'm writing a query and I'm getting a syntax error but I'm not seeing it when I look at it and the error message isn't telling me where it is at. For...	July 17th, 2006 10:27 PM by Gary Walter	2	104
Column Order in Output by [email protected] I am using an Access query with fields in a specific order to create an Excal file which will later be used as data to import elsewhere. I am finding that the...	July 17th, 2006 10:50 PM by Jerry Whittle	1	67
What's max limit for MAXLOCKSPERFILE in registry? by PDIHAL I keep getting error when trying to add a new autonumbered field to files with 50,000 records. Error messages suggests changing the MAXLOCKSPERFILE setting...	July 18th, 2006 12:27 AM by	3	113
I don't even know where to ask - same post in excel by DTTODGG Hello- I don't even know if I'm in the right place to ask the question. Please help if you can. Everyday, I open an Access database that reads from some...	July 18th, 2006 06:06 AM by John Vinson	1	81
ad post and related fields by Maria This seems like such a simple thing to do but I just can't seem to get started. I want to create a query that allows me to enter the Name and despription in...	July 18th, 2006 08:45 AM by Maria	4	98
simple Update statement by x-rays Hello all, I have a simple Update statement, Update INNER JOIN ON .Make = .Make SET .Make = .MappMake Where .Type = "G"; is the table I want to update...	July 18th, 2006 12:40 PM by Rick Brandt	3	96

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