Search results

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

Hi there Paul Here I go uploading the database. Hopefully you can make sense of it. Its just a small snapshot but should give you enough to guide me through Gracie again Luigi

Hey Paulo No luck zipping the file. I'll try from my other poota tonight Cheers, Luigi

Hey there I've been battling bravely to upload a small snapshot of the dB without success. Can I give a few more details in the hope you can stitch something together? The ‘id’ field is to be inserted into the new table (table2) together with its category which is derived from a...

Hey that sounds potentially quite exciting, just update the lookup table Any help with this approach would be appreciated Like looking into the bottom of a tequila bottle! Gracie

Hi there I may not have made this clear The fields I want are in an access table, in this example table1. These fields in combination will be used to add the value 'category' to the field in table2 I'm not hard coding anything, just using a nested 'if' or a case statement to populate the...