Here is the query. SELECT Nz(Count(a.com_num),0) AS Total, a.com_type FROM a WHERE (((a.date) Between forms!! And forms!!)) GROUP BY a.com_type; It...

I have three pass through queries set up in my Access database that are processed on a MSSQL server. All three queries function properly and process the data...

I have been trying to add multiple fields together to come up with a result for one field. It seems to work with two fields, but when I add the third field...

Hi All, Can anyone help with this please. I have two lists, LIST1 and LIST2. They are in separate tables also called LIST1 and LIST2 and each table has a...

I have A query that has Calculation Table1 – Table2 = Table3 when I run the query a box opens saying Enter Parameter Value (named Table1) I click ok then ...

I have a date field "daterecieved" i would like to query for items over 30 days old where a completed field is null. Please assist. I am trying to get the...

I would like to be able to group dates by month in my crosstab query, without losing the date values. I am going to need to export this query to Excel to do...

Is it possible to call manged (i.e. .Net) code from an access database or a way to handle access form/report events from managed code? Jacob

I also have duplicates in my Database and have entered the following for: - PrimaryID = ID1; - Table Name= TEST_MBS2; - Duplicate is defined as the same ID,...

I have a full date.time stamp field and need a query to only pull records for the current month and following month.

Keep in mind that I have most of the fields. the only thing I don't have which should be include in the statement are the dates. I have the RACC field,...

So I've got this nifty crosstab query that shows me my data broken down over time. The rows are and ; the columns are from the field; the values are from ....

I am trying to add two fields to Table A from Table B. When AcctNo from TableA = AcctNo from TableB (here it is a primary key), I want two fields added to...

I am trying to run a query that has these columns "Catalog Name" "Date Entered" "Session Number" "Item number" The Item Number is specific to the session...

I have tables, forms and reports set up in my database that work perfectly to track vacation days taken. The problem is in order for the report to look right...

I have three pass through queries set up in my Access database that are processed on a MSSQL server. All three queries function properly and process the data...

Hello, I need some help about the this: I want 4 users using one MDB at sometime. It is possible?... The access don't lock the MDB?... Thanks,

I'm about to transfer some data from on table to another. Here is my SQL INSERT INTO table1 (a, b) SELECT (a, b) from table2 I keep getting an error that...

I need to create a query that counts how many accounts have a specific service, but there can be many occurences of the same service on an...

Hi there, i am creating a form where I have a search field. I want to be able to search by the entire name or part of it. I have used a query that has LIKE...