Search results

  1. M

    Query to group like words

    Hello I have a text box in my database that i would like to be about to search and group the text field if is had similar. for Example if I had a record like" called in puking" and "Up all night puking", I'd like the query to recognize "puking" (without me specifically telling it to look for...
  2. M

    Variables and decimal places

    Hello I have a number(as single) that is calculated an the back side of my program, it's then displayed on a message box. I want this number to display with 2 decimal places only how can I do this?
  3. M

    Close a form from another form

    Hello I'm trying to close a form when another form is exited. I'm stumped please help. Mark
  4. M

    Row info split

    Hello I have an execl spread sheet (un-normalized) I need to import in to an access db. Most info goes in fine however the first and last names in the excel sheet are grouped under one column separated by a ",". I have in the DB a separate column for first and last name. I need to figure out...
  5. M

    Is this possible

    I'm working with this query SELECT EmpInfo.LoginID, EmpInfo.LName, EmpInfo.Fname, EmpInfo.Dept, Min(Sicktrack.[Sick Date]) AS LastDaySick, EmpInfo.Sup, EmpInfo.HireDate FROM EmpInfo LEFT JOIN Sicktrack ON EmpInfo.LoginID = Sicktrack.LoginID GROUP BY EmpInfo.LoginID, EmpInfo.LName...
  6. M

    Sub Form passing question answer to query/form

    I've searched for this and can't seem to ask the right question. I have a lookup form with a subform that pulls employee info. If you double click on the employee record, it launchs a form, before the form loads it's asks for the Emp #, this question is coming from the Query used for the record...
Back
Top Bottom