Recent content by TheSpecialist

I want to know how can I turn a row into a column. I want my data to display in a horizontal way. Let me show you an example Yourdate-------YourNumber------ Cash4Table ------YourTable----GaFiveTable 5/16/2016 312 Cash4Table Currently, this is my SQL statement below...

Hi I want my sql database to operate like this below. I just want to use MoonPhase Number. The table below works I just want to use Moonphase Number when the box pops open PARAMETERS [Enter Date:] DateTime; SELECT "YourTable" AS SourceTable, YourDate, YourNumber FROM YourTable WHERE YourDate...

Hi I need some help She wants me to figure out how to translate the above grid into rows in your table that will convert scope and severity values into letters values. Please see attachment Thank you Erika

Help me add another table to this This is what I have on my sql now. I want to to add my MoonPhaseTable to this how do I do it what would be my sql PARAMETERS [Enter Number:] Text ( 255 ); SELECT T1.YourNumber AS [Operative Number], T1.YourDate AS [Operative Date], T2.YourNumber AS [Related...

Hey I still getting an error

This is the error I keep getting In operator without() in query expression 'T1. YourDate IN SELECT YourDate FROM YourTable AS T2 WHERE T2. YourNumber=[Enter Number]

SELECT T1.YourNumber, T1.YourDate, MoonPhaseTable.YourNumber AS MoonPhaseNumber FROM YourTable AS T1 INNER JOIN MoonPhaseTable ON T1.YourDate = MoonPhaseTable.YourDate WHERE T1.YourDate IN SELECT YourDate FROM YourTable AS T2 WHERE T2.YourNumber = [Enter Number] UNION ALL...