Thanks a lot, This works. Appreciate for your looking and solving my problem. We created a custom join. I have like 7 fields to update in my update query. I will check at my end, if i can create custom joins for all of these fields or not. Thanks again
Hello Everyone,
I have a table with part of it's data coming from an Append query.
In next step, some of other columns are needed to be filled upon the basis of what is the existing value in other columns of same table.
1. Attaching an example DB, where tbl_ItemWardrobes is partially...
Hello MajP, Hope you are doing fine. I have made some progress in my database and stuck on an issue. Please review the recent post, whenever you have time and let me know what is possible solution. Thanks for all your help
Update - 22/11/20:
I think, I will be going with method of exporting the query as a new table and work on it. thanks
Removing the attachment.
Hello again everyone,
I have been slow in updating my database but have made some progress this month. I am again stuck on a issue and seek advice for...
Hello Guys,
I need some help in one form.
This Add item parts form is linked to above subform. I need to enter data in Add item parts by selecting items. There are 3 cbo for Itemmain, Itemsub and item. This is basically to categorize the items.
If I individually choose record source as a...
Oh there is no Standard size or so. Size of an item can be from 500mm to 5000mm. I need the price to appear or calculate automatically depending upon whatever size we fill in manually. I already have a product table all i need is how i setup pricing according to the slab.
I am actually unable to...
Hello Part/Mike
Hope you are doing good.
I need some advice in adding a pricing structure for the items in database.
Scenario is we have say approx 10 basic product category. For example Product 1, Product 2, .... up to Product 10. Then we have 7 variant of each Product and that makes it...
Hello MajP, Hope you are doing good.
I need help in adding a pricing structure for the items in database.
Scenario is we have say approx 10 basic product category. For example Product 1, Product 2, .... up to Product 10. Then we have 7 variant of each Product and that makes it. Product 1A...
I have removed the few extra tables. Removed spaces from the table fields and removed lookup queries from tables. Can I keep typed list of look up items instead? will that be fine?
Hello Pat and Mike,
Thanks for the reply. The detail is quite complex as there are more details to be added to each category later on. I am not very good in Access and learning at the moment and trying to achieve some results from my work.
The customer screenshot is just an example from a...