Recent content by camelk

My report comes from a parameter query that accesses several records. However, I want only one record per report. How do I do this without writing code? I thought there was something in the properties list.

I have a table that stores patient progress reports. The Composite key is Patient Number (PtNo) and Date of Progress Report(DatePR). I have a query that accesses the records from the table. But....I want the query to access only the most recent record for each patient number. How do I write...

I have a table that stores patient progress reports. The Composite key is Patient Number and Date of Progress Report. I have a query that accesses the records from the table. But....I want to access only the most recent record for any given patient number. How do I write a criteria that will...

AvGuy Sorry, but your suggestion is way over my head. Isn't there a simple way to get back my default toolbars and menus after removing them from the db? camelk

FancyPraire: I opened my db and right clicked on what was left of my menu and tool bar but nothing happened. Do you have any other suggestions. Thanks Camelk

When I finished by db I went to startup and took off all the toolbars. Now I need them back to so that I can continue to work on the db. How do I find/access them?

Thanks for your help. camelk

I have a problem with radio buttons showing-up correctly in a screen report. The form uses 2 radio buttons to input data into a table. (one button for M.D., the other for D.O.) The fld in the table that supports this is "Title". The data is entered into the table as 1 for M.D., and...

Laois: Thanks for the info. camelk

I have 2 strange phenomenon happening with margins and layouts on some of my forms and report. (1) I set the margins via File...Page Setup. Save the new margins and layout. Everything looks fine. Close the db, open it again and the margin settings and new layout are back to the defaut...

Terry: It's a very long query (25 flds). I'll just keep playing aroung with it. Thanks for your help. camelk

Terry, I'm still getting the #ERROR msg. Any idea why? camelk

I need help writing an 'IIF' query. The field in my table is 'Title' and the person receives a '1' if an M.D. or '2' if a D.O. When I query the table, I want 'M.D' and 'D.O.' to show-up in the query, not '1' and '2'. I wrote: Title: IIf([tblPhy]![PhyTitle]=1," M.D.",&quot...

In the header of the report, I want to put a text box that shows "year to date" (i.e., 01/01/02 thru 04/15/02). How do I do this? Thanks camelk

Thanks. I used Rod's code and it worked well. camelk