Queries

open a message box if a query is null during an autoexec macro
Hope someone can help with this. I have a query that runs using an AutoExec macro when the database opens. What I want is for a message box to open instead of the query results window, telling me if the query produced any records. I can do this easily enough through a command button on a form, but cant figure... 28 Apr 2010 14:02

Date/Time criteria problem
I am trying to create a query that allows a user to select a specific date for which to show results. Following is sample SQL with a fixed criteria: SELECT qryShopJobsIO1.JOB_NO, qryShopJobsIO1.[TOTAL QUANTITY ORDERED], qryShopJobsIO1.[ENTRY DATE], qryShopJobsIO1.SumOfTotalHours FROM qryShopJobsIO1 WHERE (((q... 28 Apr 2010 14:02

Group By Desing View
I am running a query that I created in design view. I am linking a number of tables together to get the result that I need. There are about ten fields in the querry but I only need to display the values of two fields: 'Account' and 'Value'. There are multiple Values for each Account so I am trying to sum the... 28 Apr 2010 15:11

Query keeps looking for Query1 field
Okay... so I have this bad habit of saving queries as Query1, Query2, etc if I have not completed them and I get interrupted. It helps me get back to the incomplete work faster/easier. I have a DB that began as an Access 2007 DB (.accdb) and was converted down to an Access 2003 DB (.mdb). Since then, these q... 28 Apr 2010 18:37

vlookup in ms access
Hi I'm not a programer, not aware of programming, I just started using ms access recently Can anyone help me in a simple language of creating vlookp in ms access in a form view if i have two combo boxes, and when i selected one value of combo box one, its corresponding value only reflected in next combo2 i have... 28 Apr 2010 11:44

(SELECT
Glenn wrote: I have a query that shows the following information It looks at a specific table (table 1) then groups by sales agent, then groups the tariffs that have been sold by that sales agent and then the query has a count on tariffs. I have then built a report to display the results which would lo... 28 Apr 2010 22:00

Exclude data from field, when another field equals a certain numbe
Hello, I have 2 fields. I have Job # and GL #. I need to exclude from the GL field, values that are 1234, but ONLY if the Job # = 999999. I have tried using this formula in the criteria of the GL# field in my query: IIf([Job #]=999999,<>1234,[GL #]) and instead of 999999 still showing up in the quer... 28 Apr 2010 14:02

Min value & corresponding date
I need to get the min value of FVC% and the corresponding date that goes along with this value. I've had no luck just trying to use min from the totals option. This is what I have. From table (tPFT) I need to following fields ingPtID, STUDY_DATE, FVC% ingPtID and STUDY_DATE are both primary keys if that ... 4 May 2010 14:35

Report + chart
Hi I have a report thats is open with a form selecting dates from "date1" to "date2". The form is based on a table that contains all dates. The report-chart then shows date range on the x-axis. My problem is that if the query, that the chart is based on, has no values for some of the dates in the selcted da... 28 Apr 2010 07:15

ComboBox related query
On a form I have a ComboBox (Combo8). Is there a way to base a query on the value of what is selected in the ComboBox? Here is the SQL statement I've created, that is not working: SELECT [Combo8.value].DRAWING, [Combo8.value].[EQUIPMENT/CIRCUITS], [Combo8.value].[CABLE TYPE], [Combo8.value].[FND/SEQ], [Combo8... 28 Apr 2010 11:44