Search results

Hi all, I would like to combine my crosstab union query with a simple query as one query. Below is my union crosstab query SELECT [Size breakdown], XS, S, M, L, XL FROM [CollarLengthAndWidthQuery]; UNION SELECT [Size breakdown], XS, S, M, L, XL FROM [CuffLengthAndWidthQuery]; Below is my...

Hmm, for my calculation part is a bit complicated and confusing. Firstly, i will need to convert pounds to KG before doing the calculation for the gross weight. The gross weight calculation is determined by a few factors such as the fabrication, reference, and sample requirement, thus there...

Hmm, I am actually doing calculation on the form before saving it to the table. What other suggestion do you have?

Thank you! It has been solved!!

hi, but what if i retrieve the data from "Master" subform and save in my table, will the above method still helps in breaking down the calculation in the "detail" subform? I did not receive the private message

Do you know how can save the data in the "detail" subform, and it will sum up the calculation part in the "master" subfrom?

I am sorry, i cannot post the db here as it contain confidential information. I am facing issue with an extra line of colour appearing which does not contain any information. Based on the image i attached, i have box the extra line of colour which should not appear as it contain no data

Thank you for your help! It solve my issue. After trying out this, i use it on tthe other database which works perfectly fine but how can i remove an extra line of colour which does not have any value?

Hey there, isit possible to link two or more field in the parent to child fields on form? If yes, how can i do that? I want to achieve like when i click on the line that contain white colour on the master subform, the details subform should only display the data that contain white

Hi there, How can I break down my data into the image I have attached after grouping all the data together.

Ok, I have attached an image of my desired output.

Okay. Currently, i have a table which consists of all the purchase order data and one purchase order number might have up to 10 rows of data with different fabrication and colours. Hence, i have a form which allows me to select the 10 rows of data that belong to same purchase order form and i...

I want the result to have two column heading called Fabrication, Remarks. Then the size should match to the correct fabrication and remarks

Yes! I am unable to retrieve all the multiple rows of data that i have selected to my form.

Hi all, how can i select multiple row of data from subfrom/listbox to my form?

Hi all, I would like to ask how to combine two different query into one? I have a union query and I would like to combine it with another query. I have attached images of the two query above. The purpose of combining these two queries is to use it in creating a report. The end result i...

Yes, i tried your example! Your example is perfect, just that i will need to include fabrication,colour and remarks into the report as well

Thank you! thats excatly what i am looking for!. However, how can i display colour,fabrication and remarks in the same report as well?

Nope, I cannot display the report in a form. I design the report by using report wizard and the end result that I want to achieve is to able to display the data in a table form in the report. I tried using the crosstab query but I did not manage to get the end result I want. Can you help me...

Hi there, i have attached the data above.