Running & Setting Up Queries - Page 654

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
Records in a query between a one-many rel. not allowing data entry by Giem Hey all, I'm fairly new to database design, and have a problem with a query to add new information into tables in Access 2003. I have a repair table in...	January 25th, 2008 07:28 PM by Giem	3	171
String Manipulation help needed by jamesfreddyc[_2_] I have a text field, but consists of numbers -- always the same number of characters in length. For example, "0001040047" I need to change all records in...	January 25th, 2008 07:23 PM by John Spencer	6	182
Pull Specific Data by Previous Month's Date (Date Entered via prom by Vylent Fyre[_2_] Below is the table that houses the information (I'm just showing November and December 2007 for simplicity's sake.) Month Company Curr Month BV Amount Due ...	January 25th, 2008 06:13 PM by Conan Kelly	1	129
Add users to SQL Server by Dale Fye Not exactly sure where I am likely to get an answer to this question, so have cross-posted to a couple of Access and SQL Server newsgroups. I've got an...	January 25th, 2008 04:45 PM by Haggis[_2_]	6	168
change a zero's to null in a table ? by Haggis[_2_] Hello all, without using a search and replace utility , is there a method to remove or change any field that contains a '0' to null ? TIA David	January 25th, 2008 04:39 PM by Haggis[_2_]	4	125
query on multiple tables by harleyken To all; My form has from Classes_Available and stores the ID to be used later. when the combo2 after update opens a sub form which shows all of the classes...	January 25th, 2008 03:10 PM by John Spencer	4	100
delete duplicate record by SMT I have a table that lists innovations and has a planneddate, completeddate, and a directorate for each innovation. I need a query that will count the total...	January 25th, 2008 02:45 PM by SMT	2	122
update ... grouping ... replace ???? by jer Pymt No. txr ref dr cr 34567-1 25 20628941 130.00 24685-1 32 20628941 100.00 34567-1 30 20628941 20.00 24685-1 ...	January 25th, 2008 01:20 PM by jer	5	115
Return Day of week by Mo Hello all, Is it possible for a given date to return the day (i.e. Monday, Tuesday etc)? I've searched high and low for a way of doing this to no...	January 25th, 2008 11:21 AM by Mo	3	116
NOT...IN subqueries returning no records by Trimtrom Hi I have just written the following query: SELECT portal11Jan.USER_NAME, portal11Jan.SUCCESS, portal11Jan.LAST_SUCCESS, portal11Jan.FAIL,...	January 25th, 2008 09:48 AM by Trimtrom	3	93
Query is making a nuts by Craig[_7_] Hi Using Access 2007 I have a table and two of the fields (Status and OrigStatus) have, among other possible entries, the words "Member," "Customer" or...	January 25th, 2008 04:33 AM by Craig[_7_]	6	104
Trying to pull the top number of vists AND the assocaited user's nameby client by [email protected] Hello everyone- I am trying to pull the name and number of visits for the top visitor to a website by client and I am having trouble. Each client can have...	January 25th, 2008 03:40 AM by [email protected]	2	87
Calculations based on varying number by Ann I am new to Access and am creating a database that tracks contract trades. I have the following tables that I need info from Trade Details (trade #...	January 25th, 2008 02:28 AM by Rick Brandt	1	126
2-step Inventory List Generator by wwojtale I'm trying to create an inventory database that has two main types of items, each with distinctly different sub-items. I want to select the general item in...	January 25th, 2008 02:07 AM by wwojtale	2	95
Group by & Sum by tryn2learn Good afternoon, Iâ€™m trying to sum and group data in a query. Right now my query looks like this (example below) multiple PERL...	January 24th, 2008 11:16 PM by KARL DEWEY	2	107
another fieldname problem by [email protected] Hi: Another Fieldname question: Is there any way to construct an If--Then-Else clstatement as a query Fieldname in order to set the value of the queryfield...	January 24th, 2008 11:00 PM by KARL DEWEY	5	87
Query Problem - Relationship? by Golfinray I have 3 tables, 06-07 projects, 07-09 projects, project construction. All three I set School District Name as the primary key. When I go to relationships, I...	January 24th, 2008 08:08 PM by rolaaus[_2_]	3	103
Calculating diff btwn two dates how to count only business days by Jerry In calculating difference between two date how can one not include weekends and count only regular business days?	January 24th, 2008 07:54 PM by John W. Vinson	2	121
Adding record number to existing table by argear I'm trying to write an update query to add a record number to a group of records. The table looks like this: ID Name Date Day 1 Jane ...	January 24th, 2008 07:33 PM by KARL DEWEY	3	102
changing an ID to a user friendly name by Harold Good Hi, I'm designing a query, one of the fields is an ID. These single digit numbers means nothing to me or the user. How can I include in the query design the...	January 24th, 2008 07:26 PM by Harold Good	2	147

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