Can I enter data in a query/report?

[margt_a]

I have a query that pulls data from many tables to display project info, status, proposed values, etc. I want the user to be able to enter the total amount billed for each project, then print a monthly report that calculates percentage complete and totals.

My question is, where should the user enter the amt. billed? The numbers come from another database, so I have no need to store the info. Should I make a column for the info in the query and run the report from there, or can they enter it straight onto the report? Will a query store values that have no link to a table?

I haven't done anything like this before. Any guidance would be greatly appreciated.

Thanks!
Frazzled Margaret

 

[margt_a]

Enter data for query/report

The real problem here is that the billing info comes to me on paper from accounting, since the accounting software is compatible with nothing. Otherwise, I'd just pull in the table data. What I need is a monthly report for all projects, and I have no need to store the data in Access from month-to-month. I was looking for a way to run a spreadsheet-like report within access, and I don't think that's possible. I think my best bet will be to export the Query to Excel and just regenerate the info monthly.

Thanks for your help!