Running & Setting Up Queries - Page 1056

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
Query and Chart by cho Hi, I am creating a form and trying to insert a chart. The chart wizard just allow me to enter 6 fields, while I have 10 fields,how to enabled it.And How to...	January 8th, 2007 09:30 AM by cho	4	103
Weird Parameter problem by JustMe I was trying to create a form to enter parameters for my query for a date range. I followed all instructions and could not get my query to work or recognize...	January 8th, 2007 07:26 AM by JustMe	4	106
Show all machines or only one by JeroenM Hi, I have the following question: I have a table with all kinds of data including the machine number. I also designed a form with a text field where you...	January 8th, 2007 06:45 AM by JeroenM	2	94
If condition in Builder by liuqian How to write If condition in Builder? I want to write: if a field = a certain value, such as 1, then another field = a text statement, such as good. Can...	January 7th, 2007 10:48 PM by liuqian	5	129
Running queries on new record and record modification by John Hi I need to run a query when a new record is inserted and another one when a record is modified. What events do I need to trap? Thanks Regards	January 7th, 2007 10:36 PM by Van T. Dinh	1	106
Look up - on a query by Fekla Hello. I am a newbie in Access. I am making a Boostore database. Here is the relationship in problem: http://moryasha.narod.ru/acc.gif I set the Data Type... ( 1 2)	January 7th, 2007 09:48 PM by Fekla via AccessMonster.com	10	223
query with two tables by Steef I'm a novice with Access, but I have to learn it for an assignment for university. The fact is that I have two tables. The first is called tblStudent, with...	January 7th, 2007 08:16 PM by fredg	1	88
Transaction Support in Access by Rahul I am using VB.NET 2005 to program a Database Application, with Access 2003 as the DB backend. Every now & then, I have to make a series of updates to the...	January 7th, 2007 07:31 AM by Rahul	2	157
Cross tab query with more than one data column by JoeA2006 I need to know how to add a column to a crosstab query since the wizard only allows one column. The columns are monthly data, but I need 2 columns for each...	January 7th, 2007 05:57 AM by Duane Hookom	3	115
Office Online Discussion Groups by Dale Fye From work, I am unable to use Outlook Express to access the office news groups, so I have to use the web based Discussion groups. Why is it that when I...	January 7th, 2007 03:40 AM by Dale Fye	3	177
Question Regarding Combining Duplicate Records by [email protected] I have a situation where I have quasi-duplicate data which looks like the following: Unique ID Name Location Color Revenue 1 A ...	January 7th, 2007 12:47 AM by KARL DEWEY	3	108
Comparing telephone numbers by Bill Hi All, I need to compare loads of telephone number in two separate databases that have been entered with spaces in different places. Unless I am missing...	January 6th, 2007 05:58 PM by Bill	3	106
microsoft access error 3306 by [email protected] How do I fix this query? Access will not let me do this though I can in other databases... SELECT * FROM database_schemas WHERE (database_instance, schema)...	January 6th, 2007 05:10 PM by John Spencer	8	175
search and match TEXT and return what is leftover? by [email protected] Hi I have a list of text values within a field in access and I want to return the text that appears to the left of that it the field value matches specific...	January 6th, 2007 03:36 PM by Marshall Barton	2	108
User Defined Pop Up Warning by ray Hi all and happy new year! I have little issue i can't seem to get a grasp of so hopefully someone has a simple solution. I have a pop up warning box setup...	January 6th, 2007 05:32 AM by Duane Hookom	1	95
Date Criteria Issue by mattc66 via AccessMonster.com I have a fld that contains the date as text. I have using the below statment converted it to a date. =IIf(IsNull(),Null,DateSerial(2000 + Val(Left(,2)),...	January 6th, 2007 02:11 AM by Ken Snell \(MVP\)	5	167
Help me construct this count distinct query! by S Davis Hi guys, I'm at my wits end, and just can't get what I want out of this query. After some preparation, this is where I am at: OBJ_CODE OBJ_MRC ...	January 5th, 2007 10:28 PM by S Davis	5	155
Hockey Stats Database Total Help by Jason Lepack So here's what I'm up to. I save the webpage from USA Today. http://www.usatoday.com/sports/hockey/nhl/skaters.htm I click the button and it checks to see if...	January 5th, 2007 09:51 PM by Jason Lepack	7	104
Pulling data out and understanding total queries by John T Ingato I will do my best to explain what I am after. See below SQL and brief table descriptions at the bottom of this post. I have a table with inventory counts for...	January 5th, 2007 09:38 PM by John Nurick	3	192
Extract information from memo field by Amy Hello everyone: Happy New Year! We have a memo field (on SQL Server back-end) that contains different field information on separate lines. (We are...	January 5th, 2007 09:30 PM by John Nurick	3	78

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