Recent content by Brand-X
-
B
Concatenate?
If anyone knows Excel, I'm wondering if there is something like the concatenate function in Access. if you don't know Excel, Concatenate takes various values and strings them together (i.e. Concatenate(a,b,c) would give you abc). Just wondering if I can find anything like this -
B
Adding only certain data
I'm just wondering if there's a way for me to do this. I am putting together a timeline for a particular story I'm writing, and so I have a table consisting of dates, and events. In addition though, I need to have two types of data, as there are to be 2 separate timelines. Basically on my... -
B
Variable pictures?
is there a way to possibly do the following? You have a small icon to represent a certain piece of data, lets say we have a picture of a bird and a picture of a turtle. On a report, could one set up a function to display a bird if a piece of data was say, 1, and a turtle if it were 0? Data A... -
B
Very simple, And() / OR()
Never mind on the and/or thing, figured it out thanks anyways Still looking for expression list though -Brandon -
B
Very simple, And() / OR()
Are there any AND() or OR() functions in access? Basically I'm looking to create a value in an if statement, I'm looking for it to return true if either of the following are true: - Value A = 2 - Value A = 1 and Value B = 2 This is a bit simplified from the actual problem, but a question none... -
B
Looking up values
Gah!... How about using DLookup? I've heard that has a similar function but never figured it out myself -Brandon -
B
Looking up values
Hmm... Would there be a way to do this in a VLOOKUP sort of fasion? Say if a nested IIF became to complex? [i.e. if you decided to assign +'s and -'s aswell (A+, A, A-, B+, etc.)] would there be another way???? -Brandon -
B
Looking up value in table?
Hmm, well I've taken a look at the DLookup stuff on the net *makes guesture of plane going over own head*, and as for the 2nd option presented here, I can't say I really understand it. *Sigh* I might just have to go back to Excel and see if I can do it there, Excel I'm pretty good with, and... -
B
Looking up value in table?
Is that a "No it can't be done?" :-) -Brandon -
B
Looking up value in table?
Hey I'm looking to see if there is a function similar to vlookup from excel in access? I have a query set where I'd like it to look up [value a] on [table b] and return the result from the same row as [value a] in [table b] but from a different column (hmm, I think that was poorly said, maybe...