Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: CheckHound
- Order by date
-
Form Expression showing Primary Key numbers
I am using a Report to make generate a letter. The fields I am trying to display are all generate from lookup fields. If I add each control individually they display correctly. If I try to have them display as one line by using an expression it displays the number of the primary key for the data...- CheckHound
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
-
Stupid Question - Showing Open or Closed.
I just figured it out. Since it is coming from a lookup field I had to enter the number of the primary key for Open or Closed to get what I wanted.- CheckHound
- Post #4
- Forum: Microsoft: Access Forms
-
Stupid Question - Showing Open or Closed.
Thanks for your reply. I did that and when I try to view the query is says "Data type mismatch in criteria expression" I have tried several different expressions with similar results. I almost think I am trying too hard...- CheckHound
- Post #3
- Forum: Microsoft: Access Forms
-
Stupid Question - Showing Open or Closed.
I am using Access 2002 and I have a table with a field name title "Account status" the field is a look up with the two choices being "Open" or "closed". My stupid question is this: How do I get a form to only show the entries that are "Open". I have tried...- CheckHound
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
