I have the following expression: Expr1: IIf(="Yes",*0.15,IIf(="Yes New",,IIf(="No",0))) The first part of the expression works when SCHW ADV NETWORK New...

hey everyone, i know it is a silly question but i am missing the most critical part about it... i have two tables "newest" and "removed". they both have two...

Hello, If someone could help me... i'm not very good at queries... I have a table with say 10 different columns, but i'm interested in just 2... Column 1 is...

I have a query in my database which includes the following fields from various tables: orderID stockID qty price stockLevel reorderLevel However I cant figure...

I have the following query: SELECT tblAMUWork.AMUWrkID, tblAMUWork.DateRcd, tblAMUWork.TypeOfWork, tblAMUWork.MISNumber, tblAMUWork.RptName,...

Hello All I have a query based on 2 tables = and . Essentially, contains standing data (like staff names, hourly rates etc) and contains monthly data - this...

I'm not sure how I would set the sort criteria for this situation; any help you can give me is appreciated. My contract numbers in my table are always 13...

I have been having this strange occurence on one of my relationship table - not frequently but 2 times is enough for me. Apparently the Autonumber seems to...

I need to use an expression in query to change the color of the result according to status. Example: if the date of manufacture exceeds 60 days form today...

I have a table with times recorded for various events for each record. Some are null. I am trying to create a query to select the latest time. An...

I have several tables that store data captured on a single form (and subforms). Basically, it is a form that I use to record activities. The form has a...

Hello, I am trying to create a query that updates several tables based on a single user input. First, the user is going to import different sets of data into...

I may have asked this question last week, but I can't find my post and I don't have anything in my notes, which I normally take, so I apologize if this is a...

I have a combo box that when clicked provided a list of names (duplicates too which is another issue). When clicked an after update macro prompts to open a...

I create an order status table for my division each week by running queries on corporate's systems. The field names are always the same, and there lies my...

Hello: I created an XTAB query that shows the class status for each class we taught this year. The query works perfectly, however, when I use the wizard to...

I have two tables - tblPeople and tblBooking. Referential Integrity is set from tblPeople to tblBooking on the Client_ID field, which is an AutoNumber data...

Hi all, on one of my forms, I have an ubound text box driven by a query. My time text box, current_time is set to Short Time in my table as well as my form....

Don't access these tables through this query. Create a form with tblPeople as the record source, then create a subform on the form that you just created and...

Hello Many thanks in advance for you help. I have 2 sql from 2 tables: The first sql is: SELECT F02_Hato.CodProd, F02_Hato.CodPer, Sum(F02_Hato.CodAnimal) AS...