Running & Setting Up Queries - Page 1109

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
Countif in Access by drose I have created a joined column showing Customer Name & order number & Date in order to create a unique identifier for each order. There are instances of...	November 20th, 2006 03:30 PM by KARL DEWEY	4	79
bloomberg functions by ragtopcaddy via AccessMonster.com Does anyone know if there is a way to implement Bloomberg functions in Access? If there is no direct ability to do so, has anyone had experience working around...	November 20th, 2006 03:19 PM by ragtopcaddy via AccessMonster.com	0	85
default values in a field by jac007 Hi, I want to have "000" in a text field as default if someone doesn't enter a text or a number in that field. The field is a text field and allows only 3...	November 20th, 2006 02:09 PM by Rick Brandt	1	89
If two fields are equal select only the highest value by Craig Hi I would like to build a select query that pulls all records and all fields (about 8 fields) from a table where the records are unique in terms of id code...	November 20th, 2006 02:08 PM by Craig	2	106
Month to date query by hotplate Hi, I am trying to write a query that does a count of occurrances for each day in a month starting on the first day of the month. How do you set the criteria...	November 20th, 2006 01:41 PM by John Spencer	2	65
Append to table but ensure no duplicates by Russ via AccessMonster.com Help, I have a card scanner that will create an Access database with the table called Contacts, I need to append / insert this information into my... ( 1 2)	November 20th, 2006 01:19 PM by Russ via AccessMonster.com	16	153
IIF Query by Annie Hi Is it possible to have a nested IIF function in an Access query. I can handle the normal IIF(10,"reorder now"," ") but was looking to include more...	November 20th, 2006 12:57 PM by BruceM	4	98
SUM CONDITION VERY DIFFICULT!!!Please help me by AN Thanh Nguyen I have a table: idex name codequestion mark 1 A MS_HR_RI1 40 2 A MS_HR_RI2 20 3 A MS_HR_RI3 ... ( 1 2)	November 20th, 2006 02:30 AM by AN Thanh Nguyen	16	192
Need Help with Counting of Sequence for worked hours by [email protected] I have a query that has the following fields and data: EmplID, EmployeeName, Job Code, Cost Center, InPunchDate InPunchTime OutPunchDate, 235689 Mouse, Micky ...	November 20th, 2006 02:01 AM by Allen Browne	1	50
Query For Multiple Criteria Related to 1 Or More Unique Elements by Devlin I asked this question a bit earlier, but feel that I might need to be more clear on my need. Here is an example of my goal. Lets say we have a database of...	November 19th, 2006 11:03 PM by David F Cox	1	80
Automatically Delete Duplicated Entries Error by faxylady When attempting to do an Automatically Delete Duplicated Entries Procedure on a Contacts infomation table imported from Outlook, I get the following message...	November 19th, 2006 10:49 PM by faxylady	2	60
Iif coding seemingly not working by ARY Alright, I have a table for each of my employees. We test for ten separate second languages, and I have a field for each of these languages, containing a...	November 19th, 2006 03:06 PM by David F Cox	4	70
Percentage of Defects by Shift by CevinMoses I have 3 shifts defined by the ID number of their foremen . Product 4620 can have several defects , of which "04" is the one I am trying to analyze. I have...	November 19th, 2006 05:41 AM by jlepack	4	130
make-table with field as name by miss031 For archiving purposes, I would like to make an automatic query that, when ran, would make a new table with a particular field as the name of the table....	November 19th, 2006 04:53 AM by miss031	2	85
DCount on multiple tables by botuco via AccessMonster.com I have three tables in my database with the following fields: TbAo - AoID (autonumber) - StudyID - AoRead (number field, value from 1 to 5) TbStudyInfo -...	November 19th, 2006 04:18 AM by botuco via AccessMonster.com	2	90
open query in another database by geebee hi, I would like to know the code to open a query in another database from my database, and how to run part of a module in another database from my...	November 19th, 2006 01:03 AM by freakazeud	1	71
Outer join adds calculated value to all records by JimJ I'm finding in Access 2003 SP2 that, when I do a left outer join, a calculated field in the right query is propagated to all records in the outer join, not...	November 19th, 2006 12:16 AM by Jerry Whittle	3	100
Update Query in a Subform with Sums by mjtan I have a real-estate database. The Main Form contains all the detail of a specific property (e.g.Address, Size, Status, Value). I have a subform that counts...	November 19th, 2006 12:06 AM by kingston via AccessMonster.com	9	79
Problems with IIF by mattc66 via AccessMonster.com Okay I am going bald pulling my hair out. I have tried the below two options and neither result works. If company = C1 then display WDNVL and etc. What am I... ( 1 2)	November 18th, 2006 07:50 PM by KARL DEWEY	10	150
#Error in select query by Aivars Hello, I am getting #Error in VAL field when I do very simple query based on qryKS3 query: SELECT * FROM qryKS3 WHERE round(,2)=0.01 here is qryKS3:	November 18th, 2006 07:25 PM by Aivars	6	142

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