Recent content by ginger

The first why is because the person requesting the information wants it that way according to their specs. I will actually be sending it to them as an Excel spreadsheet. The 2nd row for clientid 1111, diag2 should have been listed as F3.90. A cut and paste error.

Will do. Thanks!

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...

Thanks Brian Self taught Access user with still alot to learn :D

so i got this as an explaination. both fields are date/time. because i used "+", the "1" of 1/1/1900 3:55:00 AM was consider a 24 hr period and added 2 days to the service date.

just an fyi CJ's suggestion worked great till I realized all my services dates increased by 2 days. the date field displays as 2/12/2013 while the time shows as 1/1/1900 3:55:00 AM. so i took Brian's fix and it works thanks again

that, sir, worked perfectly! thanks to all

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...

other_services ClientKey,PN_ID,ServiceDate,StartTime 231355,910948,8/26/2013,10:15:00 AM 231355,904073,8/21/2013,1:30:00 AM 231355,910962,8/28/2013,11:00:00 AM 231355,909763,8/23/2013,4:10:00 PM 231355,904741,8/21/2013,9:50:00 AM 212074,910916,8/28/2013,11:45:00 AM...

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

Stop or I'll shoot does it have to be a name?

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!

and i'll be sure to tell the boss as he didn't know either. :)

oh you are too smart! that worked! Thanks!!