Search results

Hi all! In my table, I am trying to create an input mask for the telephone number. I am using !\(999") "000\-0000;0;_ The ! is supposed to make it display right to left instead of left to right correct? With the 999 being nonrequired, if I enter the phone number 555-1212 ... it still...

Hi all! Seems like my problems always deal with relationships!! Anyway, I am working on another project too, have a table with some client information, first name, last name, address, and zip. Well, got it to work based on the ZIP, it populates the protection class and territory # (this is a...

I am trying to create a database with for clients that have a first name last name field and also they will have a state and location field ... however, I want it to lookup, if I pick a state, only show me the locations available in that state (there are over 100 locations for 3 states) ... how...

Can this be done? I have a report with names, if they attended a seminar and sales totals. I need to show all names, but only need to total sales for those who attended the seminar. I tried using Iif[seminar]="yes", sum([total sales]) but am not having any luck. Any ideas?

HELP!! :-) Working on a deadline and this query won't work. Hopefully someone can see something that is obviously. Different criteria apply to different levels . . . any ideas of different OR operator to make this work or do you see something else obvious? Levels: (IIf([SumofMth Life...

Is it possible to sum Iif statements. I have been working on a project that has several Iif statements, i.e. for bonuses, if # is greater than 0, 10, if less, 0 . . . now I need to sum the Iifs, and so far not having any luck. Any suggestions? Thanks!

What I would like to do in my report as opposed to building a ton of queries is this . . . I have several columns that rate classes, for example, Excellent, Good, Fair, Poor are drop downs to choose from. In my report, I would like to total that column which I can do =Count([Value]) . . . but I...

At the risk of showing my stupidity in Access, is it possible to record a macro by recording keystrokes or do you have to know code in Access? I have a query that has a column whereby everyone needs assigned to a group randomly. I have the column as a lookup but rather than going through...