Search results

Thanks for your time. Yeah I know I am asking silly questions and you are getting offended. Apologies for the same. :( My query is that I have these two tables. http://screencast.com/t/thuVPPl7d. Now I want to make a query to get all the selected fields i.e bcch_uptime from Union_part 1 and...

Dear Experts, I want to create a in which user would input the start date and the number of days user wants the data. What should be the excel query for the same? I used WHERE ((([Union_part 2].period_start_time)=[Enter start date:] And ([Union_part 2].period_start_time)=[Enter number of...

Dear Experts, I want to make graph from the queries. I have 50 such queries. How to achieve this without repetition for each query.

Thanks Dear, I am a novice and tends to do mistake. My query is that I have made two unions with each having few common and few different fields. I mean Union 1 have x,y,z,a,b,c fields and Union 2 have a,b,c,d,e,f fields. Now, I want to query fields from both the unions using a single query. I...

I got your objective, yes the table can be normalized, but these are technical data where table structure cannot be altered much. The field will be constant for next three years without change. Thanks for your advice. Moreover I have successfully created table and made union too. I created two...

I haven't got the right to post pic. However writing the fields:- period_start_time bsc_int_id bsc_name bcf_name bts_int_id bts_name bts_id seg_id la_id_lac cell_id total_call_trf_6 traffic_area_trf_1 traffic_trf_12b half_rate_traffic_trf_102 amr_full_rate amr_half_rate average_dhr_traffic...

Ok, I am sharing the details:- There are 254 fields, and I have to create table of around 5 million rows. Now I have to make daily trend (graph) with specific dates for around 30 fields and requirement may change dynamically for the trend. I have monthly excel .xlsx format which I need to...

what are the best practices for creating a database access? Actually my access starts behaving abnormally when filesize reaches 20 GB. :confused:

Yes got it. Thanks. I have skipped the where part and saved it as a main query Also please suggest what changes I have to make so this main query gets sorted in ascending order. I mean datewise. Thanks..

Got your point, but if I am making a single table, the rows exceeds more 0.5 million and needs to keep on growing. Now after 0.5 lakhs when I am trying to add extra rows, I am getting error like "cannot open database ". It may not be a database that your application recognizes, or the file may...

Working:- :) Now next step is: BBH KPI Database_June'16 and BBH KPI Databese_Aug'16 are my two tables and peirod_start_time, bts_name and tch_comp_rate are my columns. My queries goes as follows: SELECT [BBH KPI Database_June'16].period_start_time, [BBH KPI Database_June'16].bts_name, [BBH KPI...

Dear Expert, I have three identical tables for different months (June,August September) . I want to run a single query so that data can be pulled for all three months together. Please guide me for the same. Thanks

Hello Everyone, Myself Rohan, from India want to learn access programming. My hobbies includes browsing, gaming etc. Thanks for adding me in the forum.