Re: Showing fields from Primary Keys
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 13:12:39 -0500
If you create a query that includes the Staff table you can query by
faculty.
--
Duane Hookom
MS Access MVP
--
"Danbwest" <Danbwest@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:67066CEE-9543-4BB7-93B8-84B73DF35BBE@xxxxxxxxxxxxxxxx
> Hi,
> I am currently making a report booting from a query. The query contains 4
> fields
> Pink Slip ID; Student ID; Staff ID; Date and time
>
> Wot i need to be able to do, is to do a search by faculty...So i can see
> how
> many pink slips have been issued by that Faculty in the school.
>
> The faculty field, is in the Staff table, With Staff ID as the primary
> key.
> Is there any way Where i can search by the Faculty-Via the Staff ID?!
>
> Thanks
.
- References:
- Showing fields from Primary Keys
- From: Danbwest
- Showing fields from Primary Keys
- Prev by Date: Re: Add text to Date Time field
- Next by Date: Access 2000 Popup Report?
- Previous by thread: Showing fields from Primary Keys
- Next by thread: Correlation of Variation
- Index(es):
Relevant Pages
|
