473,387 Members | 1,702 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Restrict Records in a Query

eclypz
10
I have this query qryOriginal that has this camps.
qryOriginal
Expand|Select|Wrap|Line Numbers
  1. IDNumb;
  2. Phone;
  3. CallerPhone;
  4. DateContactIN;
  5. DateContactOut;
  6. Service;
  7. answer
what I need is to delete from this table all duplicates registers for the same CallerPhone and only stay in table the last contact from that CallerPhone. The Date of contact is register ind DateContacIN.

Then i need to implement another query to fill the camp answer with data that i have in another table for each callerphone.

How can i implement this?
Nov 14 '07 #1
2 1776
NeoPa
32,556 Expert Mod 16PB
Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for New Threads!). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

ADMIN.
Nov 15 '07 #2
NeoPa
32,556 Expert Mod 16PB
I've edited your post a little to try to make it a little clearer. I think I've left it meaning the same but you may want to reread it to make sure it still makes as much sense as before.

I also changed the title for you. This will hopefully attract more experts to help if necessary.

I'm afraid I couldn't make sense of everything you were trying to say (although I have a fair gist of the question), but if you're happy with your post then perhaps we could move on to your posting the SQL of qryOriginal for me. I'm afraid I couldn't make any guess as to where the camp item fitted in. This might help me to get what I couldn't understand from your post and we can move forward.
Nov 15 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: Alex L Pavluck | last post by:
Hello. I have my data setup as follows: Main MEMNAME NAME TYPE LABEL Variable MEMNAME VARNAME NUMBER Format MEMNAME FMTVALUE NUMBER
5
by: toddles666 | last post by:
Hi- Is there any way of restricting access to a database by application & account? For example, I only want the application APP1 to access the database using the USER1 account. I've tried to...
2
by: pemo | last post by:
In Harbison and Steele's book, they say that using 'restrict' allows functions like memcpy() to be prototyped like this: void * memcpy(void * restrict s1, const void * restrict s2, size_t n); ...
6
by: tlyczko | last post by:
I am working on an audits database. The main table, Audits, has an AuditID primary key. Another table, 1:1 relationship, ProgramAudits, has AuditID as a foreign key. I have a master/main form...
2
by: Vinda | last post by:
I have recently upgraded to Access 2002 and when I run the macro -> run command -> spelling on a form it checks all records rather than just the current record. When you have over 30,000 records...
5
by: Dakrat | last post by:
Allow me to preface this post by saying that this is my first database project, and while I have learned a lot, any concepts I have learned are hit and miss as I have found new requirements and...
1
by: Arnold | last post by:
Greetings, I have a form, frmProgressReports, with qryProgressReports as the recordsource. A field in the query is named 'Select" and is yes/no, with criteria set to true. This filters the form...
3
by: geebanga88 | last post by:
HI i want to create a month query that restricts the records by a month given that is inputed by a user from a form. There is an attribute in the relation called date which should only match the...
3
by: kmnotes04 | last post by:
Could anyone tell me how to restrict the date range for items that appear on a report? Old items from previous years appear on the report. I was asked to have only this year's items (and beyond)...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.