Search results

Hi all! I have a tough problem I was hoping I could get some help with: I would like to create a recordset based on the "middle" 50% of the data. I need to chop 25% off the top of the data, AND 25% off the bottom of the data. Any ideas?

Hi all! I have created a database with auto-archiving features. I have "working tables" that are populated when the product is moved to the correct process, in this case when it reaches the test department. When the product is moved out of the relevant process, the database runs several...

I am normalizing data from a spreadsheet of just over 4000 records. The spreadsheet has a "Model" field that contains both the model number and a model description, separated by a space. I would like to split this field into two different fields: "Model_Number" and "Model_Description". The...

If you view Query properties in design mode you will see a "Filter" property. When I put a WHERE statement in this section and click the "Apply Filter" button it works exactly as I anticipated, filtering out the records I want. Does anyone know the syntax to change this property in VBA...

Does anyone know how to filter data in a query in code? This is what I assumed would work but I am hitting some strange "Can't find the field" errors: Queries![MyQuery].Filter = stMyFilter I am creating an SQL string in stMyFilter based on selections the users make on the form. They then...

Anyone know how to reference a global variable as criteria for a query? I am currently using invisible text boxes on an intermediary form as criteria for my query and it works fine, but this solution seems inellegant and I'm looking for something a little smoother. I just need the correct...

Anyone know if it is possible to apply a filter to a control? Specifically, I want to reuse the same subform on multiple pages of a tab control, filtering the data in the subform according to criteria specified on each page of the tab control. Each page on the tab control is named according to...

Hi All! I am trying to create an updateable non-calculated field in a select query. Specifically, I want to create a Yes/No data type called "Fail". This is a multiple-user application so I can't solve the problem by using append and delete queries to modify records in a table. This has...