Search results

see if this worked

When I remove frm from the equation, it no longer prompts me for that; however, it still doesn't read from the Criteria form when its open with the dates filled in. Forms!Criteria.txtFromDate

Under the Query (this is how it is set up and that is what pops up when I open the query with the form open and dates filled in) Does that help? Field: Date Table: Project Table Sort: Ascending Show: ON Criteria: [Forms]![frmCriteria].[txtFromDate]

For some reason I can't zip any more, somone has removed my zip software. I compressed the file and gave it a zip extension. It worked on this end, but it still tells me Operations failed.

I'm trying to use a url to get it uploaded. However, it keeps telling me its an invalid file.

yes, the form is open with the correct dates and I even took everything out and retyped it slowly and it still did it. I assume I'm supposed to put that in the criteria section of the query field, correct?

OK, I got it to take dates in the Criteria Form (didn't link it to either query). However, when that form is open with the dates filled in and with Forms!frmCriteria.txtFromDate set in the query, when I open the query it prompts for Forms!frmCriteria.txtFromDate

Thanks for your patience. When I do that, and open the Criteria Form, it prompts me for a date before the form opens. So I can't fill it in on the form. Then when I type the dates it prompts me for, no records come up. What did I do wrong? I've only done this on one of the queries (for...

I'm sorry, I'm not sure how to do that for two queries. I've been using Access for years but that is new to me (I'm not a programmer). Any suggestions where to go for some help on that? Thank you.

I have been trying to do something that should be simple I'm sure, but I can't figure out what to do. I have two tables (one for Projects and one for Change Orders to those projects linked by Project number). I need to create one sales log report that will include both, BUT I need them both to...