eneyardi
Last Activity: Mar 15 '17, 02:00 AM
Joined: Jul 29 '10
Location: MGB
-
eneyardi replied to How to show in a report no duplicate for the first and total only for the next field?in AccessThanks alot jforbes, it works perfectly. Now I can design my report easily. Thanks again! -
eneyardi replied to How to show in a report no duplicate for the first and total only for the next field?in Access=Sum(IIf([Company]="APMC",[PA4]))
I figured out the sum for each company, using the formula above. My problem now is, How can I only companies with no duplicates and no spaces below. example, the first column of company is APMC then followed by FEC, PNPI and VIL.
They must look something like the image link I provided.Leave a comment:
-
eneyardi started a topic How to show in a report no duplicate for the first and total only for the next field?in AccessHow to show in a report no duplicate for the first and total only for the next field?
I have a table name[List] which a field name [Company], [PA4] and [SA4]. In the company field it has a list of APMC,APMC,FEC,P NPI,PNPI,VIL. In the field PA4 it has a list of 1,1,2,1,2,2. And in the field SA4 it has a list of 2,2,1,2,1,1. I have a report name [JobReport], and I want to show only in the Company field that has no duplicate values, so it must show only APMC,FEC,PNPI,V IL. And in the PA4 and SA4 field, I want to show only total of each... -
thank u philhalton, that really helps. I just need to modify it more. thanks.Leave a comment:
-
if possible to select multiple fields in a listbox so that based on your selected fields in listbox, thats only the fields that report will show. or If it can be done by checkbox then how to do it?Leave a comment:
-
eneyardi started a topic how to filter report based on the list you selected from listbox in a form?in Accesshow to filter report based on the list you selected from listbox in a form?
I want to filter report to show only field you selected from a listbox in a form.
For example I have query which field are ID, Ni, Fe, Mg and Sc
The field ID is primary key. it has value of 1 meaning first record. then the value of field Ni is 50, Fe is 49, Mg is 1.124 and Sc is 3.014. I have a listbox in a form which name is listfilter, then it's row source type is field list which shows;
ID
Ni
Fe
Mg... -
Thanks twinnyfo for your suggestion, but still it didn't work. What I did is, I made a subreport where I seperated my label in page header to page detail and it works perfectly. Thank you guys for all your suggestions.Leave a comment:
-
jimatqsi it works, but my another problem is the report header is affected by the column when i set it in two, i have a label in report header and it's in the center. how to avoid that the report header label is not affected by setting the column to two?Leave a comment:
-
Thank you jimatqsi i will try thatLeave a comment:
-
How to make two columns in a report?
How can I continue the data other column of report?
Please see image attachement>>
This is the output that I want to achieve. I want to extend the next data in right column of a report. I don't want to continue going down the data but instead use the space in the right to add a column.... -
Thank you again NeopaLeave a comment:
-
Neopa are these 3 tables have their own primary key? or only the tblResult must have the primary key?Leave a comment:
-
Thank you Neopa, I have a better way now how to do it. Thanks alotLeave a comment:
-
Thank you NeoPa, can I attach picture showing what i want to achieve? may an illustration?
[IMGNOTHUMB]http://s14.postimg.org/6iditj3pt/Analysis.jpg[/IMGNOTHUMB]
The picture link above is the example I want to achieve in microsoft access table or form in datasheet view or single form. Is this possible to make in access?Last edited by NeoPa; Feb 1 '15, 05:36 PM. Reason: Merged posts and made picture more easily viewed in place.Leave a comment:
-
is it possible to have a field name then under it there is a data field that will serve also as seconday field name then under it is the data field
example. field name
secondary field name
data fieldLeave a comment:
-
thank you for your reply Neopa, My question is how can I do that in creating a table. the METHOD is the field name, then the data fields are METHOD1, METHOD2 and METHOD3. then under them there are values 1, 2, 3
Can it be design in table or there is a way to do the sub datasheet?Leave a comment:
-
How to make database on this?
How to make database with this;
Field name is [METHOD] then under [METHOD] there are selection of [METHOD1], [METHOD2, [METHOD3]
then under [METHOD1] there is a value [1,2,3] then in [METHOD2] there is also a value of [1,2,3] and also for the [METHOD3]
this is the output (disregard the arrow):
...Code:METHOD --> METHOD1 METHOD2 METHOD3 1 1 1Last edited by NeoPa; Jan 23 '15, 01:05 AM. Reason: the text alignment is not achieve - {NeoPa} fixed alignment for you. -
Hi twinnyfo, for example i have a form name tbl1 and the fields are country and population, in country fields - all country are listed like malaysia, london, china, usa, france and japan
and then all of these list, there are little cross on their upper right area that when i click that there will be another list, for example i clicked the little cross of malaysia then there is a list of all its provinces. I have since a sample database of this...Leave a comment:
-
this are the fields in my table name [PNPI]: Job number, Client, number of samples, Date received, Date Completed, Project, Client Ref, Method, in method field there are 3 selections (4A/OM-OES, FB1/XRF40 and UNK/LOI) and under that 3 selections there is another 5 selections (Sc, Ni, Co, Fe and MgO) then under that is the value, for example I select the method: 4A/OM-ES then under that i select SC then the value of Sc is 53 How can I achieved this...Leave a comment:
-
Thanks Stewart Ross, yes it is much quicker in Excel because I can easily achieved what design i need in my data, unlike in access it only focus in data but limited in design. But I need to do it in access. the attached file is now bigger than my previous sent attachment, this is what i want to achieved as a printable output in access....Leave a comment:
No activity results to display
Leave a comment: