Recent content by mikarsen

I have a problem with crosstab calculation, hope someone could help me. Here's my main table: Office -Project -Performance Balagtas -OSA -90 Balagtas -Billing Complaints -95 Balagtas -Payments -85 Malolos -OSA...

Hi i updated the code...based on the other's recommendation.. however, the results are not consistent i need to have 10 samples per branch...however, sometimes the program gives me... seven branches with 10 samples each and one branch with 20 samples the total samples (90) are always...

Hi I'm creating an access program that will automatically generate random samples. Samples are generated by using an SQL query and the resulting query is appended to a table. The sample generations works fine by setting criteria thru a textbox inside a form. However, I'm thinking if i could...

yup the field that contains the value in the main table is a 'text' type. however I converted it to a number using the column properties in crosstab... but i still get the same results...

here's my problem... i have a crosstab query where in one field (value) has a range of 1 to 19. I used the min and max for two separate row headings.... the min and max works only on values (1 to 9) or (11 to 19) example... the 2 columns have values 8 and 4 the min returns 4 and the max returns...

Can u show me exactly how to do it? btw, I've attached my sample database for reference. My goals are: 1.) skip some questions depending on the answer to previous questions 2.) some questions rely on the answer of previous two (2) questions like what i said in my first post.

Hi, I have a survey database file containing the following tables tblQuestions - contains survey questions tblResponse - contains responses inputted by user tblRespondents - contains info on user (e.g. Name, Add...etc) Is it possible that answer to some questions are dependent on other...

Hi, I need help with regards to linking the subform to the mainform. I'am creating sample survey in access. I have a subform that would list the questions on the survey. The subform runs fine and displays the questions that are to be answered. However, when i tried linking the subform to the...

yup there is only one row in my first query. Ok il try the code that you suggested.many thanks.

hi integer... can u teach me how to accomplish this task using VBA. Thanks in advance

for example i have a query with... field1 field2 field3 a------b-----c my goal is to create a new table with that gets the values of field1,2,&3 and display as a row in a newly created column newcolumn a b c thanks in advance.

Is there a code or command than can automatically scan/sort all the fields on the table without manually entering the individual fields in the code. example i have three fields field1, field2, field3 the code i am presently using is a series of IF THEN statements for each field.I have to write...

Hi guys, I have a main form with tabbed control in it and several subforms. I have a subform on the second tab which has a larger length than the main form. When I run the form and clicked on the second tab, the subform attached on the 2nd tab centers on the screen which means i have to scroll...

I would just like to ask if it is possible to sort the values of different fields in a report. For example I have three fields that contains percentage values percent1=100%, percent2=65%, and percent3=85%. I would like to arrange the values from highest to lowest... desired output would be...

How can I remove the space occupied by invisible fields in my report? I have already used the can shrink feature, but it still leaves a space in the report. many thanks