Search results

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

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

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

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 ...

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

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...

I have 2 textboxes birthday and age.At the first I enter birthday's for example 28/01/1981 at the second I want to enter a value for example 30 and this age to be saved at birthday field in the table like 01/01/1981.This is in case when for smb is not given the birthday just the age. How to make...

Hi I have a textbox where I want to enter numbers 1.2..3.4. and a combobox where depended in what number I enter one city is chosen and stored in DB. For example I want to enter 1 and in combobox to be chosen Boston which is the value to be stored in DB? How to make this possible? Regards

Hi I have 2 textboxes.By entering different number values to the first I want to return text to the other.For now my code is like that but not working : Private Sub Text430_AfterUpdate() If (Me!Text430.Value = 1) Then Me!Text431.Value = "BR" ElseIf (Text430.Value = 2) Then...

Hi All I have a table Cities with name of cities and IDs.For example: ID City 1 LA 2 Moscow 3 Paris 4 London I wrote code like this If (Me!Text430.Value = "LA") Then Me!Text431.Value = 1 to enter city code and to get the ID. I want in textbox432 to enter ID and to get...

Hi all. I am trying to figure out the construction of country demographic presentation. We got municipalities with circles,circles have one or more cities,cities have bashkia and comunes,comunes have villages as smallest part. I have to chose in my form circles and then from active cities to...

Hi. Is it possible to create a frame with 3 check-boxes which can be checked in the same time all three or just one or two of them.Also I need three text boxes to be activated for entering text when this check-boxes get checked.Please help

How to make possible in a check box with 3 options to be selected more than one? For example I need 2 or all 3 options selected. Regards

Hi How to limit text box to enter only 10 digit number? Regards