RE: [MS_AccessPros] text field - eliminating a bunch of fields in the query

Patty,

When you state "a bunch of types of visits that I do not need to show" it means you need some way to store this in data. IMO, maintaining a complex query is a bad idea particularly when you are creating expression on a descriptive field like this. I would either add a column to the reason table that identifies which records to exclude or create a new table that provides the functionality. 

WHEN your "bunch" changes, you simply edit data, not an expression in a query. Assume you will be modifying the reasons and save yourself a future headache.

Duane Hookom, MVP
MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: MS_Access_Professionals@yahoogroups.com
> Date: Tue, 10 Feb 2015 09:39:12 -0800
> Subject: [MS_AccessPros] text field - eliminating a bunch of fields in
> the query
>
>
>
> I have the beginning of a query that shows all the encounters done for
> a time period and the reason for the encounter. The reasons can be
> from a drop down list (when selected in the medical record) or they can
> type in a reason for the visit.
> I would like to exclude a number of the visits based on a bunch of
> types of visits that I do not need to show. Most of them are vaccine
> related visits. It is a text field. I have tried the Not like option
> and added a number fo them but I am thinking there must be a better way
> to do this. Here is an example of a bunch of the fields that I want to
> exclude:
> Need for pneumococcal vaccine
> Need for prophylactic vaccination and inoculation
> Need for meningococcal vaccination
> Need for immunization follow-up
> Need for HPV vaccine
> Need for diphtheria-tetanus-pertussis (Tdap) vacci
> Need for DTaP vaccination
> Need for hepatitis B vaccination
> Need for HPV vaccination
> Need for MMR vaccine
> NEED FOR PROPHYLACTIC VACCINATION WITH COMBINED DI
> Influenza Vaccine
>
>
> I have tried the Not like "*Need for*" but it still returns the field,
> I am sure I have it wrong. Did search on web for ideas but can't locate
> a good way to do it
> Thank you
> Patty
>
>
>
>


------------------------------------

------------------------------------


------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/