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 finaly got it to work. With List7 .RowSource = "SELECT * FROM Datum WHERE [Datum] Between Forms![Datum]![Start] And Forms![Datum]![Slut]" .Requery End With / 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...

You really got a point! Didn't think at all of using criteria. Thanks / Smask

HI! Kundnummer is a value that I get from a table and now I only want Kundnummer if it is equal to 100. The whole thing I want my query to do is: From ny table Indata I want to display [ett], [Två],[Tre] if [Kundnummer] is equal to 100. (Kundnummer = Customer ID, so every customer has it...

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

Thanks! Working with charm! Eller vad det nu man säger!? / 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! Thank you wery much! Tack så jättemycket! / 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...

I put the Hi, thanks for the quick reply! It works perfectly! / Smask

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

Thanks, but I'm to slow to get it. I've made a groupe based report, but my prob is still there! [1] _____[2] ____________[3] _____________________[Here I want the sum of IN - OUT if 1,2 and 3 are meet] I use "if same hide" but i doesn't work with the numbers, so I get numbers for all data...

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