By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

Help with union of 2 tables

P: n/a
Hy,

I have 2 tables whith some fields distincts.

1 Table: Clients
Fields: Name, Adress, Fone, E-mail, Stats (this is a binary field -
yes/no).

2 Table: Events
Fields: Event, Date, Hour, Cost.

I need to create some 'function', that for each event than I add in
table Events, I generate a report with each registry of Clients that
field Stats is equal 'yes' print with this event than I add. If stats
is no it not show.

Example

------------------Report Example - Start-------------------
Name: Mauro Baraldi
Adress: Paulista Avenue | Fone: +55 11 0000-1111
email: my******@my.provider.com | Stats: Yes
Event: Movie (MI2) | Date: 01/02/04 | Hour: 18:00 h
Coast: U$$ 5,00
------------------Report Example - End---------------------

Can somebody help-me PLEASE !!

Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ma***********@bol.com.br (Mauro Baraldi) wrote in message news:<da**************************@posting.google. com>...
Hy,

I have 2 tables whith some fields distincts.

1 Table: Clients
Fields: Name, Adress, Fone, E-mail, Stats (this is a binary field -
yes/no).

2 Table: Events
Fields: Event, Date, Hour, Cost.

I need to create some 'function', that for each event than I add in
table Events, I generate a report with each registry of Clients that
field Stats is equal 'yes' print with this event than I add. If stats
is no it not show.

Your example is a simple report - but you need to be able to somehow
join the Client to the Event. Can each client sign up for more than
one event? Then it looks like you need a join table. (ClientID,
EventID) and then you join something like this

Clients-----ClientEvents-----Events

Then you can specify a WHERE clause in the Open Report event which
will fiter for Stats=yes.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.