Search results

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

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

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

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

I'm working on the following SQL for a query: SELECT PERSON_NAME.Person_id, PERSON_NAME.delete, PERSON_NAME.Lastname_name_local1, PERSON_NAME.Person_name_id, PERSON_NAME.Middle_name, PERSON_NAME.Name_suffix FROM PERSON_NAME WHERE (((PERSON_NAME.person_id) In (SELECT [person_id] FROM...

I'm working on the following SQL for a query: SELECT PERSON_NAME.Person_id, PERSON_NAME.delete, PERSON_NAME.Lastname_name_local1, PERSON_NAME.Person_name_id, PERSON_NAME.Middle_name, PERSON_NAME.Name_suffix FROM PERSON_NAME WHERE (((PERSON_NAME.person_id) In (SELECT [person_id] FROM...

I'm working on the following SQL for a query: SELECT PERSON_NAME.Person_id, PERSON_NAME.delete, PERSON_NAME.Lastname_name_local1, PERSON_NAME.Person_name_id, PERSON_NAME.Middle_name, PERSON_NAME.Name_suffix FROM PERSON_NAME WHERE (((PERSON_NAME.person_id) In (SELECT [person_id] FROM...

Ok Friends here's my new problem: I have an access Table in which I have phone numbers without dashes in a particular field. I need to export this Table into a fixed width text file WITH dashes in the phone number. The problem is I when I put a input mask for dashes on the table, in design...

I'm a currently working on an access database in which i've run a series of APPEND queries to populate a NEW TABLE Ive created. What I need to do is populate the RACE field in this new table with data based on 5 different RACE fields from another table entitled PERSON. So what I have is a...