Search results

Ok, and how this is working? SELECT DISTINCT Abs([ID] Mod 10) AS NUMS FROM MSYSOBJECTS; why Msysobjects has only 10 numbers? Jacek

thank you very much!

thank you Guys!!! arnelgp awesome! how this is working?: Can you explain? SELECT ([qry0To9].[NUMS]*10)+[qry0To9_1].[NUMS] AS Expr1 FROM qry0To9, qry0To9 AS qry0To9_1 ORDER BY ([qry0To9].[NUMS]*10)+[qry0To9_1].[NUMS]; So generally you just as row source added numbers from 0 to 99 and the...

Hi Guys, i created simple example database to reproduce error with i am facing off. On my form i have Group: Men and Women and on subform i have Names and NumberOfPets: The combobox source is from People.NumberOfPets column. What i want to do is to update current record with the added...

o wow thank you Guys!!! i will go with the loop Jacek

Hi, it is possible to not refer to already created query but to set up combobox values from 1 to 100 inside combobox source row property? Can anybody help? Best, Jacek

Thank you Guys! Oh it is a lot of tests to clear this up ! Best, Jacek

Hi Guys, is there any button to place properly all tables in Access relationships window? Sometimes when i open i have very big mess there: Please help, Jacek

Hi, thank you very much ! I investigated further and my SQL do not have sense indeed. But issue occurs only in this specific situation. I just retrive ID field (not all table) and it is working. If i will take my long SQL it will work like a charm - to reproduce situation to get nulls...

and Colin so why my big sql (the same mechanism) is working? I checked twice. If i am deleting something from Temp table and want to see all fields which should be deleted from database table - i have empty field now- i see query result with 1 row. So this is working. Why? Jacek

Hmm thank you, i do not udenrstand it. This is a left join. If in one table i have "Null" and in second table i have "Null" it should check that in first table there is "Null" in second is also "Null" so we do not matching fields. So table1 has the same values as in table2...So if there is no...

I have just replaced statement like this: ( t2.percentsnapshotspace = t1.percentsnapshotspace OR ( t2.percentsnapshotspace IS NULL AND t1.percentsnapshotspace IS NULL ) ) with statement like this: Nz(t2.percentsnapshotspace,"NULL") =...

BTW. I am using this sql also: SELECT DISTINCTROW t2.* FROM tblvolumes AS t2 LEFT JOIN qryim_sourcevolumes AS t1 ON ( Nz(t2.linuxmountpassno, "null") = Nz(t1.linuxmountpassno, "null") ) AND ( Nz(t2.linuxmountfreq, "null") =...

Yes this is true. But Nz Function is returning any string if Variant field is null: In this case it means when i will create select query and use Nz function i will get Null there as string (as Nz result) And this string i want to join. Best, Jacek

Yes, because in other case Gasman if you will not use Nz function Access will not see joins with nulls. You can not join empty fields in Access. Please take a look into: https://www.access-programmers.co.uk/forums/showthread.php?p=1605987#post1605987 Best, Jacek

Hi, i would like to check corresponding fields from 2 seperated tables: tblVolumeNames VolumeNameID VolumeName 1 Vol1 2 Vol2 3 Null (blank) 4 Vol3 Temp_VolumeChanges ID VolumeName Name 1 Vol1 Paul 2 Null (blank) Jacek 3 Null (blank) John I want to check which volumeName is...

Hi Guys!! Sorry for my late answer. Thank you very much for your explanations and help! I tried once again. Colin explanation helped the most. Best Wishes, Jacek

Hi, i am getting error while importing data from CSV: Why is that? I checked field Names and they are divided with double qoutes and Names are correct. Without any "_" or other special signs. Can anybody help? Jacek

thank you very much. Gasman - your query is no making any difference. ok, thank you, i will provide sample. Colin - your method is not explaining how to deal with database bloating. Constantly deleting from table will result with database bloat... Jacek

Thank you Colin for reminding. I saw a lot of methods for that but i am trying to delete only not existing rows in database table. So your method 1 and 2. But in this case i can not do this because i have to build query first and on this query delete data. So the solution seems to be delete...