Hi, We receive an excel workbook of information from an outside source. Within this table the customer may have several record lines assigned to their...

Hi, I am trying to set minimum fees in a query from which I print a report. The management fee for a type"10" customer cannot be lower than $25. The...

Hi, There are many queries built into our database. I changed one of the fields from Text to Yes/NO. Is there any way to conduct a search to find out how...

Hi, I have created a table where the value is Yes/No - text with default as No. I have a query in which I am trying to bring back only the "Yes", but both...

Hi, I created a query, and it seems to work fine and I am pulling data from it to populate three reports. But, there is a weird thing that happens. When I...

Seen this out here before, but I have never seen an answer. What is this. I have entered all of the criteria for a query, and it opens up, but when I...

Hello, I have a query that pulls back data through a SQL connection from another data base that I do not control where the values are shown as two decimals...

Hi, I just had to fix a query my boss was writing. I guessed the answer correctly, but I really don't know why it is so. There were two query items with...

Hi, I have a table with two columns where the value may have changed and may not have changed - for example Group 5 to Group 10. I want to query so that I...

Hi, I am trying to creat a query where one side of the relationship is to be changed from Mid GC to GC. When I create the new relationship I cannot delete...

Hi, I have a table with numbers that have -000 at the end and I would like to remove that. Example 01028632-000 to 01028632 Can this be done?

Hi, Thanks in advance for tyring to help me. Maybe I could have been more clear about what I am trying to do, but I have posted before without a...

Hi, This should be simple, but I am still pretty new at this. I have a main table in which each record has a unique identifier (Policy No.) and each record...

I have a table with multiple customers each identified by a policy number. Each is also assigned one of 20 HMOs. They have had the chance to change HMOs. I...

What does this expression do in the query? Thanks BLANK-C" Or Is Null

Hi, At the end of my SQL Query I try to put the information in policy order. I get this error message: Syntax error (missing operator) in query expression...

Hi, I inherited the following expression, which is supposed to assign a minimum fee of $25 to all customers in Project 10 and a mimimum fee of $75 to all...

I created a db that tracks original, actual and discounted yearly numbers for each deals. I capture the numbers through a continuous subform. Deal Actuals ...

By using the first tip you offered, I am now able to get the data for either year and type out through crosstab queries. Now I am having difficulty merging...

I've read all of the questions and answers on the use of a custom form to set the criteria for a parameter query. I sounds simple but when I try to run my...