Running & Setting Up Queries - Page 997

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
INCREMENTAL NBR VS. AUTONUMBER WHEN APPENDING by Tank When appending batches of records into a master table, I want ID numbers automatically created to start with the next available record number after the...	September 30th, 2006 04:11 AM by Tank	2	56
Changes to Tables by Simon I have a "master" table and an "updates" table in an Access database. "Updates is imported from an excel spreadsheet with changes to some of the records in...	September 30th, 2006 06:10 AM by Simon	4	62
Union Query Report Code???? by Joseph I have a small business that I run, and I have used Service Time Management wizard to build my database, with some personal changes due to the personal...	September 30th, 2006 06:45 AM by John Vinson	7	77
IsEmpty() not giving expected results by SRussell I am trying to get a count of how many columns have data entered. This is non normalized and I'm not paid to fix that :( So I am trying to get the count of...	September 30th, 2006 10:24 AM by Gary Walter	9	108
Output Query to Excel by Kathy Webster I have aYes/No field in a table. When I output it's select query to Excel, the field is printing out as True/False. How can I make it print as "Yes" or "No"...	September 30th, 2006 04:25 PM by TedMi	2	43
IIF function not working properly in my access database by blue I am trying to find out the delay in days occurred between two date fields in an MS ACCESS 2003...	September 30th, 2006 05:11 PM by Duane Hookom	1	55
export query to Excel by Song Su Access 2003 I have a query called MyRoster. I setup a form and ask user to type in Employee Number which will be a criterial in my MyRoster query. I want...	September 30th, 2006 06:08 PM by Song Su	5	75
Help! How do you calculate days within two date fields by Rose I am working with a Microsoft Access Database helping a non profit organization try to figure out how many nights in a month people are staying in there...	September 30th, 2006 08:13 PM by MGFoster	2	56
Insert only unique records to new table by Rakesh Parekh Hello, I have following query it just work fine and faster with say below 100 records or so. But I want the same query to run in a table where there are...	September 30th, 2006 08:23 PM by MGFoster	2	58
Insert a record by shapper Hello, I have an Access database table, named web_MailingList, with 4 fields: SubscriberName, SubscriberEmail, SubscriberDate, SubscriberId SubscriberId is...	September 30th, 2006 10:25 PM by Neil Sunderland	1	73
Query: Return Value by shapper Hello, I have an Insert Query as follows: INSERT INTO web_MailingList ( SubscriberName, SubscriberEmail, SubscriberDate ) SELECT , , ; My question is, can I...	October 1st, 2006 12:54 AM by Neil Sunderland	1	82
Calculation Challenge by Rose This is a calculation challenge for a non profit to calculate how many nights during a given month did people stay in there shelter. This is the challenge. ...	October 1st, 2006 03:13 AM by John Spencer	3	79
Column values to single string by John Hi I have an email column in a table. How can I turn values in the column for all records into a single string with each email separated by a...	October 1st, 2006 03:35 AM by Numfric	2	67
Run Query to group Data by Week Number by BYoung via AccessMonster.com I'm trying to build a query off of a table that basically sumarizes by week number instead of date. so in my query I have these fields tech number - shows...	October 1st, 2006 05:28 AM by BYoung via AccessMonster.com	5	88
Union two queries by mustish1 via AccessMonster.com Hi: How to i union both queries. Both queries match record from tabl tech_id. This is the result which i need. First 2nd query run and match with...	October 1st, 2006 05:58 PM by mustish1 via AccessMonster.com	0	108
Help in query by mustish1 via AccessMonster.com Hi: Can any one please help me in creating query. Criteria is that: If LstVldAccount="OtherAccount 1" then match tech_id.corp with Val(Left( .,5 If...	October 1st, 2006 10:02 PM by John Vinson	2	69
UCase and Initials by JarrodMadd I need to find out how to convert this: Susan Brown to SUSAN BROWN and also how to convert this: Susan Brown to	October 1st, 2006 11:29 PM by JarrodMadd	4	130
How to use a query field as a parameter to requery DB by Dummy Table fields = Name, Sire, Dam. I want to set up a query so that you enter the Name of the animal and the query picks up the rest of the pedigree using Sire...	October 2nd, 2006 01:46 AM by Van T. Dinh	3	68
Query for Primary key by zweet18 I want these all QuoteID not to appear in one of my report QuoteID is my Primary key and this my query. iif((iif(858 and 910) and iif(992 and...	October 2nd, 2006 03:53 AM by zweet18	4	133
Yes\No;"" Value list by zweet18* Need help i have a value list of Row source type: Value List Row source: -1;"Yes" 0;"No" "*";"Yes/no" everything is fine except for yes\no value	October 2nd, 2006 05:20 AM by Duane Hookom	2	82

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