Running & Setting Up Queries - Page 203

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
function to return a portion of a cell by carrie I have a field that I need to trim off the beginning of the text. The piece to be trimmed is not always the same length but is always followed by a dash. ...	July 8th, 2009 08:48 PM by Clifford Bass[_2_]	4	124
querry sql problem for previous month by reportyemi I have a 2 querries totaldeliverytype and totalcondition. and wanted to find out the previous months result of deliveries and condition of baby. I am able...	July 8th, 2009 08:22 PM by reportyemi	4	129
Is field between date range on form by consjoe I have a form with a start date and an end date field. I want a user to either put dates in these fields or leave blank for all. I can't get the query to...	July 8th, 2009 07:18 PM by consjoe	2	103
Sort by text field in crosstab query by JMalecha Here is a copy of a piece of my table. I need to be able to sort the Monitor Wells in order (i.e., MW-1B, MW-2, MW-3, MW-12A) Ascending order produces the...	July 8th, 2009 07:13 PM by KARL DEWEY	4	122
Report Gets #Name? on database launch by FlBrent via AccessMonster.com I have a weird situation that I can't figure out. I have built a report that has many text box controls that do calculations based on the detail fields coming...	July 8th, 2009 06:05 PM by Clifford Bass[_2_]	3	129
Update Query Question by Carl I have a table with three fields: CustNo SubDate DelayDays There are currently 895 records, and growing CustNo is a text field, SubDate is a date field...	July 8th, 2009 06:01 PM by Carl	2	83
Iif Statment by Thorson I have written several iif statements, but I am not sure how to write one to fit this problem. I have two fields in my query: EntryDateMonth and Month. I...	July 8th, 2009 05:28 PM by Thorson	7	138
Is there a way to ignore Null values in a crosstab query? by JMalecha I've tried Like "*" but get the error message You can't specify criteria on the same field for which you entered Value in the Crosstab row.	July 8th, 2009 05:05 PM by John Spencer MVP	2	103
sorting a MONTH field in a cross-tab Query correctly by Matt D Francis Hello, I have a field ACTION_DT_TIME which stores a datetime value as follows 200605151507 =YYYYMMDDHHSS I need to be able to pull out just the Month from...	July 8th, 2009 04:57 PM by JMalecha	8	106
Joining different parts of the same table by vanderghast "vanderghast" vanderghast@com wrote in message news:... In SQL view, add (or modify the existing) an ORDER BY clause: ORDER BY...	July 8th, 2009 12:36 PM by vanderghast	0	73
Dates - Grouping Start and End dates of sequential assignments. by MSC Hi, I'm trying to group assignments for people by the dates that assignment started and ended - but only sequential assignments to be grouped. eg: Table:...	July 8th, 2009 10:53 AM by MSC	0	107
Data Fur Report by Steve[_72_] The following data needs to be placed in a preprinted report: AssemblyID Assembly ComponentID Component 1 A ... ( 1 2)	July 8th, 2009 08:01 AM by StopThisAdvertising	10	133
Print sub form only by Leo How do you write the code so that only the subform will be printed when you do not want to go through report format? The sub form displays the seleted...	July 8th, 2009 05:55 AM by Leo	0	140
Is it possible for a query to blow up the database? by KevinS I ran this query (not an update or append) multiple times with no problem. This one time I got an error and suddenly nobody could get in. It was a syntax... ( 1 2)	July 8th, 2009 05:00 AM by Tom van Stiphout[_2_]	14	208
Fixed Numbers by Melissa I have a table that is imported from Excel with percentages and numbers. This table changes weekly and is used in conjunction with existing tables to create...	July 8th, 2009 03:14 AM by Piet Linden[_2_]	4	109
Queries by gr8_access Hi, I am having issues with access sql. I have data for example: 123456789. I would like to break this into two lines and I don't know how to do...	July 8th, 2009 02:27 AM by gr8_access	0	93
Date Subtraction in MSAccess by Laura1 via AccessMonster.com I have two date fields. The underlying data has them stored as the following: Sales Event date: 1/6/2009 Created date:1/6/2009 5:09:23 PM I have converted...	July 8th, 2009 12:10 AM by Jeff Boyce	6	167
Querying across Multiple Databases by Brad Autry I'll try to keep this as brief as possible. I am working with "one" massive database that, due to size, has been broken down into 37 separate databases. I...	July 7th, 2009 10:37 PM by Jeff Boyce	5	103
I need to include a field in a crosstab query just to sort by Michelle Ives I have the following four CBTs (Customer Business Teams) "AT&T; MNO; MSO; NAM SbR", with costs that are tracked on a weekly basis for budgeting purposes. I...	July 7th, 2009 10:34 PM by Michelle Ives	4	112
Updatw table with a given criteria by rasheedvtk dear all , i have one single tablewhere i used to keep all my purchases, i want all the the invoices on a specific date to be marked as paid , i want to it...	July 7th, 2009 10:03 PM by John W. Vinson	1	101

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