I’m not sure if this question belongs on this board or an excel board, but hopefully you’ll be able to help. I have an access query set up that I use...

I have the following query: SELECT MROs., Format(,"mmm-yy") AS , Sum (MROs.) AS Forecast1 FROM MROs WHERE (((MROs.) Between DateAdd("m",-12,Date()) And...

=!! And =!! EX 04/01/2007 TO 04/30/2007 I AM GETTING A RESULT THAT IS NOT INCLUDING 4/30/2007

How can I output the query results and the SQL used create the query to Excel ? Can the query go to Sheet1 and the SQL to Sheet2?

I have a form that used to have a value list combo box that controlled a make table query to create a report. I got smart and changed the value list combo...

hello all, I tried in all possible ways, but I can't find a solution... I've got 1 table with 2 fields only : Invoice number, Invoice Date. I wish to retrieve...

I have a split database that utilizes make table queries. I won't know the UNC paths for all the users that will be using this database, so I have the make...

At predent the only place I can send my Access filr is to an email recipient. I want to Add Drive A so I can back up my work, Any suggestions...

I have a form with a subform. In the subform is a field ProjNo. On the form is a command button which, when clicked opens a query. The intent of the query is...

Hi Despite reading all I can I cannot seem to work around this. My query is flipping ambiguous dates to US format. If it is passed a date of say 23/08/2009...

I have a table with three fields: Hour, Tank, Volume I want to create a query that, when run, will take the volume of a group of tanks, and change it to the...

How do I write a SQL statement where I want one field unique (MasterCodeID) but several other columns from the same table, say Field 1, Field 2 that are not...

I've inherited a database that needs changes, and haven't worked with Access much lately and I'm stuck for an answer. I have a query that works just fine...

I want to compute taxes on Grosspay in a test access payroll query. Conditions are as follows: Grosspay is a calculated field in the query and is monthly. It...

If I have 2 recordsets, both which contain identical fields, is it possible to merge them into 1, before displaying them on a report? Thanks, -David

Hi. im bit stuck. i need a formula for access whereby it will return all date entries put in 11 months ago. e.g. today is 05/2007 it will return all the...

I have created a cross tab query with a count. How do I get the cross tab query to display 0 instead of a blank and/or null? -- M. Shipp

I have an application in which I download data from another Access db. On one append query I format the number field using: format(Piece.Width,"0.000"). On...

Hello! I have this sql query below. It works fine, but not exactly as I would like to. I read some good discussions before I decided to post this message....

Hi, I have been trying to sum quantities between dates without success. In my last attempt I get an error message of "you tried to execute a query that does...