Running & Setting Up Queries - Page 215

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
IIf (maybe) this, else leave blank by Stephanie Hi. I can't remember how to say: if 0 then else leave blank. Thanks for the help! Cheers, Stephanie	June 19th, 2009 09:56 PM by Duane Hookom	5	136
#ERROR question by Elmtree via AccessMonster.com My formula: Mid(,InStr(10,,": ")-1) returns #ERROR if the value is blank, otherwise works fine. Any ideas how to change my formula to get beyond the...	June 19th, 2009 08:43 PM by Jerry Whittle	2	141
#ERROR question by Elmtree via AccessMonster.com My formula: Mid(,InStr(10,,": ")-1) returns #ERROR if the value is blank, otherwise works fine. Any ideas how to change my formula to get beyond the...	June 19th, 2009 08:41 PM by John Spencer MVP	2	200
Can't edit my query by MorrisPoet Folks: A while back I created a table with a form to help me manage the production of my office's correspondence; recently, I broke the table up into three...	June 19th, 2009 08:37 PM by John W. Vinson	2	110
Query for combo box returning no result by gmazza via AccessMonster.com Hi there, I have a query for a combo box. I need certain values to show in the combo box based on the query but I can't seem to get it working. My form...	June 19th, 2009 08:33 PM by KARL DEWEY	1	174
Records missing from query/report by MarshaM Database of +7000. Query has criteria of sort by Doctor which points to Doctor table. 2 Doctors have no results returned even though the individual records...	June 19th, 2009 08:31 PM by John W. Vinson	2	117
Sorting by month by Kathi I have a field in my database for a surgery date and the month, day, and year are all part of one field. Now a user wants to be able to query by the month....	June 19th, 2009 08:30 PM by John W. Vinson	3	111
Help with counting in query by Cam Hello, I have a query trying add a column to count the number of records based on 2 matching fields/ columns. Not sure how to calculate or what function to...	June 19th, 2009 08:20 PM by KARL DEWEY	3	106
Query Line Numbering by gcutter I have a query that is pretty complicated that uses many other queries and the final query needs to have the rows numbered like in Excel. SO if I have 200...	June 19th, 2009 07:16 PM by KARL DEWEY	2	103
union query by jmoore[_2_] I have a union query that was working fine, and other queries based on it appear to be working fine. However, when I tried to open it today, a dialog box is...	June 19th, 2009 06:49 PM by John Spencer MVP	4	94
2 Databases in the same folder by Boon Hi, I have a folder name "Project" in this folder, I have 2 database files - Main.mdb and Data.mdb. I have a Make table query in Main.mdb. the Make query...	June 19th, 2009 05:20 PM by Boon	0	99
Month and Year only by Diggsy Hello, I want to display a date field {Visit] to show only the Month and year so I can do monthly totals. For Instance I would like the date 5/31/2009 to...	June 19th, 2009 03:07 PM by Stefan Hoffmann	1	93
ms access product function by Honestcon A simple query - I want to multiply two fields, CategoryPrice and ProductQua, from my Extras table. This is the code I wrote: SELECT...	June 19th, 2009 01:55 PM by vanderghast	1	98
Show data source in Union Select All Queries by Fluffygoldfish I have set up a Union Select Query, from several different queries and it returns the results I want (see below). However I would like to add an additional...	June 19th, 2009 12:28 PM by John Spencer	2	114
No Records Deleted Message by Micki I have a macro that runs a delete query that only deletes records if matching records do not exists in another table. The delete query is working fine, but...	June 18th, 2009 10:46 PM by Klatuu	1	101
Referencing a Caculated Field in another Calculated Field by Carlos When my query runs, Access keeps on asking (via a message box) to provide a value for a calculated field that I'm referencing within another calculated...	June 18th, 2009 08:01 PM by John Spencer MVP	4	155
Is it possible to update a report, based on a crosstabquery? by Nemo Hi All, I try to explain my problem. I have a database, which records the excursions on a lake, by motorboats. The number of the sailors is about 15...	June 18th, 2009 05:39 PM by Nemo	4	92
weight query by inungh I have data like following Student ID, Class Id, weighted, Result 1 1 10 70 1 2 3 ...	June 18th, 2009 05:34 PM by inungh	3	120
What's wrong with this query?! by PayeDoc Hello All I have: SELECT practices., DSum("!","","!= And !=140") AS total_ni, DLookUp("!","","!=") AS mthnum, staffs. FROM practices INNER JOIN staffs ON...	June 18th, 2009 05:10 PM by PayeDoc	6	113
Checkboxes Option Group Questions by zufie 1)I have an Option Group for two checkboxes on a form (ChckIBCCP & ChckOtherReferral). Clicking on ChckOtherReferral highlights other checkboxes on the form as...	June 18th, 2009 04:47 PM by tina	1	100

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