Recent content by vaskoemilov

Hello, Thank you a lot for the advices given. I'll try to keep up with all of them. The reason here for all the odd names is that they are part of a DB which I can't mess with :) As for the problem i had - solved on the next step. The make table query always showed mismatch mistake but after...

This is the whole query (make table one) SELECT DISTINCT all_bss_pmg_allbsspmg_cell_bhr_kpi.timestamp, all_bss_pmg_allbsspmg_cell_bhr_kpi.cell, all_bss_pmg_allbsspmg_cell_bhr_kpi.[TCH Congestion nom], all_bss_pmg_allbsspmg_cell_bhr_kpi.[SDCCH Congestion nom]...

Hello, Tried it but i get the same mistake. When format(Left([all_bss_pmg_allbsspmg_cell_bhr_kpi].[timestamp],10),"dd\.mm\.yyyy") AS [fldDate] I get "18.12.2011" - text value but with cdate in front same mistake. Thanks, Vasko

Hello and thanks, After your advice i tried cdate(Left([all_bss_pmg_allbsspmg_cell_bhr_kpi].[timestamp],11)) AS [fldDate] but i get "Data type mismatch in criteria expression. (Error 3464)" original field value - "18.12.2011 г. 01:00:00" - date/time result of...

Hi, I'm begginer in access and i have the following problem: In Acc Query i have field with Date/time type containing "16.1.2012 г. 21:00:00" After separating date and time in two different fields (text type) i want to convert the date "Jan 16 2012", which is text into date/time type to link it...

Not a problem. This is not an urgent matter so I will be thankfull to look at it when you have spare time :) Here's the 2003 version.

here is the example DB the question is how to get only CSSR PS(or RRS setup) value(s) from TABLE in the RESULT query based on selections in boxes BSC.C and BSC.D1(or BSC.D2) in form BSC.

Hello, Fisrt i want to say that i'm novice here and in Access. The main idea is to extract all cell from chosen RNC which KPI is below or above selected value. I have the following issue: dhttp_://imageshack.us/photo/my-images/818/accessquery.png/ As seen on the picture i want to create a...