Queries

DateDiff
I am trying to work out the number of working days between two dates. I am using the DateDiff function, but this appears to count weekends. Giving me fault results. Thurs 12th to Tue 17th, should return 3, but returns 5. Is there an interval for this, or should I use a different function. I know in Excel its N... 18 Mar 2010 15:31

extracting day from date
I have in my database a field called Hire Date. How do I run a query to select all those with dates that are the first of any month of any year? ... 18 Mar 2010 03:45

SQL Select Query Prompting for NonExistent Parameter
I'm using Access 97. I've entered the following SQL Query into the Query Tab. =================== SELECT * FROM tblVehicles WHERE fldVehicleTag = ABC123; ==================== When I double click the Query to execute: Instead of returning the recordset Access prompts me for a Parameter. When I enter... 20 Mar 2010 09:48

Returning A Varibale from a query
I have a form that needs to create a unique ID upon entry. Like a new Sales Order Number for a new sale. What I want to do is the run a query that return the MAX value for a field. "SELECT MAX(SALNUM) FROM TABLE" I can then add 1 to that number and create and a new key. I am having a problem trying to d... 17 Mar 2010 18:43

Query filtering by Aggregate
What is the best way to accomplish this in a query. I have records where I want to return only records where one returned value only is matched with one aggregate value of another field. Tough for me to explain. Here's an example: 1 P-0001 H 2 P-0001 H 3 P-0001 H 4 P-0002 H 5 P-0002 G The above is a ... 17 Mar 2010 18:43

testing for numeric or alpha
How do I test a text field for numeric data? How do I test a text field for alpha data? ... 17 Mar 2010 12:31

DELETE column in TABLE
Hi all, Is it possible to create a query that DELETES column in a table in ACCESS 2007? the reason is, because I receive a very big database from my supplier, I need to delete a large number of column that are not needed by us. now there are 200 fields and i only need 15. when publishing to complete databas... 17 Mar 2010 12:31

Total column in Query
I have a table with ID, Description, Intake, Sold, Remaining, Intake Date, & Total Inventory. I would like to have the Total Inventory column populate with a total from remaining column based on the description. For example: At the beginning of February I took in a total of 5 warmers. During the month of Febru... 16 Mar 2010 18:37

Display records one time only
Primary Key is ID and data is extracted by ClubID. Fields are ID, ClubID, StpMail, FNm, LNm, MI, AD1, CO, Cty, ST, ZP. Prompt asks for up to 5 ClubID's, but the resulting Dataset has duplicates (one ID may have been a member of all ClubID's) ClubID is a year value (i.e., 2007). How do I restrain the data so ... 16 Mar 2010 17:26

Duplicate fields in Access Database
I have an Access database of all of my CD's that has all of the tracks. I want to have a query that will show which songs I have that are done by multiple artists. I can't use "Find duplicates" query since I might have the same song by the same artist on multiple CD's. What I want is to be able to have a query ... 16 Mar 2010 12:33