Search results

The first formula worked great! Thanks so much for you help!

Thanks I'll try it and let you know how it went

Hello All, I’m having a problem getting the correct value from a form. I have a table name CITY. Table: CITY Field(s): [City_ID] [City Name] 1 Boca Raton 2 West Palm Beach 3 Sunrise 4 Palm Bay My form uses the city table as a...

Say I have a simple report that is based off a query. The report looks like this [Name] [Result] Stewart Sold Steve Pending David Sold Shelly Sold The [Result] Field is a dropdown list where the user can choose either "Pending" or "Sold". I want to...

I have a report based on a query. My DCount syntax works if I don't put a criteria prompt in my query. Why is that? Can you use DCount in a query that requires a criteria prompt? Thanks for you help

Does not seem to work. I keep getting an error

Thanks, I'll give it a try!

I want to create a report that would calculate the number of leads given to a sales person against what they sold. For example, suppose I have a table named “appointments” with the following fields: [Appt No] [Rep Name] [Result] 1 Dave Sold 2...

It still does not work. Should I post a sample of the Database?

I tried it, it dosen't seem to be working

I want the data entry operator to be able to overide the default the[CallDate] Would I still be able to do this in Form or should I do the formula in Table?

Say I have two date fields in my table: [ApptDate] [CallDate] I want the default value for [CallDate] to be [ApptDate]+14 days. How can I do this in a table? Thanks For your help

Thanks for the quick response.. I'll try it!!!! Thanks so much again

Say I have a table with two fields [date] [source] The table is populated with the following information [date] [source] 8/1/2006 Website 8/1/2006 Newspaper 8/15/2006 Truck 8/17/2006 Website I want to have a report that will prompt for a date range and...

Can you creat a criteria for a report that is not based off a query?

I trying to find out what the syntax is to only show a single record in a report. I would like a pop-up to ask the person to enter a single record number for a report. It then would only show that record on the report and nothing else. Thanks for you help, Stew

thanks thanks for the info. I normally use and underscore sign with my fields. such as date_end. I didn't add that on my original post, because I didn't think it was important. I am always looking for better ways to name by fields, so the 5 character limit that you use is something that i will...

thank! wow thanks! it works great... This forumn is the best!

I'm creating a simple one table database. The table has only three fields (name, start date, end date). My question is can I have the end date calculate whatever the start dates is plus 90 days automatically within the table?