[Solved] SQL commands

Discuss the database features
Post Reply
chris_petersen
Posts: 22
Joined: Tue Mar 21, 2017 5:22 pm

[Solved] SQL commands

Post by chris_petersen »

Okay, I have the first table called creative test and I need to pull records that are between a date range so that I can print that range.
I don't want the id number for the Client and Account manager in the following chart. I want to inset the names from the two tables below.
TBL_Creative_Test.JPG
I also need to replace the account manager field id number with the account manage field name in the account manager table.
TBL_Account_Manager.JPG
I need to do the same with the client id and client field in the following table.
TBL_Client.JPG
When I sort the table by name it seems to give me the entire range of dates anyway instead of the range between my input dates.
That code will be in the next post. I hit the upload limit for this one.

Thanks.

Chris
Last edited by Hagar Delest on Mon Mar 27, 2017 8:27 pm, edited 1 time in total.
Reason: tagged [Solved].
Chris Petersen
Open Office 4.1.3
chris_petersen
Posts: 22
Joined: Tue Mar 21, 2017 5:22 pm

Re: SQl commands

Post by chris_petersen »

This is what I get when I run the query. I enter the date for start: 01/01/2017 - End: 03/27/2017
I end up with the results in the bottom chart. Also, why are my prompts reversed during the query versus how I have them set up in SQL?
Query_Input.JPG
Query_Input.JPG (20.19 KiB) Viewed 2928 times
Query_Results.JPG
SQL.JPG
Chris Petersen
Open Office 4.1.3
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: SQl commands

Post by Villeroy »

Next step:
Create a filter table and a form.
download/file.php?id=21951 (form "Filter Data")
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: SQl commands

Post by Villeroy »

Ididitagain
"power filtering" from...until dates
Attachments
DateFilter.odb
(40.42 KiB) Downloaded 267 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
chris_petersen
Posts: 22
Joined: Tue Mar 21, 2017 5:22 pm

[solved]

Post by chris_petersen »

Thanks
Chris Petersen
Open Office 4.1.3
Post Reply