Search results for query: *

OK PHV, I put the options in a separate table but DCount still doesn't work. It gives me an error #Error. Thanks.

I have a report that's based on a parameter query (which returns records based on the date range in the parameter query) On this report I would like to create a textfield that shows the number of records that were returned and that meet my criteria. The criteria is a value in the combobox I...

Thank you both your help. The date format was the reason. I also reset the date format and recreated the query and it works even without using the Format in the query as you suggested. It's really strange but it works. Thanks again.

I'm trying to run a query based on this: Between Forms!frm_myForm!Date1 And Forms!frm_myForm!Date2 but can only get the results if Date1 and Date2 are the EXACT begin and end dates in the table. I tried putting in crazy dates like 1/1/1000 and 1/1/3000 and got a "No rocords found" message...

OK I got it. I created a query, Count the PK field, Group By the Fee_Type field, and Sum the Fee_Amount field.

I have hundreds of records that have one of the 3 fee types and a dollar value: Fee_TypeA Fee_TypeB Fee_TypeC On a report I'd like to display the 3 types and total sum that I have for each type. Thanks in advance.

Beautiful! Thanks a lot Royvidar!

I'm concatenating 3 fields like this: FullName: [LNAME] & " " & [MNAME] & " " & [FNAME] If the MNAME field is blank, then there are 2 blank spaces in between LNAME and FNAME. How can I get rid of this extra blank space? Thanks in advance.

Thank you both of you. I tried GingerR's suggesstion and it worked fine except when the record I want to copy has related records attached to it. In other words, if that record is in the main form and there are related records in the subform, then it doesn't work. I did a search and found out...

GingerR, your second question is what I want: "COPY a record as a new record, then move to that new record on the form so you can edit it" Any tips? Thanks in advance!!!

Thanks TheAceMan1. What I want to do is this. Say there's only 1 record in the table with 2 fields: PK and another field. The PK is AutoNum and say it's 1. I go in and change something in the other field and save it. What I want to have now is 2 records: one original before the change and one...

Please help!!! I have a Search form that I can use to go back to a specific record to make changes to that record. Once I'm done with the changes and click Save, I want to save this changed record as a new record, with new ID (AutoNumber). In other word, I want to keep the old record intact...