Searching for multiple records using the find function or a query?

[Adam7]

Hi all,

I have a list of approx 100 emails on an excel spreadsheet. All of these emails are already on the database but they all need to have "11/07/2012" added to a date field.

If there was just a few I would obviously just use CTRL and F and do them one at a time, but with there being 100 of them, I was hoping someone would know a quicker way?



Thanks,

Adam.

[R_Badger]

I would run an update query (read about it here)

Here is an example of the SQL

UPDATE [Table_name] SET [Date_field_name]=#date#;

I purposefully left out the where clause as you said you wanted that added to all records (i nearly only ever use this in conjunction with a where clause)

[Adam7]

Thanks for your reply,

but to be honest, SQL just makes my mind go blank

Would the same thing be copy and pasting all of the email addresses into the criteria of the query?

Thanks,

Adam.

[help_me_with_access]

ummm....Adam, the autofill handle in Excel is your blessing in this case. type 2 dates in 2 cells, drag the handle to the 100th row.

that's all you need to do, bud. and then obviously, data copies right over into access. there are only few cases where the data type change automatically because of access standards that are specified for table creation.

[Adam7]

ummm....Adam, the autofill handle in Excel is your blessing in this case. type 2 dates in 2 cells, drag the handle to the 100th row.

that's all you need to do, bud. and then obviously, data copies right over into access. there are only few cases where the data type change automatically because of access standards that are specified for table creation.

Hmmm I'm not sure if you have understood what I'm asking. The database has over 1million records and I need to pull up 100 of them. They have nothing unique about them so the only way to bring them up is to "find" the email address.

I could obviously drag a load of dates on excel and then copy them over, but 1st I need to find the specific records.
Ideally when you hit "CTRL + F" I would be able to enter multiple email addresses instead of just one, but I can't, so need an alternative

Thanks,

Adam.

[uncletreetrunk]

Run a query and in the date field put: #11/07/2012#

should return all results with the matching date!

[Adam7]

Nooo, they don't already have that date, it needs to be added, and they have nothing unique about them to query.

I don't think I've asked this right :P

I have an idea, which I'll try anyway.

Thanks,

Adam.

[uncletreetrunk]

Ohhh gotcha sorry misunderstood the question! Naw I think you asked it right we just all read date and posted a bunch of date related things haha

Hmm.. that's interesting I don't know how you would get results from a query if they're not unique. The only thing I can think of is adding filter(s) to your fields to your table, at least that will narrow down your results :/

[Adam7]

Haha, I appreciate the effort anyway!

I ended up just doing it the long way round, 1 at a time. Only took 30 mins so not as bad as I thought

Thanks for trying everyone! :P

Adam.