Search results

  1. W

    Please Help - Sorry If Duplicate Request

    I have a master table and table that is a subset of the master. I want to use the subset table to delete those same records in the master table. For the life of me, I cannot figure this out. I do not know VBS/SQL etc and would need a solution that is simple to execute. Thanks, Wayne
  2. W

    Update Queries

    I have a table that has many job classifications. I want to keep 4 and change all others to miscellaneous. How do I keep four and change the rest? I've been monkeying around with the update query feature but am unable to figure this one out. Please help. Wayne
  3. W

    Need Help With Table Relationships

    I have two tables. The first table has two fields; Implementer and Originator names. The second table is roster of employee names with their job class, location, and division. I want to perform a query to find both the Implementer's and Originators job class, location, and division. I have...
  4. W

    Create Single Field Combining Two Diferent Fiels from A Query

    This is for simplicity sake. I have two queries. Both single record queries with one field in each. Query 1 Field is a File ID stored as text in one format (CCYYMMDD- <AnyText>) and Query 2 field is also a File ID stored as text but in an entirely different format. I want to combine these...
  5. W

    Queries and Expressions Part Deux

    I have a text field with values of either "2" or "M" and I'll call this [Field1]. Another field has numeric values including some with null values and I'll call this [Field2]. There are also three other text fields with some having empty strings and I'll call these [Field 3], [Field 4], and...
  6. W

    Queries, Expressions and Text Fields

    Hello and thank you in advance for your assistance in helping me resolve a problem I am encountering in an Access 2010 query. I have created a query where a field uses this expression -- Source: IIf([Field 1]<>"" Or [Field 2]<>"","Answer A","Answer B") and this works fine. Note: Some of the...
  7. W

    Converting MS Excel Database to Access

    I've nearly completed a conversion from an Excel database to an Access one as I've got only one more field to convert. However, this one seems to be the trickiest to figure out. I cannot convert this Excel expression to one that works in Access. Please help. Excel...
  8. W

    Noob To Access 2010

    I'm fairly green at using MS Access...love the application and want to use it more...just need to know more. W
Back
Top Bottom