Search results

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?

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...

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...

I've had this before but every version i submit when i switch to datasheet view asks for Paramaters, i'm creating a field ina query called Group_Space_Available_CM and the expression reads: Group_Space_Available_CM...

I'm not quite sure how to go about this, I want a calculation field in my query but the amount to multiply by depends on a critera, without the criteria it would look like this: [Sectional_Space_Available_CM] x X , X being 0, 1 or 2 but whether it is 0,1 or 2 depends on what the value in...

I'm building an access query, in it one of the fields is called [Space Available (cm)] I'm trying to add a divided by 6 field, so I've inserted a field in design view in the query, it looks like this: Field: Expr1: SectioalSpaceAvailable Table: Sort: Show: Criteria: =[Space...

I have an access query that generates 15 fields of output, I would export this into excel and insert additional columns with calculations, the first being a running total. I have many sites, with a site id [Site] in the first filed of out put, column A in the excel export and each site...

Whats the easies way to have the query criteria being the equivelent of a vlookup, i.e. pointing to an editable table of values to return other than a string of values in the criteria box itself? thanks in advance! I haven't danced with Access in over a decade so on a rapid refresher