Recent content by NSmoller

i initially asked this in another thread, i want to make this a separate topic because i think it requires more attention, since i still cant get it to work :) HERE's the query: SELECT l.MD, l.Patient, l.SSN, l.Drug, l.LASTFILL AS [Last Fill], l.[MD Aware] AS [MD Aware?] FROM coreg AS L INNER...

thanks for your help the reason for the "like" statement is because the data we are getting from a file dump is never consistent. i have created a doctor table trying to make this consistent. it basically converts the current file dump to something close to how we view it for consistency...

SELECT l.MD, l.Patient, l.SSN, l.Drug, l.LASTFILL FROM Locallist6m AS L, blueteammds AS b WHERE l.md Like (left(b.md,4)+"*") And [md aware]=True ORDER BY l.md, l.lastfill; this is my query. when i take out blueteammds as b and expand b.md to be blueteammds.md it asks me for the value when i...

What is the difference between these? SELECT LocalList.MD, Locallist.patient, locallist.SSN, locallist.drug, locallist.Lastfill FROM Locallist, Duplicates WHERE Locallist.Patient=Duplicates.Patient ORDER BY locallist.MD, locallist.LastFill; SELECT LocalList.MD, Locallist.patient...

one more... can i save a report as a template??? how? i'm so new to this stuff

ya i figured something like that, but where does it go?

i mean make the value an asterick if it is 1 or 2. I also dont want the column name to display on my report

thank you so much works wonderfully. if i may ask another question. One of my columns has a numeric value 1, 2, or is null. Can i make these astericks?

I'm an employee of a healthsystems organization. we have a list like follows: Dr Smoller Johnson, Gary Lipitor 10 mg 2/10/05 ... Dr Smoller Smith, Tony Lipitor 20 mg 12/10/05... Dr Smoller Robinson, Wendy Lipitor 10 mg 1/3/06... Dr Stenzo Doe, Jane Lipitor 20 mg...