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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Filter Fields in a report using a talbe field value as criteria
I have a query that brings data from a couple of tables. When I manualy enter the criteria as LIke "*0530*" it shows the records that I want in the query. However I would like the value 0530 to be taken from a field on a small table. So that when I change the value on the...- superxela
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Report in which blank fields will omit the record from the report
Hello there, I'm working on this Access 2000 database where the objetive is to give members(records) a choice of five meals per day. However some members may choose to skip a day. I don't want those members to show on the report for that day. So the filter must check for values in the fields...- superxela
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
-
Button to delete a couple of fields on a record
Hello and thanks in advance, I'm developing a database to keep track of 5 meals per day. I created a menu with 5 drop-down boxes for every day of the week. I need a button that would allow me to clear (delete) the 5 values(fields) on one day without affecting the rest of the days. The table...- superxela
- Thread
- Replies: 10
- Forum: Microsoft: Access Forms
