Search results for query: *

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

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

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.

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.

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