Search results

Yes thank you. Attached in picture

I have to calculate all records from table classroom where professor has taught in the morning so before 1 P.M

Time is a field like in the picture attached. I have to extracts only times that are in interval 9-12 AM Regards

How to get interval time of day for a query For example I have times of lessons 09:00 AM 12:00 AM 16:00 AM and want to get only times between 9-12

How to convert year of birth with age using queries Example 1981 to 32 years old

Just cannot manage a query to make both operations same time. Can you please provide an example? Regards

Need to create a query which selects all enrolled students from table table "enrolled" and insert a new calculated field as follows: MarkUK: Mark-EU*0.7 Regards

No the form is closed and control holds value Date(). For me is ok if I dont use at all WHERE (((Data_SDP.[Data e fillimit te tremujorit])=[Forms]![raporte_te_tjera]![Jepni Daten e fillimit te tremujorit])) but don't know how to modify query work even without that. Regards

Hi Using this query I get data as in picture attached. Maybe because of #Error values (not sure) my report created doesn't run. First send a message another user ... then message invalid usage of null Can you help? Regards

Thank you for the fast reply. Can you please help in specific case listed above. Error is like in the picture attached Regards

Hi, Using this query I am having syntax problems. Being a beginner can you please help me identify the query problems and making it work for me? Regards SELECT District.Id, District.Emer AS Rrethi, Data_SDP.Ref_SDP, SDP.Emri AS QPF, [Mg1]+[Mg2]-[Mg3]-[Mg4_t]-[Mg5] AS Mg4...

Hi, I have data collected by a query as in attached file. I need to create a report of city name i.e Berat , PeriodSemiAnnual i.e First 2002 (12002 in the table) and other data by summing rows where the PeriodSemiAnnual is the same. For example first 2 rows of report should be ...

Access 2003. This is not by my choice but the office where the program will be used have only Access 2003 and no will to change :)

Hi I have a table like below : ID BeginDate EndDate Product1 Product2 Product 3 1 1/1/2000 31/3/2000 100 100 100 2 1/6/2000 31/9/2000 100 100 100 ..... I have to compute totals of products for periods of 6...

Hi, By using the following query SELECT District.Id, District.Emer, Data_SDP.[Data e fillimit te tremujorit], Format$([Data e fillimit te tremujorit],"\Qq yyyy",0,0) AS Tremujori, Sum(Data_SDP.Mg3) AS [Low Dose], Sum(Data_SDP.Mcv3) AS Pop, Sum(Data_SDP.Depo3) AS Depo, Sum(Data_SDP.DIU3) AS...

Hi I have data in intervals by 3 months as in file attached where is shown 3month beginning date and ending date.I need to group by 6 month or one year period. How is this possible? Regards

Thank you, Anyway the query still not working for me. I attached 2 pic one of tables I am using and second of data query I posted print. Can u give me some further orientation pls. Regards

Hi How can I modify this query showing the results of 3 months data : SELECT District.Id, District.Name, Data_SDP.[First Date of 3month period], Format$([First Date of 3month period],"\Qq yyyy",0,0) AS TreMonth, Sum(Data_SDP.Mg3) AS [Low Dose], Sum(Data_SDP.Mcv3) AS Pop, Sum(Data_SDP.Depo3) AS...

Hi I have Access 2010 installed but now I have to work on a project initially developed on Access 2003. Is it possible to have both Access versions on the same machine or do I have to take any other solution over this? Best regards

Hi I am working on a DB developed by another person and I have to make some changes. This guy has used access user security and I have to connect with some system db and then enter Administrator password. Ok I have this password but I want to clean the system from these security measures so I...