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
Query to return a subset of a set by David Wetmore
I have an M2M relation with a link table (tblTagLinks) containing parent keys (PKey) and child keys (CKey). I want to return the smallest set of PKey values...
May 10th, 2008 06:56 PM
by David Wetmore Go to last post
1 138
cutting off all but the first two letters by paul69
Hi, I have Access 2002. I want to create a query so that only the first two letters of an email appear. How do I create such a query? Thanks in...
May 10th, 2008 06:33 PM
by Naz Go to last post
2 109
Strange values when summing in a query by Kjell Harnesk[_2_]
Why is it that a query in Access resturns strange values when summing simple figures. Example: I have a number of records with a number field values like 8 ...
May 10th, 2008 06:20 PM
by Douglas J. Steele Go to last post
1 101
Query by days by Naz
-- _______________________ Naz, London
May 10th, 2008 11:19 AM
by Naz Go to last post
0 93
Access and servers question by Dupatt
I am getting resistance to using Access databases at work because some people who I believe don't know what they are talking about. I am told that when...
May 10th, 2008 07:43 AM
by dddddddd Go to last post
9 148
How do I the pull the first name from a fullname field in Access? by Robert in need of a Guru
I have a field that includes the full name of a customer. Unfortunately, I never set up separate firstname and lastname fields. Is there some way I can pull...
May 10th, 2008 04:45 AM
by Robert in need of a Guru Go to last post
4 161
Filtering duplicate participants from query based on a study name by Puciral
I have been working on a database that matches participant demographic information to the studies they have participated in. Each study and participant has...
May 10th, 2008 12:53 AM
by Puciral Go to last post
1 116
not display date in past by H0MELY
Thank you for looking at my question. I have a table that is full of information about phones and their locations...we can call it a service file. The...
May 10th, 2008 12:20 AM
by John Spencer Go to last post
2 126
Month Captions and Labels by Jasper Recto
I have table that has 3 fields. Part Number DueDate Order Quantity Using that table, I created a query that takes each due date for each order and...
May 9th, 2008 09:41 PM
by KARL DEWEY Go to last post
1 117
How do I filter data by blank cells in access by Jason
I am new to this so be easy on me, please. I have linked to an ODBC table, and a few excel sheets. When I go to query I want to filter data by a collum that...
May 9th, 2008 09:17 PM
by John W. Vinson Go to last post
8 117
SQL Statment Help Needed by Query Help
I have 22011 records in table "tblProcChargCounty " when I create a query between this table and tblFacility table, I have 22011 records, but I try to add...
May 9th, 2008 08:51 PM
by KARL DEWEY Go to last post
3 133
Subquery help by K
I think I can do this in one query but I am not sure the verbage. I have the following scenario: Lname FName DOS Provider1 ...
May 9th, 2008 08:26 PM
by K Go to last post
2 83
Creating an All option in a combo box that will pull all records by H0MELY
Thank you all for looking. Basically I have a form with a pre-populated combo box and a command button. Lets say the combo box values are All, Option1,...
May 9th, 2008 07:35 PM
by H0MELY Go to last post
8 100
games on Excel by Games will not open
I have several games that are on EXCEL that were working properly. Now they will not open or load. What happened and how do I fix them?
May 9th, 2008 06:30 PM
by fredg Go to last post
1 120
InStr with Or? by yator
I was using the following InStr() to extract data from a field. The string I am extracting begins with “!TCANC” and ends with an ASCII Null. I have now...
May 9th, 2008 06:19 PM
by John Spencer Go to last post
4 106
SQL Help Needed - Revisited by carl
I posted yesterday but did a poor job of explaining my task. I'm trying again. My apologies. Thank you all who tried to help. I need a query that will do the...
May 9th, 2008 05:58 PM
by John Spencer Go to last post
4 146
List all not in other table by Question Boy[_2_]
I need to generate a list of all the Project Number in a table that do not appear in another table How would the SQL synthax go? Table 1 Name:...
May 9th, 2008 03:33 PM
by Marshall Barton Go to last post
2 92
90 day increments by Annette[_3_]
I have a start date for a client stored in a table. Each client needs to be reviewed every 90 days (do not care about working days or holidays -- just a...
May 9th, 2008 01:46 PM
by Annette[_3_] Go to last post
4 92
IF function in Query by Supe
Can an IF function be used in a Query? I set up the IF function below to use in an Excel worksheet to list the Banner name by searching for a name within...
May 9th, 2008 01:46 PM
by Supe Go to last post
2 104
Create query that sums up categorical data by Liz Yetter
Hi- I need some help with Access 2003 queries. Please keep in mind that I am NOT a programmer. I have a table filled with gender (male or female), race...
May 9th, 2008 12:55 PM
by John Spencer Go to last post
2 104
Post New Thread


Display Options
Showing threads 11061 to 11080 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 09:34 PM.


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