Recent content by accessewbie

Leslie, Wow I can't say thank you enough - that works perfectly. I've not heard about using IN within an IF statement. Where do I read more about this? I think I got confused using the OR command. The statement makes sense - still just a little puzzled. I want to fully understand how to put...

Thanks for the example of how Nested If statements should appear - however, that's where I struggle - somehow I'm not putting the information in the right place as you can see. There are actually other choices besides YES or NO. If the user chooses N/A or the field is blank then I want it to...

I've been struggling with a statement I want to create so it can eliminate manual work. I've had to create an audit database. I have the following fields: Customer Ops Center (combo box if that matters where the user can choose Global or North America - I might add more at a later date) North...

Now I guess I am being greedy by asking another question. We all make typos and I know that will be a problem for my team. So is there a way to have an error message or a line to read "location not found" if what they type in the form doesn't match up to the table? I first thought it would be...

I think I understand the logic behind this all!! The user inputs into the form I made. Then they run the query which looks into the original table (Locations) and finds the match. It works and I thank you for your patience. Now I have to ask how do I go about the part where you state...

Let me just say I truly appreciate your patience. I am really learning here. So I read your suggestions and here's my comments. The simplest way to build the list would be to create a table to contain it, and a continuous form to enter the values you want. So I created a form based off my...

Could you lead me in the direction of any useful reading material or site to help me out? Your answer is helpful, but I'm not really sure where to start or what to do. I have the table but at a loss on beginning the form part.

I need help identifying the best way to get the results I need. I have a table: it has a field labeled Customer Location and another field labeled Support Location. Basically we want our users to be prompted for the Customer Location and then it finds the match in the table to pull up the...

I created several data access pages and linked to them through our intranet and they were working fine until recently. Now when a user clicks the link all the text pops up; however, the the standard graphics (like the next arrows to move to a new record, sort descending, etc) show as a big X -...

Thanks that works perfectly. So I went in and added my graph and used the option to preview graph. I couldn't see my data but only sample data in the report. So I used the Help on office and it says to use the Print Preview function (or open and close the report) to view the actual data...

Yes, There are several hundred records. And it counts every customer in Canada that shows a win status, a loss status, a pending decision status, etc. Then it does the same for EMEA, North West, or any other region there may be. Then it totals all for each region.

Okay I made up some data and only used the fields that I would be concerned with. Customer Region Category Status Cust 1 Canada Mid-Market Loss Cust 2 EMEA Corporate Pending The report I built looks something like this (based on the data) using this formula...

Could someone possibly help me modify the formulas I had in the report to work in the query I posted above? Your help is greatly apperciated. Thanks!

Okay I looked in Design view of the table (Data Type says Text) and checked the lookup tab and I do have the Display Control as Combo Box, Row Source Type as Value List, and then the list of regions on Row Source (for Region & Status). Is this not a good idea? I have these b/c the team often...

Okay I think I have gone backwards. I have a table with the following fields: TABLE Customer Region - (drop down with canada, north central, west, east, etc.) Status - (drop down with win, loss, pending decision, etc). Writer Comments (Other informational fields) REPORT! What I did was create...