Search results

yes, 893 is the correct count but it repeats with 893 for 5000 records? How can I just get the 893 returned, one record.

So, this seems to work: test: DCount("*","Query2","Field1<5") but it gives number of records that meet the <5 (893) but for 5000 records if repeats 893? How can I just see the count?

Will give it a try

That's what I was thinking. What would it look like looking for records <5 using DCount()?

Not sure where to start.

I have a query that has one field (number1) and I would like to retrieve the records that are less than 5. The table has about 5000 records. So, if say 500 records meet that criteria, I want just the count or how many records. Thanks.

Yes, thanks.

Wow, that's impressive. Thanks!

Any way to be prompted for the ReportName?

I have a form (test) and I would like to open a report (records) based on the record I'm in on my form. I would like to use a command button on my form. VBA please. Thanks.

That worked. Thanks!!

Doesn't work? Because of the text at the beginning?

I have the following in an unbound field, how can I force this to be 2 decimal places? ="+/- " & [Number1]

Got it. Thanks!

I think the conditional formatting might actually work better.

Yes but I have it on a command button that is doing some calculations too.

Does not work for me? If [sample] < 400 Or [sample] > 500 Then [sample].ForeColor = 858083 And [sample].FontWeight = 800 The font just remains black and not bold when I put them together.

Ok, changed it to FontWeight but I can't seem to get it to be bold and color. Only works, one or the other. [sample].FontWeight =700 (works) [sample].ForeColor = vbBlue (works) But not together?

How do I make a font both bold and a color? [sample].FontBold = True And [sample].ForeColor = vbBlue

What is the best way to state this? If [sample] < 400 Or [sample] > 500 Then sample.ForeColor = vbRed Else sample.ForeColor = vbGreen