Search results
-
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()
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 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...