Search results

hi everyone! can anybody help me? currently the database i am debugging has been set in long size paper in printing. now, i want to print it in an A4 size, but when i changed the setup in printing, or configuring the printing preferences it didn't work. what will i do? please help

hi everyone! can anybody help me? currently the database i am debugging has been set in long size paper in printing. now, i want to print it in an A4 size, but when i changed the setup in printing, or configuring the printing preferences it didn't work. what will i do? please help

I have a query which computes for date interval. Then in the report, I used the function SUM basing from the query to show the total_years and total_months. The problem now is in total_months, because if it exceeds or equal to 12, the total_years should increase by one (1) then the...

is it possible to call the query option? meaning in printing the report, instead of using TABLE, im going to get the data from QUERY. what would be the sql statement then? please help! Thanks

i have a report RPTotal, then there are 2 fields to be printed out TYear and TMos. currently if user1 has 3 records, all of them are printed out, what i want is to show only one record because it's all the same. e.g if there's 3 records instead of printing out: TYear: 4 TMos...

i have a query w/ 2 fields(by_year, by_months), and i want to get the sum all entries in each field of every user. select query.by_year, query.by_mos where userID = .... is it possible to make it in a query design automatically? or should i make a function for it? please help. thanks

can anybody help me? i have an existing database then in the main report i deleted one subform then changed it with the new subform. But when i tried to generate the report (the printout), the margin now changed, but i didn't change anything with regards to format ... i just follow the width of...

Please help! I have a form FORM1 that will accept the ff: fields (day1, day2) then stored it in TABLE1, then in query option I created a query QRYDATE for some calculations on that fields. Now, the output of that is in the QRYDATE, fields are : (dyear, dmonth). My question now is, How can I...

please help! I have a query wherein i want the data to be displayed as Integer not a Float/Double. How will i set it? Since there's no data type field in query part. please help ASAP. Thanks

Can anybody help me? I have a query which is qryInterval, and i want to get the data for further computation. Then after that insert/save the output of that computation in that query but in different field. e.g the values of the qryInterval are the ff: id interval 1 400 2...

can anybody help me? this is the scenario: in table1 these are the fields (date_start, date_end, total_yrs, total_mos) in input form the user will fill-up only 2 fields (date_start, date_end) e.g. Date_Start: 1/1/2004 Date_End: 3/1/2006 now, i want to get the total months and years...