I would like to (have been trying to) design a parameter query to build a report. The report will show ProductID, ProductName,...

How can I write a query that will return a list of random records from a table? The table has an autonumber value and I want it get a random set...

I have a mental block! I have a table with 2 fields. A location field (text 4) A date/time stamp field (Date/Time) I can have multiple records for the same...

Hi: Am trying to execute a delete query but it prompts to enter a parameter, the where clause. SQL is as follows: DELETE tblTBBeg.AccountTitle, * FROM...

I have a delete query that i want to have run from a button on my main switchboard. When in the design mode for my switchboard i choose the command button...

Hi I'm using the following parameter query with a form, it works for the first few times and then doesn't bring back any records at all. To get it...

I am using a combo box to look up department names. When I select the Department name, I need to also get the Department number in the same table. I do not...

Hello! Here is part of my database: tblStudents: StudentID tblMajorsAndStudents: StudentID, MajorID tblMajors: MajorID tblMajorsAndClasses: MajorID,...

Here' s what the data looks like on one record from the table I'm trying to query to compute payroll. Each record has over 30 fields, but I'm only concerned...

DCount("field1","QueryName","field1 ='" & & "'") works fine with a text field. What am I missing for an autonumber field? I get data type mismatch error....

Win XP - Access 2003 I have a report that shows 4 yes/no checkbox fields. The report is based on a query called boardsQry. I only want the report to display...

I've been trying to join a text field & numberic field in a query, but every thing I try I lose the decimal places. Can anyone help?

Hi All- I have a (simple) query trying to learn how to mix inner and outer joins in access, I'm getting a 'Join expression not supported' error. SELECT...

I'm looking for a method to query for the actual rent paid for given month. Example: The RentRate would be the monthly rental charge for a full month only....

I have 5 tables; Customers CustNo tblSales2002 tblSales2003 tblSales2004 tblSales2005 All Sales tables have the same fields; CustNo; Div; Year; Rank;...

I have a select query called qryRandom that grabs a random number of clientID. In that query, i set the top value to 100. In another query called...

What do you mean by "as a recordset"? You can create a recordset from a crosstab query. tina's answer fits your earlier specifications exactly. What do you...

I am trying to create a backup copy of a current spreadsheet, and I want to call it a backup copy and place the month in the title of the file. Can anyone...

I need the count the number of entries in each grouping: This is my...

This is probably a really simple query but the solution is escaping me. In an adp, I need to know how many times each production line (listed in Line table)...