Hi,
I have a question for my query in which I used the count option in the column "Pole1". Is it possible to add a criterion that would not count duplicate values?
SELECT DISTINCT Count(Tabela1.Pole1) AS PoliczOfPole1
FROM Tabela1;
Hi,
I have a question for my query in which I used the count option in the column "Pole1". Is it possible to add a criterion that would not count duplicate values?
SELECT DISTINCT Count(Tabela1.Pole1) AS PoliczOfPole1
FROM Tabela1;
Make Q1 to pull distinct on the column.
Make Q2 to count(field) from Q1
Thanks for your help, I still have a question for an Access form (continuous form), in which I wanted to enter values in one combo box, after pressing the save button, the values were added to all rows in the table.
I tried to apply, but in continuous form the value was only assigned to the first row of the Person field
Private Sub recommendation_Click()
If (Not IsNull(Kombi.Value)) Then
Me.Person = Me.Kombi
End If
End Sub
Last edited by Maxlond; 02-26-2021 at 11:11 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks