Search results

Hi, I have the following function: Function GetFiscalYear(ByVal x As Variant) If x < DateSerial(Year(x), FMonthStart, FDayStart) Then GetFiscalYear = Year(x) - FYearOffset - 1 Else GetFiscalYear = Year(x) - FYearOffset End If End Function I call on the...

Hi, I want to be able to select multiple values from a form and then run a query from those values. I read through some posts and learned I cannot use a combo box, that I have to use a list box. I have no idea what to do next besides create the list box. I have a table of Plants that I want...

Hi, I am trying to use a dlookup to return the price of an item that meets two criteria. This is what I came up with, but it doesn't work. The part after the AND works by itself, but when I combine the two I either get a #Error or no values that meet the criteria. Any suggestions? I can...

Hi, I have a table with a field, [Product]. The Product data comes in the form, # Description. Examples: 00100 Strawberry, 001234 Kiwi, 012345 Apple The info I want to pull from that field is the 100, 1234 and 12345, then I want to add on three 000 at the end, so the final result is 100000...

Hi, I have a reference table that has a Division field and a Item field which lists all possible items I sell and what division they fall into. example below: Div Item Cars 100 Cars 101 Bikes 200 Bikes 201 I have another table that has the item sold [ItemNo], quantity...

Hi, I have a field that has data in the format of ##LLLNLL. ex) 08NOV7NY I call on that field in a query and try to pull out the last two letters for the location. So I use the code, Location: Right([Code], 2) and that seems to work. However sometimes the user just puts the date in...

Hi, I have a field called [Item] that I am pulling from a linked Excel table where multiple people are entering data over multiple years. The Item is a string of numbers of varying lengths and values. ex) 636, 188880921 I call on [Item] in a query --> [ItemNo]:[Item] & "000" and add three...

Hi, I have a query in which I am pulling from another table. On the table I have a field called Tag, which consists of data in the form of a combo date/place. Ex) 29OCT7NY date = 10/29/2007; place = NY When I call on the Tag field in my query, I only want the date portion. So, I used the...