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
left join not working by PeterW
I am sure I must be missing something simple here but am lost if anyone can help. I have an database that tracks enquiries and have a table 'source' for where...
February 26th, 2010 03:19 PM
by PeterW Go to last post
2 262
Yes/No parameter for Yes or No or Both by Owl
RonaldoOneNil gave me the very useful info of: =IIF(="Yes",True,False) for a parameter query criterion (for a check box in a form). I would like to know...
February 26th, 2010 02:19 PM
by Owl Go to last post
7 258
how to build expression with conditins and totals by fossy
Ok... I have 3 tables (tbJOBS, tbDept1, tbDept1_DwnTime) and a query that returns: all the jobs ran on range of days ( criteria: between day1 and day2); the...
February 26th, 2010 02:04 PM
by John Spencer Go to last post
1 167
How do you create an autonumber column in a query? by drewdog
How do I create an autonumber colmn in a query?
February 26th, 2010 08:22 AM
by Allen Browne Go to last post
2 292
Grouping - Distinct by Darrel
I'm trying to create a query from 2 joined tables. EMP & Quizzes are joined on EMP_ID In the results, I'd like to have one row for each employee with a column...
February 26th, 2010 01:23 AM
by Darrel Go to last post
5 272
Crosstab By Date (Month) by Terry
I need to write a crosstab on a shipping table that has the Customer as the row heading, month as the column heading, and sum of shipped as the value. The...
February 25th, 2010 11:15 PM
by Terry Go to last post
5 191
In crosstab query, how do I count not including duplicates? by Ojoj
I have a table which lists contacts with people including the field 'FamilyID'. I want to count the number of different families the organisation has had...
February 25th, 2010 08:43 PM
by John Spencer Go to last post
2 206
wildcard symbols around a field in a join? by Ben8765
Hi, This is my SQL QUERY: SELECT Table1.NAME, Table2.NAME FROM Table1 LEFT JOIN Table2 ON Table1.NAME = Table2.NAME; The issue is that Table2 has NAME...
February 25th, 2010 08:15 PM
by Ben8765 Go to last post
6 198
Add Fields to a query that are not included in an aggregate functi by Marc
I have a query with aggegated functions. SELECT Count(Classified) AS TotCnt, Abs(Sum(classified=-1)) AS TrueCnt_Unclassified, TrueCnt_Unclassified/TotCnt AS...
February 25th, 2010 07:33 PM
by John W. Vinson Go to last post
3 281
simple syntax issue by Mark Kubicki
I'v blind this morning to an error in the syntax of my code.. if somone would please take a look over my shoulder and redline the error... many thanks in...
February 25th, 2010 07:24 PM
by Mark Kubicki Go to last post
2 230
Query: Calculating by Boon
Hi, I have a table A. Table A has 2 fields - Sale1 and Sale2. I want to create a query that will sum the value in Sale1 and Sale2. In the query I wrote ---...
February 25th, 2010 07:15 PM
by KARL DEWEY Go to last post
2 178
List Macro Actions by yator
Is there a way (maybe with MSysObjects) to list the Conditions, Actions and Comments for a Macro? All I have been able to do is Screen Print, but would like...
February 25th, 2010 06:49 PM
by fredg Go to last post
3 198
Multiple criteria in query causes errors in report by Nancy via AccessMonster.com
I am running a weekly management efficiency report that is based on a query. In that query I specify the supervisor's name, the week end date and the day of...
February 25th, 2010 05:38 PM
by Nancy via AccessMonster.com Go to last post
3 222
queries using the not command with more than one item by access query question using not
trying to do a query using not "example" or "example" can on ly get this to work with one item, not more than one need to say not abouit 8 items how do i...
February 25th, 2010 05:07 PM
by KARL DEWEY Go to last post
1 268
pass through query by Sam
If a combobox is populated by a pass-through query, does it requery every time the form is closed and reopened? Thanks, Sam
February 25th, 2010 02:19 PM
by John Spencer Go to last post
1 220
Invalid syntax in dlookup by Maresdd
I am trying to lookup information from a table using the dlookup function. Using a subquery worked beautifully but it won't allow me to use a subquery in a...
February 25th, 2010 06:15 AM
by John W. Vinson Go to last post
4 229
Best way to set up Query to get a percentage by Marc
I have a "classified" field that is a yes/no check box to determine if a supplier has been classified or not. I need to get the sum of suppliers that are and...
February 25th, 2010 06:13 AM
by Duane Hookom[_4_] Go to last post
4 236
Update with subquery[complex] by Joost de Vries
Hi, I'm currently working on a script that will be executed when someone deletes a "team" entry from a quality control database. The database contains teams,...
February 25th, 2010 05:43 AM
by david Go to last post
8 384
Query to get information that doesn't match by date by GMC -LSND
I have a table named TTIME with columns in it named: Casenum, Tidate, Reason, Snum I have a table named CLIENTSCASENOTES with columns: Casenum, CNdate,...
February 24th, 2010 11:30 PM
by KARL DEWEY Go to last post
2 208
secure my access problem, Importing the Database. by naveen prasad[_2_]
hi all I have created a small project and my project max I can In all forms design view, allow design view option NO. mainly at tools-start up- unchecked...
February 24th, 2010 10:48 PM
by John W. Vinson Go to last post
6 243
Post New Thread


Display Options
Showing threads 1081 to 1100 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:21 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.