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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

special query/filter



 
 
Thread Tools Display Modes
  #1  
Old June 14th, 2005, 06:08 PM
jon via AccessMonster.com
external usenet poster
 
Posts: n/a
Default special query/filter

I have a db group by user ID numbers. In this db I have two fields.
transaction and fund. A user can have more then one transaction what i want
to do is ONLY display if the user put money into the fund AND took out money.

for example
-----------

trans fund
f a
f a
t b
t b
t c
t c


so here the user is not putting in and taking out from the same fund. so none
get displayed but if i added

f c

i would want to display all transactions dealing wit that fund.

if anyone could help i would really appreciate it, i really dont have a clue


thanks
-Jon
 




Thread Tools
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Special Ansi Character on report: Section Symbol RNUSZ@OKDPS Setting Up & Running Reports 4 March 29th, 2005 03:53 PM
[Question]: Store special folders on IMAP Server Pleo General Discussion 3 February 5th, 2005 01:36 AM
Paste Special - Picture format problem Riain Powerpoint 2 August 26th, 2004 06:39 PM
Paste Special Dave Peterson Setting up and Configuration 0 May 21st, 2004 02:42 AM
How to prevent auto-conversion to date in clipboard paste special? Pekka Siiskonen Worksheet Functions 3 December 22nd, 2003 02:08 PM


All times are GMT +1. The time now is 11:32 AM.


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