Recent content by Luigi_Cortisone

Yes, I agree this may be the correct approach but on this occasion I would like to store the calculated value Are you able to assist with the request? Cheers, L

Hi, I have a table 'Widgets' with a numeric field 'Inventory' that stores the number of widgets in stock. An 'Orders' form has a 'WidgetOrders' sub form which is used to record the widgets for that order. Each record on the subform has an 'OrderID' and 'WidgetID' control When a checkbox...

My source tables all have different fields except for two fields which are common to all. I wanted to extract this data from each table and produce a 'master table'. That union query did exactly what I was after however if there is a better way I would appreciate it. Thanks again for your...

Thanks big guy, that looks potentially quite exciting. I'll give it a try at home tonight Cheers, Luigi

The source tables contain a large number of fields however I just want two the id and age to insert into one master table. How would I use a Union query to work on multiple source tables and one destination table? Thanks

Can I use one append query to update a table from multiple source tables one source table at a time?

Hi I have two source tables 'links' and 'switches' I want to copy just the fields 'id' and 'age' from each table into the 'summarytable' Can someone help with some vba that would do the trick Thanks, Luigi

I needed to take the output and add it to a field in a larger 'conductors' table

Hey Jal I tried to convert this to an update query and it screwed the results, otherwise its working perfectly Many thanks for hanging in on this Cheers, Luigi

Hey Jal, two concretes and a wood are producing a wood, should be concrete ??

Thanks, I'll handle the nulls as you suggest testing now, cheers

Yes two unknowns should produce a 'concrete' I also discovered a few null values in the source table which shold default to concrete Cheers, Luigi

Hi Jal Concrete, wood and unknown are the only three values If the count is the same for concrete and wood then the value is concrete Cheers, Luigi

Hi, hope someone can help I'm fairly new to vba but I'm sure the answer is in here somewhere. My table contains the following fields... ConductorID - a conductor shares one or more (mostly 2) poles with other conductors. Material - the pole material of each pole related to an individual...

Grazie molto guys I used Paul's model and it worked come un fascino! I'm building those lookup tables like theres no tomorrow. Cheers Luigi