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.
I also need to replace the account manager field id number with the account manage field name in the account manager table.
I need to do the same with the client id and client field in the following table.
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
[Solved] SQL commands
-
- Posts: 22
- Joined: Tue Mar 21, 2017 5:22 pm
[Solved] SQL commands
Last edited by Hagar Delest on Mon Mar 27, 2017 8:27 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Chris Petersen
Open Office 4.1.3
Open Office 4.1.3
-
- Posts: 22
- Joined: Tue Mar 21, 2017 5:22 pm
Re: SQl commands
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?
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?
Chris Petersen
Open Office 4.1.3
Open Office 4.1.3
Re: SQl commands
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: SQl commands
Ididitagain
"power filtering" from...until dates
"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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 22
- Joined: Tue Mar 21, 2017 5:22 pm