Hi, I have a column in my database with 7 problem types that end users can select.I need to count them - + create chart to show which is the most common...

Hello Access 03 on XP PRO I have a search panel I am writing and I want to set up ONE query that will be ready to search for any combination of restrictions....

I'm a VB programmer new to working with access. I want to run a query (Insert into Query) each time the user changes a value in a combo box. Could...

Is there a way to protect a query where it cannot be changed or deleted? Someone deleted a query we use all the time and it is a very complex query. Thanks

Hello Access 03 on XP PRO I have a search panel I am writing and I want to set up ONE query that will be ready to search for any combination of restrictions....

Quick Question - I am using the DSUM function to pull data from a table into a report in access 2003. Can you use the DSUM function to pull data from a...

I have created a report from a crosstab query that will calculate how many students attended a course during a particular half term period. As we have not...

Hi! I'm working in a access database that someone else have created and I have never worked in access before. There is a very complicated SQL-query that...

Hi, I have a make table query which totals a students results in a multiple intelligence quiz the student is required to rate between 1-5 for each question,...

Here is my issue: The data in my database has multiple SS# per acct number SS# 5678 acct# 1414 SS #1234 acct #1414

I have a cross-tab query that is based off of a master table. The columns in the cross tab are dates. I formatted the Month column in the master table to...

I have a question about the structure of a query. I have a table with the following information: Name REVCriteria Tom Customer1, Customer2,...

I recently upgraded to Access 2007 and I'm having trouble with one type of query from my database that I designed in Access 2003. Its a simple Access query...

I use parameter queries to enter data and they work fine when clicking the OK button. When clicking the Cancel button, each query gives a 2950 error on the...

Here is a problem I am soliciting solutions to: I have a list of records, each record has an id field and a value field, and I want the id of the record with...

If I have a set of Dates in format mm/dd/yy, what function or expression do I use to find the weekend date? Sunday - Saturday Ex. 6/1/08, 6/2/08,...

I have a very complex query with many subqueries that reference numeric fields either directly or through expressions and aliases. Every numeric field or...

Hi, I retrieve formula file from a ERP system. Due to the legacy ERP, the formula can only contain 40 ingredients or less. In order to continue with...

I am trying to set up a querydef to export a query. The set qdf statement doesn't execute because mydb=nothing for some reason. I'm not real familiar with...

I have a query that is used as the record source for a report (That prints statements). The query has columns 0 to 30 Days, 31 to 60 Days, 61 to 90 Days, 90+...