Search results

It's counting the records that have 3 letters in it. What i'm trying to accomplish is finding records where there are 2 indentical dob's and between let's say record 1 and 2, the first 3 letters match therefore leaving me with something like: smith, james 09/09/09 smithzed, james 09/09/09...

or a delete query?

Ok here is my code below. Now this code is basically grouping DOB together that has a count greater than one, which allows me to evaluate the other information and determine whether or not I need to keep it. What I want to add to the below SQL code is something that says if the first 3 letters...

maybe I can get this done by somehow writing a query that says selects info where record 1 and record 2 have the same dob and the first 3 letters of last name match for both records. how would I do that? you think an if statement would work?

I have a table with peoples information in it. It contains their DOB, and their full name (lastname, firstname). What I need as a final result is a table where record 1 and record 2 have the same DOB and similiar full names (maybe the last name is different but the first name is the same). In...

Yes, this is correct. Of course before I run it I'd look at the results. But essentially I want to get rid of records meeting this criteria

Greetings all: So I have a project which requires the help of you wonderful people. What I'm am trying to accomplish is this: I have a query with information on Date of Birth and Full Name (format lastname, firstname). I have the wonderful task of going through this query and deleting...

I put the format in the FIELD position as expr1: format([dob],"mm/dd/yyyy") the problem is im not the DBA. i'm just a pawn in a governmental chess game. the powers that be want a tab delimited text file. When you export from query you get hash marks and | marks. These people don't want to...

What i'm trying to accomplish a text file that is formatted just perfectly for an import into a SQL server database. The software we are running on this server is fickle to say the least. So my date fields have to be mm/dd/yyyy without the time stamp. Now when I export the query straight to a...

What does that look like? I have an append query that makes my final table. What do I do to get rid of the time stamp?

I am trying to format a date field without having the attached time stamp. In access it doesn't show the time stamp, but when I export a table to a TEXT FILE, the time stamp is there. I've used DATE(), and it attaches a 00:00 at the end. Any advice on how to get the desired result? Thank you...

Ok let me explain more of what i'm trying to accomplish. This database I have is not for users to input data. What I have is a table of data(pre existing). I have a serious of queries that update and switch and replace and alter the data in this table to a specific format to which I need it...

Hello: So ive read quite a bit of forums that talk about how you can use DMAX to increment instead of using autonumber. Simple Question: where do you put the dmax function in your design view of the table? I have a desire to create my own autonumber that increments from 1 all the way to...

This is the actual code I’m trying to write UPDATE [Facility Code EHaRS] INNER JOIN GriffTest ON [Facility Code EHaRS].phone = GriffTest.FACILITY_PHONE SET [Facility Code EHaRS].facility_uid = GRIFFTEST.FACILITY_UID WHERE ((([FACILITY CODE EHARS.PHONE])=[FACILITY_PHONE])); This was two dummy...

Ok I did an update query like you said, and it didn't seem to work. the data ended up erasing completely from the original field. should there be a criteria on the update query?

Hello all: So what I would like to do is this: if table1.phone is equal to table2.phone then populate table1 field1 with data from table2.indentification# What is the best way to go about doing this? is the if statement the best thing? Thanks for your help

Indeed you are both right! I spoke to soon, plus I left out the brackets with the field names. perfect. Thank you a great deal guys I appreciate you tremendously. I might be back, as this project is a doozie and I need to be aware of all the functions. Thanks again guys, I'll pay the kindness...

thank you guys for your help. I tried what you suggested, and what happens is it replaces the entire string. I'm trying to simply replace the one character in the string I don't want. so for example sake, if my field ACCESSION_NO has a value 12345\6, I want to replace the the backslash so it...

Ok so I tried that in an update query and it's not returning any values whatsoever. What should be my criteria. Mind you I just want to find a back slash with the value of the field. example: the accession_no has a value of 383838\9. I want to find the back slash in that field and remove it

I have a database i'm creating which makes a process at my job simpler that it currently is. Long story short, I need to right a function that allows me to look in a Field named accession_no. This field should be all numbers, but sometimes it has back slashes. How can I write a query that...