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 IamaSherpa 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: *

  1. dridge

    CROSSTAB to REPORT

    I have a crosstab parameter query that prompts a date range (start & end), this works fine....I need the output in a report with the date ranges as column headings. I tried to make a report from the crosstab query and i could not. any help would be greatly appreciated.
  2. dridge

    CDATE Function?

    I am linked to a table with "INVDATE" not being a date/time field...it is a text 8 field. Can I still use a BETWEEN [Invdate Start] and [Invdate End] parameter query? Is there a way to convert the text field so the parameter query works correctly...My INVDATE field is mm/dd/yy...
  3. dridge

    Non-Date Parameter Query

    The Cdate function did not help me. Here is the SQL statement: SELECT CDate([INVDATE]) AS Expr1 FROM DPL WHERE (((CDate([INVDATE])) Between [Enter Start Date] And [Enter End Date])) WITH OWNERACCESS OPTION; My INVDATE is in the format mm/dd/yy (with slashes already in there).
  4. dridge

    Non-Date Parameter Query

    I am linked to a table with "INVDATE" not being a date/time field...it is a text 8 field. Can I still use a BETWEEN [Invdate] and [Invdate] parameter query? Is there a way to convert the text field so the parameter query works correctly...Any help would be greatly appreciated.
  5. dridge

    Newbie needs help with form design

    I'm sorry, I explained it wrong. I have a data base with COMPANY NAME (text 50) and PAID (yes/No) in it. When I'm designing my form, I have COMPANY NAME in a combo box. After I select a COMPANY NAME in my combo, I want to display the Paid field on the form.
  6. dridge

    Newbie..need help...form design

    I have a data base with COMPANY NAME in it. I have a Combo box on my form with company name in the drop-down. How can I display a Yes/No field on my form based on what I select on the COMPANY NAME selection...Any help would be greatly appreciated!!
  7. dridge

    Newbie needs help with form design

    I have a data base with COMPANY NAME in it. I have a Combo box on my form with company name in the drop-down. How can I display a Yes/No field on my form based on what I select on the COMPANY NAME selection...Any help would be greatly appreciated!!
  8. dridge

    ACCESS FORM DESIGN

    I have a data base with COMPANY NAME in it. I have a Combo box on my form with company name in the drop-down. How can I display a Yes/No field on my form based on what I select on the COMPANY NAME selection...Any help would be greatly appreciated!!

Part and Inventory Search

Back
Top