|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 1st, 2005, 12:59 PM
|
|||
|
|||
Setting a critera
If I set the [enter date][end date] criteria in a query and would like to
print the report it is asking me for every customer [Enter date] [end date]. I just wanted to give a criteria for display items in a period of time for all customers. Why do I have to enter it for each record? I tried it with a [enter customer ID] criteria and it's the same. 
|
|
#2
March 1st, 2005, 02:31 PM
|
|||
|
|||
|
If you are asked this over and over, I expect you are using the parameter
prompts as the Record Source of a subreport. Consider abandoning all parameter prompts in favor of values from controls on forms. -- Duane Hookom MS Access MVP -- "Amateur" wrote in message ... If I set the [enter date][end date] criteria in a query and would like to print the report it is asking me for every customer [Enter date] [end date]. I just wanted to give a criteria for display items in a period of time for all customers. Why do I have to enter it for each record? I tried it with a [enter customer ID] criteria and it's the same.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Setting Table Relationships- Why? | el zorro | Database Design | 4 | November 8th, 2004 10:29 PM |
| How do I change the default setting concerning line spacing? | disseminatethis | General Discussion | 2 | October 1st, 2004 07:47 PM |
| Setting calendar hours unique to calendar owner | Linda | Calendar | 2 | September 21st, 2004 07:01 PM |
| Savings setting on Excel autosave | Ralph J. hayes | Worksheet Functions | 1 | June 22nd, 2004 01:22 AM |
Linear Mode
