Search results

Hi! I've got a table with IN that contains Customer ID etc.. In an other table I've got Customer ID and Customer name. Now I want to create a Query that displays Customer name next to its ID. Ball Blue 7124 Mike's Inc How will I do this?

Hi! Can I have a form (datum) that transmits the criteria to a query? Like the Form gives me [tre] and [fyra] In the criteria field in the query: Between #Forms![Datum]![tre]# And #Forms![Datum]![fyra]# / Smask

Hi! I'm trying to get my form to search between two dates and display all data that lies here. In my fist nive expression i wrote like this. With List7 .RowSource = "SELECT * FROM Datum WHERE [Datum] Between #Me.Start# And #Me.Slut#" End With :confused: :confused...

Hi! I want to do this: Select only [Kundnummer] then [kundnummer] is equal to 100 in a query. Have tried this (in the "field" field) but Access just complains. IIf ([Kundnummer] = 100, [Kundnummer], " ") / Smask

Hi! I'm making a form and want to locate a query. How will I do it? Are there any commands like this but for a query? Forms![frmLookup]![lbxLocationLookup] / Smask

Skips zeros! Hi! I've got a form that shows some data. This data can also be zero (0) and then I don't want to show it in my form. With List7 If .RowSource = "SELECT * FROM Urnaquery WHERE [Expr1]" > 0 Then .RowSource = "SELECT * FROM Urnaquery WHERE [Urna] Like '" & _...

Hi! How will I make my form start when you open my Access file? / Smask

Hi! I've got a table with Customer number and Customer name. Now I'm making a form that will show name if you type in number. Any suggestions? / Smask

Hi! I'm trying to figure how to make this work in my form. I want the form to jump to an empty record (after the last entry) when the form is open. Private Sub Form_Load() Me.RecordsetClone.FindFirst "Isnull([Subject]) And Isnull([Date])" Me.Bookmark = Me.RecordsetClone.Bookmark End Sub...

Hi! I've got a input form and wants that the date is set automatically. =Now() But this date isn't stored in any table. How will I get the form to store the date? / Smask

Hi! I finaly made it, almost! Now I've got my correct sorting, but one problem remains. I have a Query that sorts my indata. This quary is accessed by a report. In this report I'm trying to take [IN]-[OUT] but get the return; ERROR! I did it like this: =[SumAntalIN]-[SumAntalOut]...

Hi! Making a report that have three levels 1. Product 2. Color 3. Material 4. In stock I'm not able to make (4) to sum up all entries and display it as a total of that product with that color and material. I get all entries! How will I do to get just one total sum displayed? / Smask

Hi! I'm trying to make a small report of inventory. [Article] [Color] [Height] [In stock] ___ g_____ r_______t________3 __________________y________2 ___________________________5 ___________________________2 ___ a_____ y_______t________3 etc. In the "In stock" I've got "in" and "out"...

Hi! I'm a complete beginner at Access and I have a problem. I've got two tables one with "in" and one table with "out" from stock. I want to make a query that tell me the actual amount of goods on stock. I have four (five) variables: (¤Cutomer ID) ¤Product type ¤Material ¤Color ¤Number of...