Search results

  1. M

    Dcount with multiple criteria

    Thanks.... given solution worked well and I understood to use deliminator with string.
  2. M

    Dcount with multiple criteria

    Hi I have problem in DMax which i tried but no luck, could someone help me to solve this please. Rev# - Is a numeric field. JobNumber - Is a text field. Department - Is a text field. Sorry for the wrong subject. Thanks Ram
  3. M

    Dcount With Multiple Criteria

    Thanks Mr. Mile-O That worked well. Regards M
  4. M

    Dcount With Multiple Criteria

    Hi Mr. arnelgp Thanks for your time and suggestion, I got an Run-Time error '3464', Data type mismatch in criteria expression. The field ToUserID is a text field. Please advise..
  5. M

    Dcount With Multiple Criteria

    Hi Everyone... Good day, I have the below given Dcount code with multiple criteria and I wanted to add 1 more condition which I couldn't solve myself. Kindly help me to fix this. The Current Code CountMsg = DCount("*", "[F_Tbl_Msg]", "[ToUserID]='" & [TempVars]![TempUser] & "' And...
  6. M

    Look up a value from one table to another

    thanks for your hand, but as i mentioned before i am very new to access can you please modify the file which i have attached and give me so that i can know what exactly i have to do.
  7. M

    Look up a value from one table to another

    I have database with 2 tables in it, its my sample tables the 1 st table is Projects where i have 3 feilds the first one is serial no and the second one is Project where the data is unique and this is primary field and the third feild is having the project engineers name. The second table...
Back
Top Bottom