Centralized data front end.accdb Change Request: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 4: | Line 4: | ||
== Other change requests == | == Other change requests == | ||
* I have replaced the med_from query with one called “link_suspect_from_partner_no_match”; now that we are using var1/2 elsewhere it only makes sense. I still need to make the counterpart *to query. This query finds pts where the second record says they should be from a partner site and there is no partner. I also need to make queries for prev encounter comes from a partner site and Var is not marked. | |||
* need to make one where early and late have short transit times but locations don’t correspond. | |||
* add a L_Dxs _ w_ primary _ and _ pathogens | |||
* St B 5B vs B5 in var1/2 | * St B 5B vs B5 in var1/2 | ||
** not sure what this means, will confirm with Trish; query ''1tmp_var12_b5_5b'' | ** not sure what this means, will confirm with Trish; query ''1tmp_var12_b5_5b'' | ||