Wrong data shows in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I do a query, the EventID number shows up, instead of the Eventname in the Event name column. (the query included ; EventID, Event name, First name, Last Name, Email address
The Firstname, Lastname, emailaddress are in one table, the eventID and eventname are in another
why? and how do I correct it.
 
Surround any name that has spaces in it, in square brackets:
EventID, [Event name], [First name], [Last Name], [Email address]

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

drenfro said:
When I do a query, the EventID number shows up, instead of the Eventname
Click to expand...
in the Event name column. (the query included ; EventID, Event name, First
name, Last Name, Email address.
 
When I do a query, the EventID number shows up, instead of the Eventname in the Event name column. (the query included ; EventID, Event name, First name, Last Name, Email address.
The Firstname, Lastname, emailaddress are in one table, the eventID and eventname are in another)
why? and how do I correct it.
Click to expand...

Create a Query joining the two tables by EventID and base your report
or form on the Query.

I think you may have been victimized by the "Lookup" misfeature. Your
table may *appear* to contain the event name but it's really the ID;
the lookup wizard just conceals that basic fact from view for you.
 
Back
Top