Search results

Hello I have a table with ClientIDs and their diagnosis codes. ClientID has multiple records and each record has a different dx code. ClientID DxCode 1111 F12.467 1111 F3.90 2222 F21.9 2222 F9.00 2222 F12.270 My goal is to...

Many times I've been able to add a new column to a query and pop in the info that is in a text box from a form. Start: [Forms]![Start Menu]![Text41] [Forms]![Start Menu]![Text41] is populated using a calendar button. It worked the first time I ran the query but it no longer shows. The field...

hello i have a make table that has a client id and a field called Service (derived from): Format([ServiceDate] & " " & Format(dbo_ClientProgressNoteTime!StartTime," hh:mm"),"General Date") i made a query and grouped by the Client ID and want the min of Service but my results show a numerical...

hello i have a table called other_services. it consists of clients and the dates of services after a certain date. client A may have 2 records, client B may have 12. my goal is to pull into a report all the clients and the first 5 or less services. thanks for the help

hello is there anyway i can flip my vertical labels in a report so i can read them from the bottom up instead of the top down? maybe my brain works differently than others but it just doesn't seem natural to me. :D thanks!

I want to use an & in the caption of a button on my form but it turns into an underscore. I tried enclosing it in quotes but that doesn't work. is that even possible?

Hello My named is Ginger and work for a non-profit agency in RI for the last 20+ years. IT has certainly evolved for us since I started! Looking forward to getting some answers that Google can't answer.