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
Min function by Boon
Hi there, I want to use a function that finds a minimum between a list of number in query. I don't know what this function is, so I will call it "Func" For...
September 4th, 2008 03:56 PM
by Dale Fye Go to last post
1 177
Return only the 1st and 10th record in a Recordset by Eka1618
Hello, I am using the following query (qryTorqueTestReportResults): SELECT tblResults.Q_INC, tblResults.SAMPLE_NO, tblResults.FAILED_AT, tblResults.P_F,...
September 4th, 2008 03:47 PM
by Eka1618 Go to last post
4 350
Renaming field names of Linked Table in query by deeds
I have a linked table from our system...it's field names are "codes" (hard to understand). So, I created another table with those code names and a field...
September 4th, 2008 02:53 PM
by Tom Amoroso Go to last post
8 386
Exclude by earrozz via AccessMonster.com
I have a database from which I have to produce weekly reports excluding previous week report. Below is an example how the reprt should look like. Logged Date ...
September 4th, 2008 02:39 PM
by NetworkTrade Go to last post
1 184
Need Help with Filtering a Query/Report!! by Eka1618
Hello, I am trying to filter a subReport with query for a RecordSource (qryResults). Here is the SQL for my the query: SELECT tblResults.Q_INC,...
September 4th, 2008 11:35 AM
by Eka1618 Go to last post
2 254
Auto Email from a report or query by Brendanpeek
Hello I need to find a way to have Access 2007 run a report or query at 00:01am of everyday and then to generate an email, containing all the information...
September 4th, 2008 04:26 AM
by Tony Toews [MVP] Go to last post
4 327
Check for a non exact match - eg serial number with 1 digit differ by Andrew P.[_2_]
Hi All I need to do a search for serial numbers - I need to find exact match (easy) but also check for miss types - ie find any numbers that have one or two...
(Multi-page thread 1 2)
September 4th, 2008 04:05 AM
by Andrew P.[_2_] Go to last post
12 316
Losing Records Between Union Query and Select Query by ryguy7272
Sorry if this is a simple question and just silly, but I am really missing something here. I have two union queries. The first union query is in the format...
September 4th, 2008 02:11 AM
by ryguy7272 Go to last post
3 289
how do I get the OR function working in query using ACCESS by frank
I put a name in criteria and another in OR but when i look at run query only the first name is showing
September 4th, 2008 12:39 AM
by frank Go to last post
3 198
Need help with a date on a querie, please!!! by Cesar Urquidi[_2_]
I have an "Equipment" table and an "Issue/Return" table: Equipment: l_ Device ID _l_ Device Description _l Issue/Return: l_ Issue/Return ID _l_ Device ID _l_...
September 4th, 2008 12:07 AM
by Cesar Urquidi[_2_] Go to last post
9 217
Variable in Criteria by Jack
Hello, I have a query setup with date and 7 locations, so there are 8 columns(fields). In the 7 locations(fields)there can be only one person listed. They...
September 3rd, 2008 11:49 PM
by NetworkTrade Go to last post
2 157
Query to show current employees between dates by bhx_uk
Hello, I am desperately trying to make a query that will show the current employee's of our organisation between 2 dates (One is a fixed date using the...
September 3rd, 2008 10:40 PM
by Lord Kelvan Go to last post
1 164
Date() function returns text by Brett[_2_]
I have the following make table query; however it is putting the results in Text format. How do I correct this to put the results as Number format? SELECT...
September 3rd, 2008 10:21 PM
by KARL DEWEY Go to last post
3 207
Deleting information in a query by guidop12
I have a table that is setup like this ranking Company Total Revenue 1 ABC 123,456 What I want to do is have a...
September 3rd, 2008 09:20 PM
by guidop12 Go to last post
3 146
Format of Output From A Query by carl
I posted yesterday and wnat to thank all who replied. For some reason I can't reply to the postings. If I use this query (Thank You Karl Dewey) SELECT...
September 3rd, 2008 09:16 PM
by Lord Kelvan Go to last post
2 145
Formula Help in Access by Deb
Hi, I have a database for my high school students. I have it set to add up the grades and test scores so that we can verify their credits for graduation. ...
September 3rd, 2008 09:16 PM
by Deb Go to last post
6 339
query birthdates occuring in year range by Mary
The following is my sql view of a query I have put together to return the year of a member's 100th birthday. My assignment is to generate a report for those...
September 3rd, 2008 08:22 PM
by Mary Go to last post
2 183
Multiple Offenders of Parking Violations by Josh B.[_2_]
First, I'd like say I'm sorry if this question has been answered before for a similar situation. I"m trying to create a Parking Ticket Databaste for a...
September 3rd, 2008 08:10 PM
by Josh B.[_2_] Go to last post
7 200
Multiple criteria from textbox by Jeff Hunt
I’m trying to filter a query based on a text box from a form, but I would like to be able to allow multiple options. The query that I have is as...
September 3rd, 2008 07:48 PM
by Jeff Boyce Go to last post
4 174
Simple query with criteria dependent on current form value by TravelingHT
Here is where I currently am The record source for the combo box Pets in the Form frmPetsAtVisit is a query based on my tlbPets. frmPetsAtVisit is a...
(Multi-page thread 1 2 3)
September 3rd, 2008 07:41 PM
by TravelingHT Go to last post
20 458
Post New Thread


Display Options
Showing threads 9001 to 9020 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.