Recent content by knzass

nope no broken statement whatsoever

i made a chart report using the report wizard, the chart is based on a query "Qr_Trend_Type" the fields are"CType" and "Date_Today", both have "group by " in their 'total' fields. Ctype is the case types,billing,inquiry and technical) date_today is the date of the case. the chart generated is...

opss the criteria is " Between [Forms]![Fr_Statistic]![MonthStart] And [Forms]![Fr_Statistic]![MonthEnd] " (not MOnth1 and Month2)

i have a form with two combo boxes "MonthStart" and "MonthEnd" each displaying the months of the year from january to december(ive assigned 1-jan,2-feb, etc) i made a query which selects between these two values, the field name is "(DatePart("m",[Tb_Case_Log]![Date_Today])) " and the criteria...

i have created a chart report which is based on months(jan,feb,etc) what i want to do now is to create a form where a user can choose to pick from what month to what month does he want to view the chart report if possible, i want to put two combo boxes that will display the months of the...

i have a field named "Date" which uses the short date format "mm/dd/yy" i know how to create a - BETWEEN "" AND "" - for dates but im not sure about months - regarding ur suggestion, how can i extract the month from the short date format:?

ive succeded in creating a report which list downs all te records based between two specific dates , what i want to do now is to generate a report according to months... for instance how many records are there in the month of Jan, and also how many records were there from the month of January...

how can i generate a report which is based on more than one query?

besides using an input mask is there anyway to put a caption on a text box?

i have two forms "Fr_Case_Log" and "Fr_User" the first form which has a combo box displaying the entries of the field "User_ID" form the table "Tb_User" and a command button which opens the form "Fr_User" the 2nd form has a text box which also displays "User_ID" from the table "Tb_User" what i...