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
Select Criteria in a Query by Adding Selected Range into Query
I was wondering if it were possible to add the select criteria into a field in the query. Example: when I run a query that pulls information based on a date...
August 31st, 2004 07:12 PM
by Duane Hookom Go to last post
1 145
Query to delete records by Jk
Hello, I had placed a posting on design group to clean out my 50 test records from my tables so i could get a fresh start on my new database.The response was...
August 31st, 2004 07:10 PM
by Duane Hookom Go to last post
1 296
criteria for an empty date by June
Hi, History: In my database I fill in a record for a product but not the date field until the product is completed. My reports will not show this...
August 31st, 2004 05:51 PM
by June Go to last post
3 185
Autonumber in a query by Fabio
How can I include an autonumber in a field of a query ? Or hoe can I select just the 5 first records of my query?
August 31st, 2004 05:29 PM
by Fabio Go to last post
2 158
Mtd Question by CR
I have a built queries to give me monthly totals, but the problem is that by using Month(Now()), I get the current month when it is the 1st day of the month...
August 31st, 2004 05:11 PM
by Crown Royal Go to last post
4 185
Make Table Query??? by [email protected]
I have several tables, each being a month's worth of data. I need to be able to produce a report spanning a 6 month period, with the user being able to chose...
August 31st, 2004 04:29 PM
by Lynn Trapp Go to last post
1 162
How do I limit the number of records in a query. by rnprice
If I have a query that is combining information from two or more tables, one of which has a date field, and I want to limit the query to the most current 20...
August 31st, 2004 04:27 PM
by rnprice Go to last post
2 380
PASS THROUGH QUERY WITH ORACLE BACK END by nique
Hello, having problems using the pass through query to pull data off of an oracle back end. I have created an odbc user data source but I still get an error...
August 31st, 2004 04:09 PM
by Lynn Trapp Go to last post
7 216
The Query Grid Disappeared by Cyndi
The query grid will not display - only the field list. How can I fix? Thanks.
August 31st, 2004 02:30 PM
by Joan Wild Go to last post
2 123
Date/Time by
Hi There, I have a query that uses the Date\Time function and displays it as DD\MM\YY HH:MM:SS. I'm trying to extract any occurance of where the time is 30...
August 31st, 2004 02:29 PM
by Go to last post
4 162
Automatically Connecting to SQL Server by mac
Can anyone tell me how to automatically connect to SQL server? I am always prompted for a Login ID and Password on the SQL Server Login Windows. Use Trusted...
August 31st, 2004 02:28 PM
by Van T. Dinh Go to last post
1 199
Unable to Update Table by CK
I have a form based on a query of several tables but I could not update the fields of the table in the query. I used to be able to do that...is there something...
August 31st, 2004 02:19 PM
by Van T. Dinh Go to last post
1 104
Query Results- Incorrect formatting by Mark Senibaldi
Hi, I have a query that is summing up column A which is formatted as Number-Double in it's current table. The results of the query should show up as 0, but...
August 31st, 2004 01:25 PM
by Mark Senibaldi Go to last post
3 221
Merging with an Access 2002 parameter query by Trevor
Hi, I am using an Access 2002 query to link to a word 2003 mail merge. I have used the "confirm conversion at open" method but still cannot see the...
August 31st, 2004 01:25 PM
by Trevor Go to last post
4 318
Get time from DATE/time field? by Anon
Hi Everyone, Stupid question here, but does anyone know how to get just the date out of a date time field? All of the examples lean toward DD, or MM, but I...
August 31st, 2004 12:59 PM
by Go to last post
8 182
Stopping Applications on Startup by n j marsh
When i start up my pc a lot of applications start up at the same time e.g. quicktime player, kodak , casio photoloader etc . They are shown in the taskbar...
August 31st, 2004 12:44 PM
by Michel Walsh Go to last post
1 97
Creating Queries by Harjit S Gill
How to create a query that shows duplicate records?
August 31st, 2004 12:27 PM
by T Go to last post
1 84
How to use a loop? by noclue?
How to use a loop? I had problem querying the number of yes or no, to a table? I need to display a table based from the 3 fields from a table(branchinfo)....
August 31st, 2004 12:25 PM
by Gary Walter Go to last post
1 87
select (distinct fieldname) in access ? by Paulo Nunes
Hi all Is it possible to do this in MS Access? select (distinct fieldname) from ... If not, is there an alternative? Thanks in advance
August 31st, 2004 07:22 AM
by Van T. Dinh Go to last post
3 178
Week and month total query by WylieC
I have a db that I use to track mileages. How do I make a query that displays two different totals: the current months totals to date and the weekly total to...
August 31st, 2004 05:20 AM
by Duane Hookom Go to last post
1 242
Post New Thread


Display Options
Showing threads 41281 to 41300 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:14 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.