Search results

  1. D

    switch vs nested iif

    ok. I need serious help here. I use Access 2007. I have what I thought should not be a complex query but I cannot get the query right. I have searched this forum for answers on select case and switch and honestly have no clue how to do this. here is what I need to happen:(not correct...
  2. D

    Need help with database concept

    Hello. I am designing a new database (Access 2003). The objective of the database is to integrate data from separate data sources. The primary data source will be where I want to pull the correct data elements. The secondary source will the be data that needs to integrate into the primary. I...
  3. D

    Need expert opinions

    Hello all. I finally figured out (at least I think) all I need to really begin using my database to it's fullest. Now I am trying to decide how to design a form that will display a multitude of information from more than three tables. Here is what I need your opinion on. I want to display...
  4. D

    vb script needed to do multiple tasks

    Hello. I have three tables: tblMaster; tblTransformation and tblhistory. The tblMaster table has all of the master records that we report off of. The date fields in the master table contain our baseline dates. The tblTransformation table has the same fields and records but the date fields...
  5. D

    Help with append query criteria

    Hello. Can you help me figure out how to get this append query to show data that is null? I have three tables: tblbasetable, tbltransformationtable and tblhistory. The query looks at tblbasetable joined to the tbltransformationtable. It appends to the tblhistory table. The criteria is...
  6. D

    Database design assistance needed

    Hello Everyone! I am in desperate need of assistance. I am trying to create a database to track date changes to 8 fields. I think I am making this harder than it needs to be. I am attaching a spreadsheet with the fields that I need to track. BAsically, I will receive a spreadsheet that...
  7. D

    Database design and concept

    Hello again. This site has been so instrumental in my last project that I am been asked to do another. And once again, I need your help. Here's the gist: I need to build a database that tracks changes to a table. Basically the steps would look something like this: 1. import spreadsheet...
  8. D

    nested if

    thanks again to all who helped earlier. The if statment (Expr3: IIf(IsNull([document received]),"No","Yes") worked great! Now I need a nested if statement. It needs to read if doctype equals result and if document received isnotnull, then yes else no how would that look?
  9. D

    if statement

    I have a documents table with a date field titled "datereceived". I have a second table with a checkbox field that indicates if the document has been received. (we need to track these metrics) I need an if statment that says if date received is null, then no in checkbox field, else yes...
  10. D

    add new entry form

    I have a form that is used to enter data. It opens to a blank form by default. The form is based on one table. On this form I have an entered field. Is it possible to have some type of control that when a date is entered in this field and checkbox field in another table gets checked?
  11. D

    help with calculating fields

    hello. first...this forum is excellent. This site has helped me tremendously. Here's what I need help with.... I have a database that is used to track: 1. an entire UAT life cycle 2. The documents that are submitted for the UAT testing I have two tables: the first table trackes the...
Back
Top Bottom