Search results

It would always be all four fields.

How do I set up a search on my form where 4 fields must match exactly to return the correct record? I must match - persons name, description, type and date. Thanks J

That worked great Thanks for your help.

Didn't work out I tried the primary key idea for all 4 fields. This is the problem I'm having. Any of those 4 field may have a null value and I need to allow each field to have duplicates. It's only a duplicate if all 4 fields match. I can identfiy the dups with a dup query and group by. I...

I forgot one thing that may be important. To determine a duplicate 4 fields must be exact matches.

:confused: I am importing a file from excel into access. The table has about 6300 records. Some records are duplicates or even triplicates. How do I write a querie to leave only 1 of of these records and rmove the duplicates. Second, I will be importing new files weekly that after I do the...

File with forms Here is the file that shows the form. Thanks

Now when you enter the parameter values 1/1/2005 and 12/31/2005 when the query is run, record ID 3 with NewDate 7/4/2005 will be returned. ^ EMP I ran the query and records 2 and were returned with dates outside 1/1/2005 and 12/31/2005. When I run it through the form it's correct. I'm sorry...

I've attached my querie. For viewing

still confused Thanks everyone NewDate: DateAdd("yyyy",[Age],[DOB]) fomula works to calculate the date. I still haven't had anything work for criteria that will allow me to run the querie and select any from and to date and rerun the dates between my parameters. I alway have no data returned...

I am tring to add a number of years to a dob. I'm doing this by adding my date+years*365.26 I get a string of numbers. I then convert the number in the next column to actual date again. I'm getting the correct date. I've tried unsuccesfully to use the dateadd function.Now I want my criteria on...