[Solved] SQL commands

Discuss the database features

[Solved] SQL commands

Postby chris_petersen » Thu Mar 23, 2017 4:33 pm

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

Postby chris_petersen » Thu Mar 23, 2017 4:42 pm

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 1454 times


Query_Results.JPG


SQL.JPG
Chris Petersen
Open Office 4.1.3
chris_petersen
 
Posts: 22
Joined: Tue Mar 21, 2017 5:22 pm

Re: SQl commands

Postby Villeroy » Thu Mar 23, 2017 10:11 pm

Next step:
Create a filter table and a form.
https://forum.openoffice.org/en/forum/d ... p?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, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26407
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: SQl commands

Postby Villeroy » Thu Mar 23, 2017 11:56 pm

Ididitagain
"power filtering" from...until dates
Attachments
DateFilter.odb
(40.42 KiB) Downloaded 94 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26407
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

[solved]

Postby chris_petersen » Mon Mar 27, 2017 3:26 pm

Thanks
Chris Petersen
Open Office 4.1.3
chris_petersen
 
Posts: 22
Joined: Tue Mar 21, 2017 5:22 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 3 guests