add fields

slyfox6915

New Member
Joined
Jan 31, 2022
Messages
11
Office Version
  1. 365
Platform
  1. Windows
Hi i am working on an app that would be used for creating work orders

sometimes we have clients that have 1, 2, 3, 15 equipments for us to maintain

how can i tell access to create the amount of fields needed

i need the following

Manufacturer / model / KVA / S/N / Cabienets / Localasation

like i said some clients may have 2 or up to 25

on a form i would like to have a textbox that asks how many piesces of equipment to service

then it would create to needeed amount of lines to input all the infos


thank you
 
Thank you

working on that now

but i have another question :(

in my table equipment i have many equipments that is owned by each service locations

i need to do a report for each piece of equipment owned by that client

did i just answer my own question ? been looking at youtube vids all week and not finding what can help :(
 
Upvote 0

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Basically the same approach as any form you'd make for this. Main report with client data, subreport with contact data, another sub report for equipment data. Or decide which is most important for a paper form - contact data or equipment. It's all about what you want the report to do for you. Don't worry about sorting/grouping in report queries too much. Reports have their own sort/group features that over-ride whatever you do in the data source (query or table or sql statement).
 
Upvote 0
Basically the same approach as any form you'd make for this. Main report with client data, subreport with contact data, another sub report for equipment data. Or decide which is most important for a paper form - contact data or equipment. It's all about what you want the report to do for you. Don't worry about sorting/grouping in report queries too much. Reports have their own sort/group features that over-ride whatever you do in the data source (query or table or sql statement).
I think i figured it out thank you so much
 
Upvote 0
Glad to see you figured it out. Thanks for the 'like'.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,207
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top