A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Running & Setting Up Queries Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
ODBC DSN query issue by EricStumpf
I've researched this to death, and many sources point to the same answer, yet I keep getting the DSN prompt box when I try to run a query with the user ID &...
April 30th, 2010 08:41 PM
by Sylvain Lafontaine[_2_] Go to last post
1 160
question driven query by Daryl S[_2_]
Steph - You could build a form that has the criteria checkboxes on them, and whatever other criteria you need. Then when someone clicks on the query, bring...
April 30th, 2010 08:01 PM
by Steph[_3_] Go to last post
4 165
Update Query by Glenn Dulmage
I have 2 tables: Member and Bulk Mail I have linked them on Last Name Member has these fields: First Name, Last Name, E-mail Bulk mail has these fields: First...
April 30th, 2010 06:19 PM
by Jeff Boyce Go to last post
6 142
Is Not Null Criteria Problem by AccessKay
I posted a question a while back for help to fix my query so that I wouldn’t have records showing with zero values for both months such Prod25 in the...
April 30th, 2010 03:39 PM
by AccessKay Go to last post
2 105
Duane Hookum's Concatentate - trouble in Access 2007? by HLCruz via AccessMonster.com
I have a database that I created in Access 2003; there are a few places where I use the code from Duane Hookum's concatentae funcion in my database. The...
April 30th, 2010 04:33 AM
by Duane Hookom[_4_] Go to last post
2 154
adding a new customer by bhrosey via AccessMonster.com
Ok, I have been away from Access for a couple years now and was only a moderate user to begin with. I am trying to build a database in 2007 that has several...
April 30th, 2010 02:28 AM
by Allen Browne Go to last post
1 193
Replacing individual characters in a field to something else. by vander via AccessMonster.com
I have a field with names that is pulled from a main frame database. These names have the last name first, then a comma, then the first name. I want to get...
April 30th, 2010 01:51 AM
by John W. Vinson Go to last post
1 129
Query crosses 3 tables by Jeff
I have 3 tables. tblPatient contains ID, Name, Age....., tblAdmission contains ID, PatientID, AdmissionDate....., tblCertificate contains ID, PatientID,...
April 29th, 2010 11:52 PM
by Jeff Go to last post
2 119
Convert to Proper or Title Case in Access 2003 by Jeff
I am trying to convert a field that is in all CAPS to Proper Case. Ex: Field Name is First Name, contents "ROGER". Desired way for First Name field to show...
April 29th, 2010 10:44 PM
by Marshall Barton Go to last post
3 256
Change expression from month to quarter by AccessKay
I have this expression in a calculated field in my query and it works fine for the month. I enter the month via a text box on an unbound form. I thought...
April 29th, 2010 08:51 PM
by AccessKay Go to last post
7 180
counts NULL values in query by Nathan
I am suing Access 2003. I need to a list of all "cases", and a count of "diaries" for each case, and I need a zero for any null values (ie, zero diaries for...
April 29th, 2010 08:25 PM
by Daryl S[_2_] Go to last post
4 136
Need null values for several fields in db by shahnaz
I have an equipment inventory db. I need to run a query that would give me the records that contain null values in several of the fields. I have run a...
April 29th, 2010 08:02 PM
by Jerry Whittle Go to last post
1 196
Append to two different tables by alhotch
I think I know the answer: I want to Append "working" table fields to two separate tables from a single Append Query. I believe the answer is NO. Can only...
(Multi-page thread 1 2 3)
April 29th, 2010 07:50 PM
by alhotch Go to last post
23 463
Query Criteria by ladybug via AccessMonster.com
I have a query where I am trying to get a count of items. The first column is: Less than 10: (IIf(10,"")) This gives a count for each queue that has been...
April 29th, 2010 05:41 PM
by ladybug via AccessMonster.com Go to last post
3 108
How to merge these 2 queries by DawnTreader
Here comes some hefty SQL code: qryNewRebuildReport SELECT tblproductpartlist.productid, tblproductpartlist.imwpartnumberid, ...
April 29th, 2010 05:34 PM
by DawnTreader Go to last post
1 113
Expressions by Amin
i want to write an expressions to concatenate these three things, Title,Last Name, First Name Contact Name: IIf(IsNull(),IIf(IsNull(),,),IIf(IsNull(),, & " "...
April 29th, 2010 04:46 PM
by Marshall Barton Go to last post
2 148
Count by short date and group by agent name by Whitney
I have a tracking table (tbl_Tracker) that now contains date and time in one field and agent name in another field . I would like run a query to do a count...
(Multi-page thread 1 2)
April 29th, 2010 04:33 PM
by Marshall Barton Go to last post
10 210
Sum a count total by Glenn
Hi, I have a query that shows the following information It looks at a specific table (table 1) then groups by sales agent, then groups the tariffs that have...
April 29th, 2010 02:38 AM
by Duane Hookom[_4_] Go to last post
4 155
Concatenate multiple rows by Cydney
Is there a good way to concatenate data from multiple rows into one field? I have several rows with different dates and I need to combine the comment text for...
April 29th, 2010 02:35 AM
by Duane Hookom[_4_] Go to last post
5 398
Count by Date by ladybug via AccessMonster.com
I am trying to create a query that will capture how long a particular record has been in a queue. I have another query called Status of Item. This query has...
April 29th, 2010 02:34 AM
by Duane Hookom[_4_] Go to last post
4 150
Post New Thread

Display Options
Showing threads 341 to 360 of 43289
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 OfficeFrustration.
The comments are property of their posters.