Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: shirley35
  • Content: Threads
  • Order by date
  1. shirley35

    want to find records if in another group

    I'm looking for the right syntax or even if I'm doing this right. I want to find records with certain SIM numbers and when I find that group I only want the ones that also have other certain SIM numbers. What I have below errors out "near the keyword IF". Am I supposed to be doing a join...
  2. shirley35

    trying to exclude records

    I have 3 tables. One is a visit table. Visits have charges connected with them. The second is a charges table and one is a transactions table. Transactions are always connected to charges. The transactions table has payments and adjustments in two separate fields, in separate records. There...
  3. shirley35

    Want calendar icon for parameter from string date

    CR11 My database stores the date as 20090401 and I am trying to use that as a parameter in my record selection and want the user to use the calendar icon. If I just use the field as it is the user doesn't get the calendar and has to input 20090401. I converted it to a date with a formula and...
  4. shirley35

    best way to get yesterday's date to use in Where stmt

    I'm using SQL Server 2005. I found out after trying this that the SP wants the user to enter a date for AltStartDate but I just want it to assign a date itself (I would either assign it as today's date and subtract a day in the Where clause - or maybe it would be easier to assign it yesterday's...

Part and Inventory Search

Back
Top