Sorry if this is a duplicate, but I tried lots of searches here. I can't seem to find my answer anywhere. I have 2 tables that I need to join by date and...

I have a database that have two fields: Tier and S Tier. There are different values in these fields (e.g. Tier:1, 2, 3, 4... S Tier: 1, 2, 3, NC, DME...)....

GOod day I have two queries pulling data from two tables, with criteria between start date and end date. .. I have a third query pulling those results...

Every Friday, I run an error report which searches for errors with an Audit_Date between last Friday (a week ago) and Thursday (the day before the report is...

I get a weird error message when I try to run a make table query, but yet the same query will work as a select query. I know the file isn't currupt, as I've...

After using the duplicate wizard, what is the next step? Do I manually select the records individually and manually delete each one while the query is...

I have a report that generates assignment sheets for exhibitors who have received booth assignments so that the orders can be updated (for various reasons,...

I am trying to provide a SQL query to the rowsource of a combobox. I am trying to use two tables to do this but am not sure how to go about it. The table...

I'm trying to create a make-table query that will group records by two fields. The fields, named "Left" and "Right," both contain 4-digit identification...

Beginner in Access 2007. Question related to queries: concatenante fields. Does the expression results show in forms? Also, pre-existing lookup data type...

I am using Microsft Access 2007 to email a form to individual email addresses so they can update their details and email it back to me. The form was created...

I sometimes need to find the largest or smallest value in a field. If I put two indexes on the same field, one in ascending order and one in descending...

How can I filter for results that contain the charcter "(" ? For example if my fields a A(2001) B(2004) C D(2055) E(2006)

I have a query that I use to sum groups of data... Works great.. However I want to perform a calculaton on the SumOfPayout... All I want to do is subtract 2...

I have not had this issue before with the old .mdb but with 2007 Access , when I am creating or editing a query in design mode, I click or drag only the...

Hi all, I have 2 tables. One holds account numbers. One holds invoices, linked to account numbers. Ive got a query to show the latest invoice for each...

Hi folks, Using Access 2007. I have a query (SQL below) in which I need to select only those records with distinct FamID's I'm pretty sure I need to use...

I'm trying to rewrite queries for better performance and am stuck on one. This is how it is written now: SELECT tbl_OrderParts.UniqueID,...

Hello, I am trying to create an IIF query field where if RtgGrp not equal NA or Non, the return Yes, otherwise return No. But it is not working. What is...

I have a set of Permitees 12,000+, who own one or more items 58,908 of a list of 29 items. Some Permitees are only allow to own 3 of these 29 items, others...