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
Simple Question on Addition by GwenH
I searched the discussion groups for the answer to what seems to be a simple question, but found nothing. I have a group by query with three...
December 1st, 2009 05:49 PM
by GwenH Go to last post
0 222
Simple Question on Addition by GwenH
I searched the discussion groups for the answer to what seems to be a simple question, but found nothing. I have a group by query with three...
December 1st, 2009 05:49 PM
by GwenH Go to last post
0 171
Return All Record if Check Box is Blank by yator
How would I return a subset of records if a form check box is checked but return all records if the check box is blank. The formcheck box is: !! The field ...
December 1st, 2009 05:29 PM
by yator Go to last post
0 159
Return All Record if Check Box is Blank by yator
How would I return a subset of records if a form check box is checked but return all records if the check box is blank. The formcheck box is: !! The field ...
December 1st, 2009 05:29 PM
by yator Go to last post
0 155
Duplicate Values in Query by AccessIM
I have the following code in a query: SELECT qryDisciplineLevelAll.EMPLOYEEID, qryDisciplineLevelAll.SSN, qryDisciplineLevelAll.NAME,...
December 1st, 2009 05:12 PM
by AccessIM Go to last post
0 165
Duplicate Values in Query by AccessIM
I have the following code in a query: SELECT qryDisciplineLevelAll.EMPLOYEEID, qryDisciplineLevelAll.SSN, qryDisciplineLevelAll.NAME,...
December 1st, 2009 05:12 PM
by AccessIM Go to last post
0 207
Return a date range based on today's date by BABs
I need to build a query (to be used for eternity) to return records for dates between 01 July (the year prior) and 30 Jun (the current year) based on the...
December 1st, 2009 05:08 PM
by BABs Go to last post
0 207
Return a date range based on today's date by BABs
I need to build a query (to be used for eternity) to return records for dates between 01 July (the year prior) and 30 Jun (the current year) based on the...
December 1st, 2009 05:08 PM
by BABs Go to last post
0 166
Complicated text to date query - urgently need help please by Heather
HIya, I've inherited a database with three text columns with dates in a text format. In each of these columns the text dates have been added in lots of...
December 1st, 2009 05:06 PM
by Heather Go to last post
8 240
Query twice with the same criteria == by dede
I will run two "make-table" query with the same criteria I call those two query from a form with DoCmd.OpenQuery the criteria in the query is twice...
December 1st, 2009 05:05 PM
by dede Go to last post
0 157
Query twice with the same criteria == by dede
I will run two "make-table" query with the same criteria I call those two query from a form with DoCmd.OpenQuery the criteria in the query is twice...
December 1st, 2009 05:05 PM
by dede Go to last post
0 136
period question by mccloud
I have a form that a user can enter the number of periods to review up to 24. Current period (Nov 2009) is 23. How can I calculate the correct periods to...
December 1st, 2009 04:13 PM
by mccloud Go to last post
7 216
Append Query To Table by Gary
I have 6 tables which have identical fields and they all have a Primary Key which is AutoNumber. I have a final table which has the same fields and also has...
December 1st, 2009 03:33 PM
by John Spencer Go to last post
5 196
Year Minus One by Ann
I am using Access 2002 and have a two character text field that holds the last to characters of the current year, (example 09). I want to retrieve all the...
December 1st, 2009 03:32 PM
by Ann Go to last post
0 152
Year Minus One by Ann
I am using Access 2002 and have a two character text field that holds the last to characters of the current year, (example 09). I want to retrieve all the...
December 1st, 2009 03:32 PM
by Ann Go to last post
0 171
Best Prometric Center@ Delhi by Everonn Delhi
Are you looking for the best Prometric exam center for your certification like Microsoft, Sun, IBM, and HP*? Then you are at the right place; Just come and...
December 1st, 2009 12:11 PM
by Everonn Delhi Go to last post
0 173
Returning null values by Joseph Greenberg
I have a report where I think that certain fields are not shrinking because while I think that the associated query fields look blank, they are no in fact...
December 1st, 2009 08:04 AM
by Joseph Greenberg Go to last post
4 216
Summarizing quantities by Part Number by Deb
This query is working, but I'd like to "summarize" the quantities by "PartNo". How do I go about doing that? SELECT DISTINCTROW sqry_Inventory.Program,...
December 1st, 2009 01:37 AM
by John W. Vinson Go to last post
3 182
Query critieria to exclude 2 words by Pasadena-D via AccessMonster.com
Hello, I have a query that I want to run to pull data, but I want it to exclude "Complete" and "Approved" in the Status field, and return everything...
December 1st, 2009 12:44 AM
by Pasadena-D via AccessMonster.com Go to last post
2 222
Obtain Top Value from Table by yator
I am attempting to pull a random set of records using a Random Number and the Top Value function. The Top Value changes depending on the specific group I am...
November 30th, 2009 10:26 PM
by John Spencer Go to last post
9 272
Post New Thread


Display Options
Showing threads 2121 to 2140 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 11:00 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.