Search results

THX for your insight! The problem was "...desc" istead "....asc" in my query.

wor is a variable as long sometimes wor= 5, sometimes could be 23 etc. There's no rule. It comes from another code.

I would like to get minimal value from "Ski" column Need to use recordset instead Dmin function because this value will be changed many times. I work with dao.recordset but I never used recordset filter so I need to do something like this: strSQL = "select...

I tried strSQL = "Select [nazwa], [id_wycena_pre], [Format_(X)], [Format_(Y)], [kolory p], [kolory t], [nazwa_id], [iloscstron], [numerarkusza], [naklad_pracy], [Kolory P], [Kolory T] from tblGoraZleceniaNowaWyceny where [id_wycena_pre]=" & Forms!frmWycenyObszarRoboczy!ID_wycena_pre & " and...

I have a query which working fine: strSQL = "Select [nazwa], [id_wycena_pre], [Format_(X)], [Format_(Y)], [kolory p], [kolory t], [nazwa_id], [iloscstron], [numerarkusza], [naklad_pracy], [Kolory P], [Kolory T] from tblGoraZleceniaNowaWyceny where [id_wycena_pre]=" &...

The source is one table with 2 columns: 1) id 2) colours rst!colours is a text field. TheNumberOfPrimaryElements - when I sum all of colours from primary elements then we have 5 (blue+red+purple+green+violet = 5) I need to storing all of my colours in one field (it's usually no more than 5)...

Comparing content to other content I have to know, how many elements matching to my primary elements from any records of my query and count match, if some element doesn't match then I need to add it to my primary elements, then at the end (rst.eof) count how many primary elements I have. I...

It's not about language differences it's about region differences. Yes it's numeric field as double.

Run-time error '3075' syntax error (comma) in a query '4,6666666666' It's not exactly the same message because I don't have english language pack. The same error in both situation: DLookup("Id_Rozklad", "tblRozklad", DMin("sna", "tblRozklad")) and DLookup("Id_Rozklad", "tblRozklad", "sna = "...

I have problem in DAO.Recordset when I want to take value with decimal numbers because In my region we have "," instead "." so Ms Access shows an error "comma in your sentence..." I need take a value eg. 12313,4345 (sna). I tried Replace function but it doesn't work:/ I don't want to round my...

Can't show exactly Ms Access error description, because I don't have english language version. "Naklad" is a number - column in my tbl. So if this problem isn't clear I can do this using DAO.Recordset. Am I right? In DAO.Recordset everything works good.

I need to count some proportions for every row "naklad" from table "tblRozklad". The results will help me count another value (by another code).

If I try without group by, then Ms Access shows an error, about trying make query without group by :/ I can do this using DAO.Recordset but I suppose that it should be done with SQL statement?

I don't know why, but Ms Access has some problem with operator in my statement:/ Dim strSQL As String strSQL = "Update TblRozklad set [ProcentZcalosci] = ([Naklad] * 100 / Sum([Naklad].tblRozklad) * Forms!frmRozkladGlowny!IloscUzytkow / 100) GROUP BY ([Naklad] * 100 / Sum([Naklad].TblRozklad)...

Ms Access Shows the line as red so something is wrong Dim czyjest As String czyjest = DLookup("[laczone]", "tblZlecenia", "[Laczone]='" & Forms![frmZlecenieRoboczeMarzena]![ID_Zlecenia] & '" And [ID_Zlecenia_info]='" & Me.NoweNumerZlecenia & "'")

So how should it looks like? ..And [ID_Zlecenia_info]='" ? Still doesn't work

"Compile Error: Expected: expression" Dim czyjest As String czyjest = DLookup("[laczone]", "tblZlecenia", "[Laczone]='" & Forms![frmZlecenieRoboczeMarzena]![ID_Zlecenia] & '" And "[ID_Zlecenia_info]='" & Me.NoweNumerZlecenia & "'") If I have a code without this part And...

I awlays have problem with this "laczone" and "id_zlecenia_info" are text. DLookup("[laczone]", "tblZlecenia", "[Laczone]='" & Forms![frmZlecenieRoboczeMarzena]![ID_Zlecenia] & '" And "[ID_Zlecenia_info]='" & Me.NoweNumerZlecenia & "'") code doesn't work. I think problem is ...And...

Could You Show me this sample(query) in file? It will be helpful for me. Now I can't imagine this, because I don't know what is "pct", "table1" etc.

I built a query "WplatyKlienci" which sum all of payments "Sumawplat" from my clients "klient". SELECT SUM(tblWycenaZakonczone.cenanetto) AS Sumawplat, tblKlienci.nazwaSkrocona AS klient FROM tblWycenaZakonczone INNER JOIN (tblZleceniaZakonczone INNER JOIN TblKlienci ON...