Running & Setting Up Queries - Page 201

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
Replace wildcards with a space by Barbara I have a text field with all values containing an asterisk. The asterisk can be located anywhere within the contents. I am trying to replace the asterisk...	May 6th, 2010 06:00 PM by Marshall Barton	1	227
My query doesn't pick up records added to the table after a parti. by Fran the Confused My query does not pick up any records added to the table after 10/9/07 but there is no reason for this in the query itself. Also it does not pick up records...	December 17th, 2009 12:10 AM by KARL DEWEY	2	227
Date range for a report by Tracey Hi I am trying to run a query and can't seem to nail down the right code. We use the access database to track files, incoming/outgoing correspondence dates...	December 31st, 2009 03:31 PM by Tracey	3	227
how to select any last record in the querry by Naveed Pathan hi friends i would like to know that how it is possible to select the last ten records related to a particular suppliers. supose a supplier supply me the...	January 26th, 2010 02:42 AM by Duane Hookom[_4_]	5	227
Calculate Diff Date? by kritter0021 Ok, If I want to calculate the difference of a date with the following date in Access: so 3/29/08 in cell A1 and 5/3/08 in cell A2 and return the value in B1...	February 10th, 2010 03:16 PM by kritter0021	4	227
Crosstab query to include fields with Null value by Peggy Ball Hello ~ I have created a report based on a crosstab query for student attendance. Row = Name Columns = DR, Ed, FE, ILL, RH, TEX, TRP, TUN, UNV, UNX (absent...	March 11th, 2010 01:30 PM by John Spencer	2	227
In Access 2010, how do I create a SQL query? by ew68 In older versions of Access, there was a View - SQL View menu button. How do I get the SQL View with Access 2010? I need to create a query which contains...	March 14th, 2010 11:20 AM by ew68	0	227
You can not add or change a record because a related record... by Dennis Hi, I have a table to which I am trying to manually add a record. When I add a record directly to the table using query, I receive the error message "You...	April 10th, 2010 03:17 PM by Bob Barrows	8	227
Update Query by Glenn Dulmage I have 2 tables: Member and Bulk Mail I have linked them on Last Name Member has these fields: First Name, Last Name, E-mail Bulk mail has these fields: First...	April 30th, 2010 06:19 PM by Jeff Boyce	6	227
Why is my Access Queries take a long time to generate? by Weak Access User I used to do the query in less than 30 secs, but using the same method to do another query, it took more than a minutes to generate the table. Why is it so?	December 10th, 2009 03:04 PM by Jerry Whittle	1	227
syntax error in JOIN operation by javablood Hi, I am not even sure if this can be done. I am trying to reference a table in a query. The table is defined in a form. Here is the query I am working...	December 14th, 2009 02:28 PM by javablood	4	227
Returning more data than requested by Sun Communications I have a query for a field in my SQL database and use this statement =. It prompts for the code that I would like the report for example "NT", but when it... ( 1 2)	September 16th, 2009 07:39 PM by Banana[_2_]	15	227
How do I create a column alias in Access? by Laura ( 1 2)	August 14th, 2009 10:32 PM by John W. Vinson	12	227
show all results even when null for each name by B How can i display all names in the table even when there are no records that meet the parameter? When there are no records i want to show 0 not null...	July 3rd, 2009 06:30 PM by Alvar Rodriguez	6	227
Syntax assistanc requested for [last,first] conversion by I have a field containing which I want to switch into and . I need syntax assistance for an update query which I can paste. Data is Existing ...	June 26th, 2004 12:51 AM by fredg	1	226
Organization Chart by Dmiller444 Please help construct a query: I have a table that defines an organization chart, main fields a UserID: Text (Primary) FName: Text LName: Text Supervisor:...	July 10th, 2004 08:22 PM by Dmiller444	4	226
Results Based upon a Date by Teri I am constructing a database that reflects shipment dates. The manager wants to print a report showing SHIPMENTS BEFORE SHIPPING DATE Customer: -1 Day Before...	July 27th, 2004 05:38 AM by Duane Hookom	1	226
Invalid Trailing Spaces Match by Michael Keck - U of I I have a query with a subselect to determine if a table has referential integrity issues with some validation tables (There are no Foreign Keys in the Access...	August 1st, 2004 04:45 PM by Gary Walter	5	226
Parameter Query Not Returning Null Values by Melissa I have a parameter query which prompts the user to "Enter Class" - which is a 4 digit field reflecting the graduation year of high school students. The code I...	October 2nd, 2004 09:56 PM by John Spencer (MVP)	2	226
Problems w/ Date() function... by M. Center Had several queries using the Date(), typically in a range selection (ie. Date()+7:00AM AND Date()+3:15PM). Suddenly all queries using the Date() generate a...	June 7th, 2004 04:01 AM by M. Center	2	226

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