Running & Setting Up Queries - Page 2151

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
Update Queries using queries by Vel Hello, I have an update query, but would like to limit the values to be updated to include only those values which appear in another query. Now, I can do...	June 4th, 2004 09:21 PM by Vel	7	561
Checkboxes by LRosario I have a log where I want to track whether a task has been done by just clicking on the 'checkbox' and the check appears. It serves no function except to tell...	June 4th, 2004 09:05 PM by tina	1	122
'Find Duplicates' Query to Delete by Naimah After running the "find duplicates" query, it returns all the duplicates in my table. How can I then delete one of each duplicate without manually deleting? ...	June 4th, 2004 08:36 PM by Dorian	1	432
Show pages on 2 monitors by puczynski Is it possible to create an Access form...on which data is entered in one language, e.g. Russian and an English version is displayed on another monitor as the...	June 4th, 2004 08:34 PM by Wayne Morgan	3	155
Query Multiple Tables by Lisa Reber In the course of trying to normalize my database, I have split my data into multiple tables: Contacts (name, address, etc.) Statuses (active member, newsletter...	June 4th, 2004 08:32 PM by Lisa Reber	4	663
add autoNumber to query after sorting by munscher I have a query that pulls info from a table and sorts it based on a particular field. Is there a way to assign a number to each record in the query (starting...	June 4th, 2004 08:14 PM by Ted Allen	3	281
The open report action was cancelled by George i have just installed office 2003 on a new xp machine and when i try and open some documents in access i recieve the error, "The Open Report Action was...	June 4th, 2004 08:12 PM by [MVP] S.Clark	1	471
Show Records Where All Related Records Are False by Cliff In a one-to-many table relationship, I need to show only records from the primary table where a boolean field is False in ALL related records. It seems simple...	June 4th, 2004 08:10 PM by Cliff	1	515
return all data from last 5 years from today's date by Attila Fust I want to run a query so it will give me all data from the last 5 years from today's date without having to specify the actual dates. Is there a way to do...	June 4th, 2004 07:58 PM by Les	4	329
circular reference error message... by Jacqueline In my Access 2000 mdb I am trying to create a report that must choose the correct mailing address to send the letter to... The database holds 3 sets of mailing...	June 4th, 2004 06:59 PM by Ted Allen	2	287
Find Max Values and Return Null Value Too by Josiah I'm trying to create a query that will find the maximum value for a field and if that field is null it will still display the record but the max will be blank....	June 4th, 2004 06:44 PM by Gerald Stanley	1	426
Group Option Not selected but show up in Query by SMac I have a form that has 6 options to select. Then I created a query to return the values that were selected, going good. My question is the query returns the...	June 4th, 2004 05:16 PM by SMac	2	629
urgent help for build sql statement in vba by terry My assignment's due date is approaching. I'm nervous now! How can I build this sql statement in a function: SELECT LAST(fieldName) FROM (SELECT TOP p PERCENT...	June 4th, 2004 05:01 PM by John Spencer (MVP)	1	569
Help with displaying correct address in a query by Jacqueline In my Access 2000 mdb I am trying to create a report that must choose the correct mailing address to send the letter to... The database holds 3 sets of...	June 4th, 2004 04:27 PM by	2	338
Programmatically entering query criteria on Form by Gwen Please help I have written code to dynamcially enter information in text boxes when the form opens to be used as criteria for a query. However the query is...	June 4th, 2004 04:25 PM by Chris Large	1	388
Create Table Statement by nagesh Hi all i am getting Problem with default word in Create Table statement Create Table test2 (Id autoincrement, name text(255) , age int not null default...	June 4th, 2004 04:12 PM by Allen Browne	1	197
Converting zero to Null value by gal Hi group, I have a field that has numbers includig zeroes(0). How can I covert the zeroes to NUll( blank to be displayed). Thanks group	June 4th, 2004 04:05 PM by Matt	1	118
Showing only non matching items by CD Tom This is probably very simple but I can't figure it out. I want to create a query that will show only the items that don't match between two tables. Thanks...	June 4th, 2004 03:24 PM by JulieD	1	184
Filtering last 24 hours Records by Craig Fellows Hello, I have a query that collects data based upon date and time. I can drop the date element if I can always obtain the last 24 hours worth of records. Our...	June 4th, 2004 03:05 PM by Jeff Boyce	3	390
Problem with IIF Statement by Confused Hi, I currently have a query with a list of calls from a call log database. Within this query i have LocationDesc and Practice. I want to group the...	June 4th, 2004 02:56 PM by Rob	2	501

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