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 Reverse Sort Order Last Post Replies Views
Unmatched Query by
I have created an unmatched query using the wizard. However I wanted the query to check more than one field before returning the unmatched records? Any ideas?
May 26th, 2004 03:20 PM
by Allen Browne Go to last post
1 358
save filtered query to another query by
is it possible to save a filtered query to another query? thanks in advance!
August 13th, 2004 04:16 PM
by LeAnne Go to last post
1 176
Parameter query with wildcards by
Instead of using the Enter Parameter Value dialog box with the below criteria: Like "*" & & "*" I would like to use a text box on my...
August 26th, 2004 05:03 PM
by Allen Browne Go to last post
3 157
Field functionality failure after upgrading to Access 2003 by
Hi all, I have recently upgraded to Office 2003, from Office 2000, before the upgrade I had built variouse databases carrying different tasks, but since...
September 1st, 2004 10:14 PM
by Michel Walsh Go to last post
1 153
I get an error when I try to create a combo box from the wizard by
I get an error when I try to create a combo box from the wizard. I am trying to use a database template of the Address book and wanted to look up a person by...
September 1st, 2004 09:07 PM
by Ken Snell [MVP] Go to last post
3 213
most recent date by
ok I've seen tons of answers to this question but none of them really work for my purpose, or I just simply don't understand. Here's what I'm trying to do: I...
September 7th, 2004 01:55 AM
by Go to last post
2 170
comparing tables by
Does anyone know how I could find all the values in one table that are not in another? I have a table named login; the fields are ID, first_name,...
September 8th, 2004 12:44 AM
by Tonín Go to last post
1 160
Dates in seperate columns but return latest date by
I have 6 columns with Contact information and 6 date columns. (ie. Contact One, Contact One Date, etc.) How do I return the latest Contact and Date. An...
September 24th, 2004 05:26 PM
by Douglas J. Steele Go to last post
4 224
Forms by
Hi, how can I create a Form with a Datasource of two tables. Regards cucmejc
October 17th, 2004 03:48 AM
by Duane Hookom Go to last post
1 141
Like Converts to ALike in Query by
Hello, Not sure if anyone has seen this but I have a dB that will no longer perform parameter based queries using the LIKE keyword. Instead it changes it to...
August 12th, 2004 04:51 PM
by Go to last post
2 184
Select query to obtain records of different depts by
Hello, I have a select query that retrieves information from four different departments.How would i set the criteria to separate the info obtained from these...
August 12th, 2004 12:18 PM
by Michel Walsh Go to last post
1 131
Querying from 2 Records by
I need to pull information from two fields in a table into one field in another. I am trying to condense it into one step but didn't know if it was possible. ...
June 14th, 2004 01:50 PM
by Go to last post
2 149
Problem with a report by
Hello: I'm attempting to produce a report in Access. The report will have page breaks when the header info changes. The problem is that the pages will break...
June 16th, 2004 09:50 PM
by Duane Hookom Go to last post
3 285
no results returned in query by
Hi! These are my fields: event_id, LOC, GCS, and sample. Now I am writing a query to return all fields when say event_id=2 and LOC is null. So what I did...
June 21st, 2004 08:48 PM
by John Vinson Go to last post
1 148
Combine update queries into one query by
I have a schedule database that uses 9 update queries to "rotate" the schedule. The first query changes all records with a ShiftID of 8 to 9. the next query...
June 30th, 2004 11:09 AM
by rp Go to last post
4 162
Query on a date range by
I have a table called tblUnAvail with LName, FName, Start and Stop fields. Another table called tblSchedule displays Sun - Sat as text fields as well as the...
August 9th, 2004 12:15 AM
by Doug Go to last post
2 149
Finding Duplicate Records by
I have a table that contains the following information: Auto ID, PersonName, EventName, EventDate PersonName, EventName, and EventDate are not unique. There...
July 13th, 2004 03:50 AM
by John Vinson Go to last post
1 252
Oracle 1013 error by
i have read many users with this problem but no one seems to know the solution. i have linked tables to an external oracle database. when runnning a query,...
July 20th, 2004 05:09 PM
by Dan Artuso Go to last post
1 263
Tasks Not Completed by
I have a query of a table that lists all tasks for this year. I have another table that records each employee, the task completed, and the date it was...
July 26th, 2004 12:43 AM
by Graham R Seach Go to last post
3 202
Count/Frequency of text within a table by
To whom it may concern Can you tell me how I can create an access query which will look in a column and produce a count of how frequently a piece of text or a...
March 10th, 2005 04:09 PM
by JaRa Go to last post
2 143
Post New Thread


Display Options
Showing threads 1 to 20 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:34 PM.


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