473,320 Members | 1,828 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,320 software developers and data experts.

Date Dependant delete ???

I have a family data base used by a homeless shelter.. the average stay is
30 days....unless depends on a list of factors... or they could be kicked
out for ....example Drugs.
When I must clear that room , I have dependarnt tables Ie..Cleint
....Spouse.. Children and must post to post to history... table.. or they
may be 86ed for cause. in which case they need to posted to an 86ed table to
be used to scan during intake process to insure a family is not admitted
with prior bad history...

What is the best to do this?????????

tks in advance
cliff
Nov 2 '07 #1
1 1094

"Cliff Chapin" <cc******@cox.netwrote in message
news:0G*************@newsfe10.phx...
>I have a family data base used by a homeless shelter.. the average stay is
30 days....unless depends on a list of factors... or they could be kicked
out for ....example Drugs.
When I must clear that room , I have dependarnt tables Ie..Cleint
...Spouse.. Children and must post to post to history... table.. or they
may be 86ed for cause. in which case they need to posted to an 86ed table
to be used to scan during intake process to insure a family is not
admitted with prior bad history...
It is (more than just) possible that it would help someone to help you if
you were specific and detailed about the information you are keeping and how
you have it arranged into tables. Otherwise, we'd only be guessing at what
you have, and not able to suggest how to handle something specific. Please
clarify, and perhaps someone can offer useful suggestions.

Larry Linson
Microsoft Access MVP
Nov 2 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Jerome | last post by:
Hi, I know this is an old problem and I've already tried to look the solution up on the web but I didn't find what I need. So, there's the following situation: I've got an ASP page with a...
1
by: Suvig | last post by:
The XML I have has the NEWS-PRESSDATE attribute. But, the date is in number format (in milli-seconds):   <NEWS-PRESSDATE>1080018000000</NEWS-PRESSDATE> Q: How do I convert this to for format I...
9
by: Thomas R. Hummel | last post by:
Hello, I am importing data that lists rates for particular coverages for a particular period of time. Unfortunately, the data source isn't very clean. I've come up with some rules that I think...
6
by: bryan.seaton | last post by:
I have a delete statement that is not doing what I want it to do: Delete from LOG_TABLE where (DATE(LOG_TS)) < (DATE(CURRENT_DATE)- 21 DAYS); It is supposed to delete all records that are 21...
5
by: m_t_hill | last post by:
Running MS Access 2000 MS Windows XP Pro This has caused me a lot of hair loss in the last few days so would appreciate any help. I am running code to append/update a local access database...
4
by: Bruno | last post by:
How do I check if a date variable is empty? I mean, if I declare a variable like this dim d as Date how do I know if any date was assigned to d? example, d = now
15
by: edouard.spooner | last post by:
Hi, I have a tricky SQL query problem that I'm having probs with. I have a table which resembles something like this Date | Price1 | Price2 | Price3 01 Jan 2006 | 100 | 100 | 100 02 Jan...
4
by: mcca0081 | last post by:
hi - i'm trying to delete one of the duplicate records based on the most current date. here's the code for my access 2000 db. any help would be appreciated!!! - thank you kindly Sub...
7
helpwithcode
by: helpwithcode | last post by:
Hi people, I am just learning java.I have been creating a project which involves JDBC Connectivity.I find that the statements, String string_dob=text_dob.getText(); //Converting string to...
3
by: Ed | last post by:
Hi, guys, I add some new projects. No source file, but only some copy operation in Post Event. The project is to do some file deployment for some third party library. When I compile the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.