Access 2003: Trying to create a demographics report that will allow the following. Gender example On the form "frmStudentDemographics" is a drop down field...

I am trying to create a query to say I want everything from a table but not the following multiple reference numbers...

Is there a limit on the number of fields that could be included in the query? While designing a query I get an error message "Too many fields...

Hi. I created a report based on a query that uses Dsum function. This query runs well in the server where I created it. But when I ran it in a different PC,...

Would like to create a crosstab query where multiple values are returned for each row/column heading intersection. Have data something similar to...

Let's say I buy merchandise for 1 department. I have dozens of users (for different departments), who import data (using a form) from 1 source database (in...

Hello – I have a form that has multiple fields on it…the fields a BillingAmount1 BillingAmount2 BillingAmount3 And so on…up to 7 Billing Amounts...

I created a parameter query, and then I created a crosstab query based on the first parameter query. I keep getting an error message that says: "The...

I have a linked query that shows projected quantities on the first day of each month for that month. It also does not display any other dates except the...

I am trying to make a crosstab query, below is sql view, all the rows and values, columns are ok, no error. Only the problem is that its not sorting by the...

I have a table which to all intent and purposes is: Recieved and Sent. I have a table which has: Rec. Date Sent Date (with other information, but i can...

Hello, Im new to queries and i'm trying to pull off a seemingly tricky one. Somehow I need to 'merge' or 'combine' the two queries below into one: SELECT ...

SELECT Data1.Date, Data1.Shift, Data1.Thickness, Data1.Species, Data1.Plies, Data1.ValueLeft, Data1.ValueRight FROM Data1 WHERE (((Data1.Date)= And...

Hi I'm running a qbf based on two main tables (CVs, Ofertas), in order to find records that have at least one match, and I would like to include in the...

Hi all, I was wondering if anyone could please help me? I have a database table that has a column allocated to the date a person consented to have their...

Table is organized like this: Date Purchase Quantity 01/02/2010 12 01/23/2010 45 05/04/2010 10 07/06/2010 ...

Access 2003. I have this criteria: Like "*" & !! & "*" This criteria is used to find values in a concatenated string. It works fine EXCEPT if something like...

When I run this query, I am presented with a parameter input box asking for tblGrievances.Year (unless I remove it from the ORDER BY clause). How can I sort...

Hi- I have a text field, the format of this field is ##.## (ex: 09.10) How can I check this field if it have a value then it must be in a format like above?...

I have a recordset that has a common identifier with comment information on multiple lines. I want to create a query that diplays the multiple lines in a...