i did try the ASP...and it is what i want. Thank you!
but...it comes up with "enter code" which i do adn then nothing comes up. The headings "loan date, acct, name, etc." comes up but nothing else. LIke if there was nothing in the table.
i do see the button, it is pressed in. and this is in a data access page. just 2 days ago it the wizard came up and would let me choose from operations and navigation(which brings up another question, why won't it let me run a query or do all the things i can in a form).
I tried to create on my Data access page but it just appears on the page. It does not come up with the wizard or whatever. does someone know why?
thanks.
the field that holds the codes is called Status Code. On my table, it is a dropdown box that allows some to choose from it. All the other fields(vin, date, etc) i do not need for the report.
the fields in my database are:
date
name
acct
vin
year
make
model
status
rec date
On the report, I'm trying to get the totals and percentage(of the grand total)
The codes are N, Y, S, P.
The report would read as:
N # %
P # %
Y # %
S...
i have a database that shows the status of titles. i need a report that will group the totals and ONLY show the total amount of each code and percentage of total amt.
if anyone could help, i'd appreciate it
thanks.
i am creating this for someone who does not have access to Access and will not get access to it. The DAP will be for them so they can enter info into the database and the query/report so that they can search for codes w/o having to get into the database.
well... i need for someone to be able to run a query from it. i tried to add a cmd button to it like i did on a form but it doesn't have the option of running a query. I also need for the results to be put into a report.
With the query, i tried exporting it to another DAP and it worked, but...