
July 30th, 2003, 06:26 PM
|
|
Junior Member
|
|
Join Date: Jul 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Access 2000 Data Access Page ISSUES!
HELP!!!
I have 2 issues with my data access page. I have created a parameter query that works fine but when I go to my data access page the parameter query box does not look anything like it does in the query. The page parameter box is this huge box that is prompting you for a value and next to that it gives the name [Enter Manager Name]. I want this parameter box to look the way it does when I run the query!!
The other issue that I am having is that in this same query I have 2 fields in which I am calculating how long it to get an id and how long a person had the id. I am using 3 different date/time fields to calculate the other 2 fields. The 2 fields have a short time format. When I create my page the 2 fields are not in short time format they are in decimal format. Is there anyway to change the format to short time? 
|