N
Noozer
I'm having problem getting my head around what should be a simple, but long
query. I don't suppose I could get some help, could I?
My tables:
Group
GroupID - autonumber
GrpDesc - text
Category
CatID - autonumber
CatDesc - text
GrpIDLink - number (link to Group.GroupID)
Issue
IssueID - autonumber
IssDesc - text
CatIDLink - number (link to Category.CatID)
Call
CallID - autonumber
IP - text
Submitted - date/time
Entry
CallIDLink - number (link to Call.CallID)
IssIDLink - number (link to Issue.IssID)
Value - Yes/No
Data - text
I would like the results of my query to be:
Submitted, IP, GrpDesc, CatDesc, IssDesc, Data
Any help is definately appreciated!
query. I don't suppose I could get some help, could I?
My tables:
Group
GroupID - autonumber
GrpDesc - text
Category
CatID - autonumber
CatDesc - text
GrpIDLink - number (link to Group.GroupID)
Issue
IssueID - autonumber
IssDesc - text
CatIDLink - number (link to Category.CatID)
Call
CallID - autonumber
IP - text
Submitted - date/time
Entry
CallIDLink - number (link to Call.CallID)
IssIDLink - number (link to Issue.IssID)
Value - Yes/No
Data - text
I would like the results of my query to be:
Submitted, IP, GrpDesc, CatDesc, IssDesc, Data
Any help is definately appreciated!