Search results

Thanks for the suggestions. Useful information. I had considered excluding but that population is even larger.

What is the best way to add criteria when there are a lot of them? For example, I have a field called [site_cd]. I want the query to only return records for certain groups. However, I have about 50 groups. Is there a better way to accomplish this than a long string of "or Like" such as "Like...

The name of the field that I count all of them is [SiteCount]. When I use this in the expression, I get prompted to enter a value for this field. In reality I want it to use the [SiteCount] number times the the number of units the site has.

vbaInet - I don't think you fully read my question. I already did what you replied. My questions is how to multiply the count results by a number depending on how many units the particular site has. For example if [site_cd] is A, then I would want the [=Count(*)] to be multiplied by 2. But...

I have a report (IRs_Generated) based on a query. On the report I have fields [site_cd] and [=Count(*)] in the header. This way I get a total count of the records returned from the query for each site. However, I want to report the results based on the number of units at each site. Some...

What I have tried is in my original post.

I am not familiar with the DateAdd() function and after reviewing your link I am still not sure how to use it with what I am trying to accomplish. Can you give me an example how I could use it with what I am trying to do?

I have a query for a report hitting a SQL database. One of the fields is Date-Time in this format [11/16/2011 5:46:00 PM]. I have a form with a combo box with simple numbers 1-10. In the Date-Time field of my query I have the following >Date()-[Forms]![frm_Main]![cboMinusDays] This way I can...

I am using MS Access 2007. Traditionally, Conditional Formatting has been limited to 3 conditions. Is there a way to have more? I have a report with a Priority Code field. Priority x1xx, x2xx and x3xx. I want all of the x1xx (e.g. I1a, O1ba, I1cd, etc.) to show red with yellow text and...

I have a number field in the format 00-0000 on a form and associated table. The first 2 digits represent the year and the last 4 are a numerical sequence. When I designed the database I did not imagine exceeding 9999 in a year, however we did. So I increased the format length to 00-00000...

The query returns 2 records. I don't have access to the database itself, only through linking tables. It appears that a new record is entered into the SQL database when the Due Date is set and another record is entered when someone makes the assignment. So on my report I what to display who...

I have a query based on a linked table associated with an SQL database. The query is looking for the following. YR CR_No UserID Signature_Type (ASSIGN or DUEDATE) Signature_Date I want the query to return all of this data in one record however when I run the query one record shows the UserID...

Great. Thanks for the info. Jim

Just to clarify, would this go into the Control Source field on the Property Sheet for the field?

I have a report that is based on a query using Linked Tables to an SQL database. One of my fields [MR] returns -1 for Yes and 0 for No. I want my report to show Yes and No not -1 and 0. How can I make the report do this? Thanks, Jim

vbaInetv - No luck. The first query which pulls the Memo fields has all the characters in the "Description" field. However the second query which has the Total fields cuts off the referenced Memo field text to 255 characters. I have the "Description" field in the second query set to "First"...

Thanks. I'll give that a try tomorrow. Do you think this would speed up the query? When I run any query that uses Total in a field it seems to really slow down the query. If not, do you have any suggestions on how to speed it up? As always, I appreciate the help. Jim

vbaInet - I thought the info on the page you referenced was the answer but was wrong. This all started when I added Total on one of my fields so I was sure Aggregation was the issue. However I set my 2 memo fields to "First" instead of Group and ran the query. The 2 memo fields are still...

The query with the problem is limiting characters to 255 for the Description field. The query without the problem shows all the characters in the description field. This field is unlimited in the SQL Database so it's like a Memo field.

I am using Access 2007. I am quering an SQL database so the tables are linked. I have 2 queries. One query limits the characters in the "description" field but the other does not. I verified it's the query not the report associated with the queries. The main difference in the queries is the...