Search results

I have a simple query to pull records in a range of serial numbers from a linked excel sheet. Both the access and the excel files are on a shared network server It works until I save it, then I get a numeric overflow error. once I open the query and change anything (and before I save it) it...

Thanks! I found that out a few days ago when I clicked on autoform button instead of the database button!:rolleyes: So on the Query phantom, I copied the query and deleted th suspect columns one by one until the phantom disapeared, then went in to the origenal, deleted and rewrote the...

I think there is a little miscomunication. I just want the dates I enter into the "enter parameter value" popup to apear on the form or report so when I print it out the paper has the date range on it, not to be able to enter the dates in a field on a form or report and those entries are used...

Where is the record source property? Sorry but really, I'm still ignorant on alot of access. I built the table, then built the form and linked the cells in the form to the table, so the info could be entered through the form. then the repair tech got into it and did something that changed how...

Thanks for the Reply, I thought it best to to put my query specific questions in the query forum instead of the report forum. And as the phantom popup question is not related to the date popup question,I posted over here. I have not re read the other post responses yet today, I was not able...

Thanks for the replies, Yes I have just enough knowledge to be frustrated at this point.finally following the rational behind how access works but iits still a black box to me. I need to read through the responses a bit more. Thanks again!

I'm building a sum query based a range query. The range query is all the fields I will put in the report and one Criteria on a date field of Between[Start Date]And[End Date]. When I run this query I only get teh Start date and end date popups The sum query is all expressions in the field...

got it working now and am building everything. I did a date range query then a second sum query on the ranged query and reported off the second query. I do have another Question: how do I include the dates from the date range boxes in the report?

Thanks for the reply I'm suming the number of instances each of three words apears from a drop down box in the form dumping to the table field and also summing a few checkboxes ("yes" results) int the records in the same table within a date range. I have the date range query working with all the...

=sum(IIf fields in a date range query for a report I need to build a report on a repair datebase i made the report need to be able to sum the fields in a date range can I do a date range query and sum the entries in the selected fields in the same query? or do I need to do the date range, then...