I have a form/sub form set-up whereby a user can enter search criteria into one of any 12 fields. These fields are either text or pull down menus. I have...

I need this to run overnight every night. When I simply open this select query, I get a 14 field query with about 80 rows of data. Access 2003.

Consigue tu M3i Zero , Ezflash Dsi , R4i Dsi M3i Zero www.R4spain.com/tienda Puedes comprar M3i Zero , Ezflash Dsi , R4i Dsi X=KNyd+ZLdJLii/_IgvFxitT/

Hey all .... I have a query where I would like remove the parameter prompt and automatically obtain records between the 16th of last month and the 15th...

How do I find the date, of the 1st day, and the last day of a given month. I want to use this in monthly reports that give a heading reqirement: from 1...

the first name, middle initial, last name are all stored in a single field. I only want the 1st 5 characters of the first name ... does anyone know how do I...

Hi, I'm trying to build a query that gives me the first day of the current month. This is what I currently have: When I run my query it returns 10/1/06 and...

Hi Here is the scenerio: I want to run a query which will me a list of all employees eligible for 401-K enrollment as of last pay period. The criteria for...

Hi! I have a table with two columns of amounts, and I want to create query with a new column where those are summarized. One of the columns (C1) is more...

I'm sure this is simple, but im relatively new to access. this is what I need to do: I have multiple customers who use different shippers I need to pull up...

Hi - I have 2 combo boxes at the start of a form. The first one allows the user to selct one of 10 different machines on our factory. How I can set up the...

I sm sorry for the complex question, but I don't have much experience in SQL. I have to query an external database (meaning I cannot change it's design to a...

please help me to put 2 condition in query of the date fields , i would like to limite the query result to speific date between start date and end date or...

How would I write a query where I want to find a conflict of user profiles sorted by id's? I have a table listing user id's, names, and profiles. I want to...

hi, I have the following 2 queries: calls_by_status: TRANSFORM Sum(tbl_CACS_activity_by_resolvedstatusandcontactcode.) AS SELECT...

Hi, I have a folder name "Project" in this folder, I have 2 database files - Main.mdb and Data.mdb. I have a Make table query in Main.mdb. the Make query...

My db looks like this: Invoice: InvoiceID, InvoiceDate, Invoice Value Pay: PayID, PayDate, PayValue, InvoiceID I made a query to show me the due Invoices, my...

I'm trying to write a query that will allow me to look up the dollar amount greater than $350 or the Number times used greater that 10. Right now for the...

I am creating a queary of 2 tables. Common field is Account number. Table A, the filed is 15 characters. Table B, the field length is 25, and the 10...

Hi, Is it possible to have !! or !! in the criteria of a field query ? is a number. thanks.