Search results for query: *

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...

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] &...

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...

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...

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...

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...