Search results

well since the text box has both dates, didn't know what to name it and the criteria in the query refers to both begdate and enddate.

Coach, I tried it as a report with text box as you said, it works except does not display the dates on the report. Just shows #Name puzzled also, why use, or why it works using [Forms]![FrmDates] when I'm using a report (RptInvoice) instead ? I can live with using a report. I'll just have to...

Thanks coach. Makes sense - I will try tomorrow. bad sinus prob today so I don't put any criteria in the query at all using what you gave ?

for the run button docmd.openquery "QryInvTotes", AcViewNormal End Sub I tried addin Me.Refresh after the docmd line but made no difference I used the unbound so I could make the form look like a report to print plus I want the begin and end dates to appear for print also Mostly, I had no...

HAVING ((TblInvoice.date) Between [Forms]![FrmDates].[begdate] And [Forms]![FrmDates].[enddate]); tried this, WITHOUT any of the 'Like' statements in the other fields. works but pops up in data sheet view.

try this one

I ONLY want to search on the date field 'edate' (renamed it) then it populate the other 8 fields in the form based on the date range criteria I do not want it to prompt any of the other 8. I will try to do a screenshot of the form. ok, how do you paste an image in here ?

Yes, I have a form with beginning and ending date text boxes, unbound, then I have the 8 fields I am trying to populate from the query based on the dates input. I tried doing this with the date ranges in an unbound main form and the 8 populated fields in a sub form last night. When I open the...

Am I going about what I'm trying to do all wrong ?

I have tried = but each field still prompts What I am trying to do is populate a form / report based on beginning and ending dates. It has to be something other than 'Like' but can't seem to come up with it. As I said, I can take the whole Like statements out and when I run it from the form...

Thanks - I thought of that last night and changed it to edate

Geez, I hate to have to ask this but... Using a search form with beginning date and ending dates as criteria. Trying to populate 8 text boxes from the results. In the query, I am using a Between & And statement on the date. In the other 8 fields, using a Like statement. The query works without...

Well, still can't get the 'round up' on odd plus result but NOT on negative results. This is what I have laborously come up with that works for everything else. Only way I could figure was to use different expressions. Can't figure how to put them together, which isn't necessary anyway. * The...

sorry my bad

Did you figure how I can round up on the positive odd results ?

did you figure out how I can round up on the positive odd results ?

Yessiree!!! Of course, she could be my granddaughter but she's over 21! :D Well, maybe young daughter.

I want to come out your way and see if you can get me a round with Natalie Gulbis. I would love to play around with her! Or is that a round ?

Actually, one tournament that I play in is Friday, Saturday, and Sunday in Lake Lure, NC. This guy does little else but organize and run golf tournaments. The point system we play is pretty neat. 2 man teams. Then they have a blind draw for foursome teams each day. Rule is no player can help...

Correct Paul. This is for a golf scoring program I am trying to do for a guy that runs a large tournament. It is scored on a point system and players points needed each day are adjusted by what they score the previous day. If a player needs to score 16 points on Friday and he scores 20, then...