Running & Setting Up Queries - Page 95

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.

		Home » OfficeFrustration forum » Microsoft Access
Running & Setting Up Queries

Home

Page 95 of 2165

Threads in Forum : Running & Setting Up Queries

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Breaking ties in a Top n Query by S Davis Hi folks, I received some excellent help on friday with a Top 12 query I am working with. It works great except that I am having trouble creating criteria to...	November 24th, 2006 06:31 PM by David F Cox	9	113
Query Problem by [email protected] Hello I have something wrong with my query and i can't seem to find it I want to select put a position number on each of the rows based on "Completed" date I...	January 5th, 2007 12:12 AM by giorgio rancati	9	142
Query with a sub-table by SHIPP I have a master table with an employee. I have a sub-table with the departments he is working for. I have a multi-select list box that has all of the...	January 17th, 2007 11:40 PM by Smartin	9	112
Show just one record each person-different results by Dennis I have two tables: Requests, Suspects with inner join (by request#) I want to run a query by case number (a field on the requests table) and show all the...	January 12th, 2007 04:07 PM by John Spencer	9	113
Use result of expression in another expression?? by Serendipity Can I go to the first empty column in a design query grid and use an expression to add a new field row and then use the result of that expression in another...	January 15th, 2007 04:36 AM by Smartin	9	116
Deleting commas in a field query by GLS Hi I have automated the exporting of Access 97 tables to CSV files. The prob is there is an address field, where some of the data is input as eg: Flat 3,...	January 17th, 2007 08:07 PM by John Nurick	9	168
Update Query using date in text format? by [email protected] Morning everyone, Before I even attempt to due this, I would like to run by all of you... I have a text box in one of my tables that is formatted for...	January 23rd, 2007 05:51 PM by John Vinson	9	94
Append qry only works the second time by Lori2836 via AccessMonster.com Good morning. I have a form where information is entered, and upon close of the form, a command button that runs a macro to append the data to another table. ...	January 23rd, 2007 08:12 PM by Darrell Childress	9	804
How to extract numeric portion of alphanumeric data by Yamou I have a number of text strings like these: Trans to Nya subproject (Kshs 561,596.30) Trans to Bon subproject (Kshs 447,406.50) Is there a way in Access 2002...	January 26th, 2007 03:46 PM by Yamou	9	276
extract right 3 digits into existing field. by JohnLute I've been reading a lot of the current "split" posts however I can't find one that is similar to my problem. My tblProfiles has 2...	January 4th, 2007 01:05 AM by fredg	9	241
SQL Syntax for SELECT within SELECT by Greg Hi, I hope someone can help me here I have 3 very similar queries. QryLeg1: SELECT lngFlightPlanID, lngAirportID FROM AAFP_tbl_FlightPlanLeg WHERE...	January 2nd, 2007 12:40 PM by Van T. Dinh	9	105
Finding alphabetic only in a text field by Doug F. I have a text field. How can I find records with only alphabetic characters in it? Thanks	November 26th, 2006 03:13 AM by John Vinson	9	139
dropping a relationship (i.e. constraint?) by David Mueller I'm trying to drop a relationship using SQL DDL but I get a "CHECK constraint .... does not exist" message. ALTER TABLE mytable DROP CONSTRAINT I can't...	December 4th, 2006 12:07 AM by Allen Browne	9	150
What's the right criteria to use? by TechyTemp I have a query set up to pull only the records with brake cooling units. Those part numbers will have "KBCE", "BC" OR "BCE" as part of the part number. I'm...	December 7th, 2006 10:41 PM by Jeff Boyce	9	97
IIF =Date Results in Null by BLanc I put this statement into a date field in my query: IIf(Weekday(Date(),1) 6, Date(), Date()+2) So that the field will return only today's dates,...	December 7th, 2006 01:14 AM by KARL DEWEY	9	67
Update with values from another table by dtoney All of the postings I have read seem to be including an inner join. The 2 tables I'm using aren't related, so I don't think a join is applicable. I have a...	December 11th, 2006 04:44 PM by Jeff Boyce	9	97
date function issue by [email protected] I am trying to extract data from a database through an access query. One of the fields in my query has a time-stamp date (i.e. the date entered in the database...	December 11th, 2006 10:17 AM by Van T. Dinh	9	92
Select Last payment date and amount of a group by Kathy Webster I am perplexed. Seems like it should be so easy, but...Can you help? My table has: Client PaymentDate Amount...	December 16th, 2006 03:12 PM by John Spencer	9	158
IFF One Date = Another Date by Nanette I've been trying to get the below query to work. It only pulls a couple of dates. Any suggestions on how to fix it? IIf(( = ), IIf(( = ), IIf(( = ), IIf((...	December 28th, 2006 04:04 AM by Duane Hookom	9	107
Sum of Time by FBxiii Hi. I have a table that logs a user ID and the time they were logged into my database, in hh:mm:ss format. I am trying to run a query to show me the total...	January 31st, 2007 03:24 PM by Marshall Barton	9	73

Page 95 of 2165

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 11:52 PM.