Search results

Are you using the same symbols in your input mask?

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

Finally got this to work, we queried the query and then put the criteria in and it worked. thanks.

Any ideas I can try?

On this same query, now we want to only return the "Level" personnel. Is it possible to query an expression? I can't get it to work. I have tried in the criteria to put "is not null", it returns no results or "Level 1" etc., but it won't run on the expression. Ideas?

I had caught the extra paren, however, it is still not updateable.

And the record set is still not updateable. Any ideas?

I am getting the Syntax error in FROM clause

I created all the tables and should be able to edit any of them. I am the original creator of the database. Why would this be happening?

I've tried and tried to set up the cascading combo, but obviously keep doing something wrong. Do I need a DatasheetResults type table to tie everything together? Or can I just skip that and allow it to do it in the form? What is the most efficient way? thanks.

Ok, so now how do I figure out which one and how to fix it? Thanks!

Here is what I have: SELECT tblClient.ID, tblClient.[First Name], tblClient.[Last Name], tblClient.Construction, tblClient.ZIP, tblZIP.City, tblZIP.[Protection Class], tblZIP.Territory, tblPremiumGroup.[Premium Group] FROM (tblZIP INNER JOIN tblClient ON tblZIP.[ZIP Code] = tblClient.ZIP) INNER...

Well, it is possible that I don't have things set up the most efficient way? I am still in the learning mode ... here is what I have ... three tables ... one Client Tbl, one ZIP code Tbl and one Premium Group tbl.

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

Works great, thank you!

Thanks for your post, however I don't want to count the "yes", I want to total the sales for the "yes" individuals.

It is a yes/no field, but I need to show all fields and only the sum for the Yes. Make sense?

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?

You're exactly right in your observations! We finally got this to work, thanks for all your input!