Search results

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

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

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

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

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

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?