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 Chriss Miller 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. sofeeyah

    Field in Query Expression Displaying Number on Report

    ok i think i have a problem with my tables and relationships...am i on the right path...so do i create a new field StateID on my invoice table an setup a relationship that links: invoice.stateid lustates.stateid then a combo box form field on my form: invoice.states then in my query have the...
  2. sofeeyah

    Field in Query Expression Displaying Number on Report

    I am getting mismatch type expression what does that mean? below is the sql: SELECT IIf(IsNull([fnom]),"",[fnom] & " " & [lnom] & Chr(13)+Chr(10)) & IIf(IsNull([dept]),"",[dept] & Chr(13)+Chr(10)) & IIf(IsNull([luorg]),"",[luorg] & Chr(13)+Chr(10)) & IIf(IsNull([add1]),"",[add1] &...
  3. sofeeyah

    Field in Query Expression Displaying Number on Report

    ok outer join??? i have not totally grasped the outer join inner join concepts... so let me see if i understand 1) outer join state table ->>> invoice table statename field ->>>>> state combo box field 2) query expression do not use "states" field from "invoice" table but "statename" field...
  4. sofeeyah

    Field in Query Expression Displaying Number on Report

    Using Access 2007 I have a field, "state" on a table "invoice". Have a data entry form "invoices" which has a combo box field "states" that points to the state table giving the user a list to choose from. I have a report that generates an invoice. This report is based on a query that pulls...
  5. sofeeyah

    1 Form - 3 Tables

    I have one table "Contracts" that has a one-many relationship with a table, "Address" and it also has a one-many relationship with another table, "Invoice". Since my post, I built a form from scratch. Started with a form based on the table "Contracts" and inserted two subforms, based on the...
  6. sofeeyah

    1 Form - 3 Tables

    I have three tables all with a common field linking them relationally and i need to design a form that incorporates fields from all three forms how do I do that? tried the wizard and it did not allow me to have a sub form and access did something really weird, the form just appeared in form view...

Part and Inventory Search

Back
Top