Click here to Skip to main content
14,327,592 members
   

Database

 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:20
professionalGuyThiebaut4-Apr-19 21:20 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:43
professionalGuyThiebaut4-Apr-19 21:43 
AnswerRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 20:56
professionalGuyThiebaut4-Apr-19 20:56 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon4-Apr-19 20:58
memberBrunoPigeon4-Apr-19 20:58 
GeneralRe: HELP WITH SQL QUERY Pin
Mycroft Holmes4-Apr-19 21:16
memberMycroft Holmes4-Apr-19 21:16 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:24
professionalGuyThiebaut4-Apr-19 21:24 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 0:13
memberBrunoPigeon5-Apr-19 0:13 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut4-Apr-19 21:17
professionalGuyThiebaut4-Apr-19 21:17 
Have a look at my other comment where I explain what is going on.
I'd also suggest that you get into the habit of formatting your SQL so that is is easier to read.
Here's an example of a possible way of formatting your SQL:

Select 
    distinct format(SupplierInvoices.Date, 'dd-MMM-yyyy') as tDate, 
    Sum(SupplierInvoices.QTY) as lTotal 
from SupplierInvoices 
where PLU = '" & lblPLU.Caption & "' 
    and Date Between #" & StartTime & "# and #" & EndTime & "# 
Group by format(SupplierInvoices.Date, 'dd-MMM-yyyy') 
Union 
Select 
    distinct format(Sales.Date, 'dd-MMM-yyyy') as tDate, 
    Sum(Sales.QTY) as sTotal 
from Sales 
where PLU = '" & lblPLU.Caption & "' 
    and Date Between #" & StartTime & "# and #" & EndTime & "# 
Group by format(Sales.Date, 'dd-MMM-yyyy')

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 0:11
memberBrunoPigeon5-Apr-19 0:11 
GeneralRe: HELP WITH SQL QUERY Pin
GuyThiebaut5-Apr-19 2:48
professionalGuyThiebaut5-Apr-19 2:48 
GeneralRe: HELP WITH SQL QUERY Pin
BrunoPigeon5-Apr-19 4:22
memberBrunoPigeon5-Apr-19 4:22 
QuestionIn Access: group of records and assign conditional group ? Pin
Member 245846726-Mar-19 22:18
memberMember 245846726-Mar-19 22:18 
AnswerRe: In Access: group of records and assign conditional group ? Pin
Victor Nijegorodov27-Mar-19 11:50
memberVictor Nijegorodov27-Mar-19 11:50 
GeneralRe: In Access: group of records and assign conditional group ? Pin
Member 24584677-Apr-19 16:20
memberMember 24584677-Apr-19 16:20 
GeneralRe: In Access: group of records and assign conditional group ? Pin
Member 24584677-Apr-19 16:24
memberMember 24584677-Apr-19 16:24 
AnswerRe: In Access: group of records and assign conditional group ? Pin
Chris Quinn28-Mar-19 1:55
memberChris Quinn28-Mar-19 1:55 
QuestionSQL Remote Connections Pin
Kevin Marois18-Mar-19 8:00
professionalKevin Marois18-Mar-19 8:00 
AnswerRe: SQL Remote Connections Pin
Richard Deeming18-Mar-19 9:35
mveRichard Deeming18-Mar-19 9:35 
GeneralRe: SQL Remote Connections Pin
Kevin Marois18-Mar-19 10:02
professionalKevin Marois18-Mar-19 10:02 
GeneralRe: SQL Remote Connections Pin
Richard Deeming19-Mar-19 1:57
mveRichard Deeming19-Mar-19 1:57 
GeneralRe: SQL Remote Connections Pin
Kevin Marois18-Apr-19 8:16
professionalKevin Marois18-Apr-19 8:16 
GeneralMessage Closed Pin
22-Mar-19 21:10
memberMember 1419297522-Mar-19 21:10 
AnswerRe: SQL Remote Connections Pin
jschell23-Mar-19 6:01
memberjschell23-Mar-19 6:01 
QuestionHelp with simple database Pin
Member 1418292514-Mar-19 13:14
memberMember 1418292514-Mar-19 13:14 
AnswerRe: Help with simple database Pin
Richard MacCutchan14-Mar-19 23:06
protectorRichard MacCutchan14-Mar-19 23:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.