Recent content by dickjo5

Works like a charm. Many thanks. :)

Thanks for the prompt reply Rich. Will I have to create the form all over, or is there some way I can copy and relate the one I have to the new query?

I am definitely a newbie when it comes to Access, but I do have a small data base with a couple of tables and one form. The form contains all the fields in the primary table, which I can sort by using two fields (lname, fname). I can sort information in the Form on only one field...

Many thanks, Marc. Works like a charm. This forum is absolutely awsome in helping a newbie like me. Dick J

See what I mean? The email tirms the spaces I intentionally left in my message. The first JONES, David J. should have left spaces between JONES and David J. My report looks like this (where periods are equated to spaces): JONES, .............David J. I want it to show JONES, David J.

I maintain a database of golfers and I would like to output a membership roster. When setting up the format in the design view, I line the fields on the grid as closely as possible, but I still get a lot of space between, say, last name, first name. I.e., The output is JONES, David J...

Thanks for all the help but, unfortunately, I don't have the solution yet. I even changed the field name to "AmountPaid" instead of "Amount Paid" but no joy. Again, thanks for the help, but I think I'll let it rest for awhile. Regards, Dick J

I tried creating a text box in the report footer and entering =sum(amount paid), but in the layout form the sum doesn't show up. I get the text =sum(amount paid). I'm going astray somewhere, but can't figure it out. Thanks for any help.

I have a report that list individuals, amount paid, date paid, etc. I would like to sum the column amount paid. In getting a Count, I created a text box in the footer section of the report and entered =Count(*). That works fine, but when I creat a text box and enter =sum(amount Paid), I get...