Running & Setting Up Queries - Page 951

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
Parameter in WHERE defaulting to All by Dorian I need to do something like WHERE Unit = However, what I want is if no unit is entered, I want to return all Units. I'd like to do this in a way that only...	August 20th, 2009 03:41 AM by MGFoster	3	115
Help! Need to update linked SQL table in Acc07 by George Atkins I have several linked MS SQL SVR tables. I need to update multiple records in one of the tables, but I'm having a problem. First, the basics: Main table is...	August 25th, 2009 06:08 PM by George Atkins	3	133
Allocation Query by Nicole I am new to Access and and am hoping someone can help. I have a table that consists of 4 columns: LA Code (which is text), LA Revenue (number), LP Code...	August 26th, 2009 07:00 PM by vanderghast	3	122
Pls help. urgently required by subs ozip dzip consignee shipdate 0101 3456 basf 2/1/2009 0104 3456 basf 2/1/2009 0890 2345 basf ...	August 26th, 2009 03:05 AM by John W. Vinson	3	122
Insert data from SQL table into Access table by OldEnough New to SQL Server (running SQL Server Express 2005) would like to pull data from server table to local table. Databases are not linked. latest attempt below...	August 27th, 2009 12:02 AM by Bob Barrows	3	119
Update Query by Sarah I am new to access and am not really familiar with different types of queries..and am trying not to have to do work in excel before I bring my data over. I...	August 26th, 2009 06:17 PM by Sarah	3	109
Calculate Fields by CourtneyH I have a spreadsheet with test scores and need to calculate the total number of passing scores per subject area. Is this possible? A passing score is...	August 26th, 2009 06:18 PM by Jeff Boyce	3	93
If then AND statements in access by Sarah I am trying to convert this excel IF statement into access. =IF(A2-10,"OK",IF(AND(@240-5,B2="Y"),"OK","Not OK")) How would I write this in access?	August 26th, 2009 10:17 PM by Clifford Bass[_2_]	3	112
Strip $ and , from a Text field by h2fcell Hello, Using Access 2007, Iâ€™m trying to create a query that converts a field coming from an Excel file link into a number. The Excel field contains Text in...	August 30th, 2009 03:35 AM by Michael Conroy	3	182
iif, or, else? by jcarson I am new to Access (trying to teach myself) and I'm having a syntax problem with the below...	August 25th, 2009 03:56 AM by George Atkins	3	157
Append and Delete in one step by OverMyHead The database I have tracks work orders that have been complete. Once we verify with the customer the issue is resolved, using a form we change the value of...	August 22nd, 2009 03:45 PM by OverMyHead	3	132
Import by Richard via AccessMonster.com Hi all, How can I append or import one spreadsheet into two related tables? I have an empty database that has two tablesâ€™ 1:M. Part of the spreadsheet goes...	August 18th, 2009 08:32 PM by John W. Vinson	3	101
Query specific data by hoachen Using Access 2003,XP OS I am trying to run a query from a table (See the data below). I want to run a query that check the phone#, if the phone number is the...	August 19th, 2009 01:21 PM by John Spencer	3	183
Percentage and subtraction by Love Buzz Hello all. Here is what I am trying to do. I want to compare the count of RR Code 1 to RR Code 2 in my query. That is working fine except it's only...	August 20th, 2009 03:28 AM by Allen Browne	3	119
Using IN() with IIF in criteria by Dave Robinson[_4_] I have a form with a checkbox for "A and B". The letters A and B are possible values (the other possibilities are C and E) in a field of a table upon which...	August 19th, 2009 05:27 PM by John W. Vinson	3	118
Query Field Format by Grimwadec I have a field in a query "PriceDefault" which displays e.g. "$50.00". However when I use Nz in another field "Nz(,0)" the currency format does not display,...	August 20th, 2009 03:51 AM by MGFoster	3	140
How to extract query code from MSysQueries ? by AJMegaughin Does anyone have code which would allow me to reconstruct the SQL code used in a query from the data stored in the MSysQueries table of an MS...	August 21st, 2009 11:10 AM by AJMegaughin via AccessMonster.com	3	130
Display query results only if field is not null by TinaR I have a simple query based on two tables that are linked together. I'm pulling the results based on a date. The first table is a current roster. The...	August 20th, 2009 09:51 PM by KARL DEWEY	3	126
Which String functions to use? by h2fcell Hello, Thought Iâ€™d post this question before I tinker with it myself. I have a field â€œdetails_xmlâ€ that contains xml information like the below...	August 21st, 2009 06:20 PM by h2fcell	3	103
calculating budget queries by Co Hi All, I have a financial database holding our companies budget. Now I want to have some queries telling me how far we are with our spendings. We have a...	August 31st, 2009 03:07 AM by kc-mass	3	162

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