My first iif statement reads as follows: Volume: IIf(#4/13/2009# And In ("IL","AL","MI","OR","MS","KY") Or #5/7/2009# And In ("TX","MO","WI") Or...

Hello. Is there a way to auto-update a table in Access via one other table? I try to do it with sql query and the query asks for values. I want to...

Hi All, I've got a form which is based on a query. I filter the data on the form. How can I create a query which will use the form filter as the WHERE...

I have just started getting serious with Access 2007. I tried to import data from a text file and append it to a table and got an error dialog box: Microsoft...

I have a database that tracks service information for vehicles. A vehicle can be put into a group, typically by depot. On the dashboard of the program I have...

I want to calculate the hours missed by worker from Scheduled_shift_start_at and Scheduled_shift_end_at using date/time. The worker either started his/her...

I get an error message that there is an extra ) in Access 2000 query District: IIf(NotIsNull(),"Thoroughfare=" & ()) I cannot see what is wrong with it...

Hi all, I have a table where for each product I have a list of components; every component has a price an a date (usually different prices per date). I want...

I have an interesting parsing problem. I have a table formatted like this: "1","Newark;Trenton;Camden" ....and, using SQL, I'd like to convert it to...

Hi all, I've used comboboxes to retrieve data from a table, the code is something like: strSQL = "SELECT NomeProgetto, IDProgetto FROM...

First hand- I'm working on a pricing database- and if you know anything about prices, they are Always changing... My current table is set up as follows:...

Hi all, I get this sign in my query...what does it mean and how can I get rid of it? Thanks!!!

Hello there all, I'm having a bit of a problem with a SQL query in MS Access. I need to produce a list of all anniversaries of a date (ddate) that fall...

How can I union two queries, one with valid dates and the other with null dates and not get a type mismatch error? If I make the null date field an empty...

Access 2003 I am trying to create a query to show all people who have completed some requirements. The requirements are all check (yes/no) boxes. So in the...

Here is another question, that I can for the life of it not figure out: I have a query (let's call it second query), that selects certain fields from a first...

I am working on a query that will calculate the average sell thru for the past 5 weeks rolling, by customer and SKU. My data looks like the...

Hi all Just been for a surf around the net looking for answer to an issue i am currently having with a formula in a query in access I am trying to get the...

Please help can not figure out best way to achieve the qty on hand and on backorder. Not sure how to link and or combine all info... Have Location...

hi, i have a query which contains a field to convert text to number: CLng(Mid(], 1, 8)) However, I am getting an #error for some of the rows in the query...