Recent content by jyadayada

Thanks for reference to the example, I can't seem to et at the design view though to see how it was built Even though I stated a base understanding of normalising data, in my mind this would have sperate tables for each of the repeatable fields Site / Block / Floor / Room with a reference / key...

Thanks all again for the inputs I do have a base grasping of normalising data / relational table design, I am now going down a rabbit hole of watching tutorials about cascading combo boxes, the example i'm watching currently is for a State / City example and I'm trying to find something that...

Thanks for replying! Sorry I should maybe explain the use case a little, We're going to do an asset capture exercise, I want to have a form (or other method of submission) for the field engineers to submit asset details into a centralised location for ETL to a new system. I presumes a...

Hey Thanks for taking the time to read, my first question is can Access Forms do what I need to do, namely: I need to capture Location which is broken down into segments, Site / Block / Floor / Room, If I have dropdowns in a form, can I have it so that if Site A is selected, only Site As...

I've come to seek help guidance on a piece of work I have to do, Hello all and thanks in advance for your patience / help :)

Is it possible to create a clear (and import to) table button that when you click you can either select the table to delete all records from or import into or select all tables?

Fantastic! that works a treat In case there aren't thousands of exclusions and the Not In("Value1","Value2") route is taken, i don't suppose you know off the top of your head the maximun limit on number of values is thanks again!

I've built a query that I was going to point to a helper table of just the field values to be excluded so the criteria is covered by that look up list so would Not In ( (SELECT [FieldName] from [TableName])) work?

I have working Not In ("Field Value 1","Field Value 2","Field Value 3","Field Value 4") but I'm building this to be worked by my successor and the exclusions could run into the thousands, more likely hundreds but a long list to express as above this is why i'm lookinh for a Not In [Point...

I appreciate the links and they are bookmarked but i'm so new to access that the SQL view of queries doesn't fully make sense to me yet, I build them in the front design view Is there criteria expression text i can put into the field in design view that will return the query without the...

I've previously built queries where you filter the results by pointing the criteria of a given field to a list of inclusions, I can't remember the exact syntax but something along the lines of Is In [FieldName].[Table Name] I'm need to write this into the design view criteria of the field...

you're right, I've just found some duplicates in one of the child tables so it was doubling records, but now I'm getting less records than the primary table, I'm just doing a clash to see where the holes are coming from thanks for the input, How do I close a thread btw?

I have a query of 5 tables, the primary table holds 600k records, the query is to emulate this primary table but adding additional fields from the other 4 tables based on joined fields, SiteID and StockID my query is returning over 650k records and I'm guessing it's based on the join types...

The three fields all come in from seperate tables, they only exist as three fields in the resulting queriy, the same query I want this [Group_Space_Used_CM] field in

Thank you! There's another expression in the query referring to this field, which I had now renamed after IIFing it, what a doof!