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 Function
Thank you, I will let you know how it works. Patti- oliver10
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Search Function
Hi, Please give me a better example I will definitely appreciate it. Thank you. Oliver10- oliver10
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Search Function
I have a table with patient names, Medical record#'s etc. I have created a search form that opens blank (because no patient names are allowed to show upon opening the form) but I would like to allow the user to just type the patient name or medical record# into one of these blank spaces and...- oliver10
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
Calculations in a report that have a zero
I have created a report for our radiology department which requires the repeated exams to be divided by the exposures. ie: =sum([repeats])/([exposures]) but if there is a zero in both columns that are divided - how can I make it return a zero instead of giving a #Num! appearing on the...- oliver10
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Adding a combo box
The director of our IS department has given me an existing database that someone made but no longer works here. What he wants is to add zip codes to the existing state_lkup table- when the user selects a state the second action will place the zipcode corresponding to this state to appear in the...- oliver10
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
