I have two tables, A-Table and B-Table. A-Table has Names(Text), Numbers(Num). B-Table has Names(Text), Numbers(Num). I want to replace all A-Table with Names...

Good Afternoon, I keep getting "You tried to execute a query that does not include the specified expression '(Max(.)) Between . And .' as part of an aggregate...

Hi all, I'm trying to figure out how to write an Iif Then statement in access 2007 for: iif columnZ = 10 then columnZ = A please help, SQL and query table...

Hello, I'm a beginner, so I don't know if this is possible. I have a query that is pulling data from a read-only table. The two fields that I'm using are a...

Could someone help me to extend this sql to include: 1. a count of txtsole where the field is a YES/NO field and I want a count of where the answer is YES 2....

I have the following SQL that selects the TOP 10 clients by percentage of sales. I want to be able to SELECT the TOP 20, TOP 40, TOP 60, etc.. by entering a...

I have a date with format 'yyyy mmmm'. I would like it left justified. The help says I can use ! but when I type '!yyyy mmmm', Access changes it to '!"yyyy...

I have a text field that contains both numbers and text. At the end of some of the data in this field , it has a partial date -- such as 12/24 - 01/23. ...

I have 6 tables that I have built 6 different queries on. Individually, these queries return the correct amount of records in the tables. Which is 80...

I am atempting to use the crosstab query to display a series of data across various dates, but can only get one value field of data to work. Is there a way...

I searched the discussion groups for the answer to what seems to be a simple question, but found nothing. I have a group by query with three...

I have two tables A & B, I need to check from B tables column 11 to find out if there is anything like the table A column 8. In column 11, it contains...

I am tracking the service on my equipment fleet with Access. The older equipment has a 12 month service interval and the newer a 24 month service interval. ...

PatientTable contains thousands of patient records. subform current record selection should for a given clinic ID, update the parent totalpatients text box...

I find myself using workarounds for this way too often. A little advice would be appreciated. I have Three tables. I want to delete all entries from TableA...

I have a query created with the query builder that has the Unique values properties set to Yes. I would like to be able to add a virtual field to the query...

I use this expression in the criteria in a Query. How can I modify it to obtain records for a 24 hour time period? At present it produces records for the...

I am trying to convert some MS Access queries to .net. These queries call other queies, that call other queries, etc., sometimes up to five levels deep. I am...

I am attempting to pull a random set of records using a Random Number and the Top Value function. The Top Value changes depending on the specific group I am...

How would the critera be wrote to get a greatest value? (Not greater than, but just the greatest - I don't want to see any other entries)