Steve Collins:

Hello.  Hope you're doing great today.  Thank you for this sample SQL, but is there a way to combine this "two" SELECT statement into one?  Or can I use...

• This reply was modified 3 years, 6 months ago by  marksquall.

Jez-448386:

Hello, Hope you are doing great today.   Thanks for explaining the SQL query.  But unfortunately, this time-in time-out will be used for the log a user spent in a Web...

Jez-448386,

Hi.  Thank you for this.

I wonder where would I compute the hours logged here?  The sample output:

Name                  Today   ...

• This reply was modified 3 years, 7 months ago by  marksquall.
• This reply was modified 3 years, 7 months ago by  marksquall.

Dear Luis:

Hello. I just want to say thank you for the example. I think this will work. 😀

Have a nice day ahead and Godspeed.

Very truly Yours,

Mark Squall

Dear faulknerwilliam2,

Hello, a pleasant day to you. 🙂

David Burrows is right, I encountered the same thing and I would like to thank David Burrows for the information. Yes, if...

Hi faulknerwilliam2,

Hi. I hope/pray you are doing great upon reading this reply.

As an alternative, you may sort the data directly to your RDL. To do that,...

Dear michael.higgins:

Thank you for the tip you gave me. I tried them and its successful! :w00t:

But what if the client want some design on the email (you know...

Dear mister.magoo,

Hello to you. Thanks for the advise, I already got it. 😀

Aside from your tip, I learned something new (still on comprehending but I will get there...just...

Hello Geomorian. That was really cool. I am thinking it has be another technique, like for example, using a variable ([font="Courier New"]BIT[/font] type) to set to either 1...

Hello Sean. Thank you for the sample query, it works just fine (with some minor modifications). Awesome! 🙂

I apologize to you (and to the readers) for making my...

Dear laurie-789651 and dwain.c,

Thank you, thank you, thank you!!! 😀

Now I could export the result/s smoothly in my [font="Courier New"] MSExcel[/font] file.

I have another question "connected" with this one (but...

To J. Drew Allen, capn.hector:

Thank you. Actually it is just a sudden idea that I will just transfer the value of [font="Courier New"]person_id[/font] (in a variable) from [font="Courier New"]PERSON[/font]...

To Sean Lange:

-No wonder why [font="Courier New"]ADDRESS[/font] becomes color blue in...

To danaanderson:

I confess I am doing normalization to the death. :crying:

I know I am a beginner and I think I need to learn too about normalization as...

Dear all,

Thank you for your ideas guys, I am learning one step at a time to database stuffs.

For the meantime...I just used this table named [font="Courier New"]ADDRESS[/font], the columns are:

[font="Courier...