Search results for query: *

I will try it. Thanks!

I'm trying to set up my query where I can enter a part of a name and it searches by that. Here's what I put for criteria: Like "[Enter Name]*" So if I entered Bob, then all fields starting w/ BOb would come up. Bob Jones Bob Smith Bob Miller Thanks

Everything is working fine. I had to leave the format blank. I had it showing "None" when the memo field was null. I deleted that and now it shows full text. Problem is solved. Thanks for info!

I used First in my query but it still cut off at 255. The problem was I had it formatted to "None" in the report when it was blank. That is why it was cutting it off. Thanks for the help!

I have a question about the coding... what does this part do: (Cancel As Integer, FormatCount As Integer) Everything works. Just curious.

Changed something on it and it worked. Thanks for the help!

All my fields are in the intDealerNum Header (GroupHeader0). So I used this code in this section: Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) If Me.txtTotalDays > 1 Then Me.Detail.Visible = True Me.GroupHeader0.Visible = False Else Me.Detail.Visible = False...

Thanks, I will try what you had suggested about the format event.

No that isn't the case. Here's what my report shows now. Dealer TotalDelinq MinDay MaxDay TotalCost ------ ----------- ------ ------- --------- 1 4 93 302 4000.00 2 1 103 103 1000.00 3 1 93...

I put that in but it didn't do anything. I went back to design view and the control source was empty. In my query, I have an expression that gets Total Days. In the criteria, I have [Enter # of Days]. In the report, I have an unbound txt box to Count the number of accounts per Dealer. This...

I have a report that shows: Dlr, Count_of_Delinq, Min Days, Max Days It shows up fine. But what I'm trying to do is only show those with multiple counts.(leaving off the ones that have only 1 count.) I've tried coding, here's what i have: If txtTotalDays > 1 Then txtTotalDays.Visible =...

I am totaling all cost for different dealers. I have now 4 different categories. The way I have it now is: Each dealer has at least one acct, Each category is added up for each account giving me a total cost of the dealer for that category. But I am needing the 4 categories to be added up...

They are in both my query and report. The report is based on the query. "Group By" and "First" are in the Total line in the query. I will look at the stuff you provided. Thanks

yes it is. I do have a question though. I have it set in my query to "First". I tried to do Group By but only square boxes show up(and its not the border, its a small square box).

I created a table and then created a report from that table. It cuts it off at 255.

I am using Access 2000. I'll try creating a table.

I did have a memo field...but on my report it cut off the information at 255 characters. So it was pointless to have a memo datatype when it treats it like a textbox. If there is a way around that, please let me know. Thanks

I have no code yet. I didn't know how I could specify the amount of characters for the control.

I have 2 controls on my form that are for comments. txtComments txtComments2 My comment section was a memo datatype but I changed it to text. On my reports, my comment box(when it was memo) cuts off at 255, so I'm going to make 2 comment sections. I'm trying for this: When the txtComments...

I am having trouble setting up a query. I have created a query to grab records containing info from 2 tables. The following is what is that query: curGcost curGrefund curSCcost curSCrefund curCLcost curCLrefund dtmAll Expressions: Total Cost: Sum([curGcost]+[curSCcost]+[curCLcost]) 'this...