A 2010 like date query

[Dick7Access]

I hope they've got some good seafood for you

ps. Give my wife some votes, please.

 

[John Big Booty]

...

... Do you get the impression I travel to eat.

Why not it's a great way to go

 

[Dick7Access]

Just finished some terrific Baby Back Ribs, and committed the sin of gluttony.

BTW what do Kangaroos ribs taste like?

 

[John Big Booty]

We don't usually eat kangaroo ribs, the fillet is good on the BBQ but needs to bee done rare or it gets a bit tough and dry. It's is quiet a lean meat. The tail is also supposed to be good in a soup, but I've never had that.

 

[Dick7Access]

I was jesting, I didn't think you ate roo at all.

 

[John Big Booty]

As you can see the bearers of the Australian coat of arms are a Kangaroo and an Emu. Some pubs serve a dish called "The Coat of arms" which features Kangaroo and Emu meat So we have no problems eating our national emblems I guess the equivalent for you guys would be a dish of Bald Eagle

 

[Dick7Access]

Next step of my project: My client asked if it would be possible to have all students that had not returned lessons in 9 months go to a separate file. If it is, someone please point me in the right direction of a tutorial.

BTW Big John, I have the date report working perfect. I finished it at 1:00 am last night. Only after going to Olive Garden for veal Parmesan, of course.

 

[John Big Booty]

Good Work

 

[John Big Booty]

Rather than moving students to a separate file, why not simply flag them as being delinquent?

 

[Dick7Access]

Rather than moving students to a separate file, why not simply flag them as being delinquent?

That is what he asked me to do with thoes that were 90 days over due and I even gave him them in red. He ask, for a separate folder for 6 months and I am asking? I have been googling archivng and so far all I have found is arching one table or selected ecords from one table. That won't due me much good as my main table has name and address and the lessons are in a lessons table. I am sure my query can do a joint but just haven't put it together yet. I may just tell my client it is over my head. After all @ $0.00 charge per hour that I get I can be selective with what I want to program,.

 

[John Big Booty]

If the students are simply flagged they can be filtered out when the user doesn't want/need to see them.

 

[Dick7Access]

If the students are simply flagged they can be filtered out when the user doesn't want/need to see them.

I will give that some thought????