Had several queries using the Date(), typically in a range selection (ie. Date()+7:00AM AND Date()+3:15PM). Suddenly all queries using the Date() generate a...

Good morning, From invoice detail I would like to collect (in a single query) the top 5% for each vendor. i.e. Vendor 1 has 100 items I'd like the top...

Hi, I'm trying to search the database fields by using a Like operator in my query. Everytime its asking for a parameter. Any suggestions ? or can someone give...

Hi, I have two tables, tbl_Orders and tbl_Letters. Both have a common Cust_ID field and each has a date field, Order_Date and Letter_Date respectively. Each...

I am working in an object oriented database and need to pull a number of fields from different objects if they exist. I can find matches with ease but when...

I have a query that, when I attempt to execute using code (e.g. Set rs = CurrentDB.OpenRecordset(...)), I get a message indicating "Too few parameters....

I have a table which has the following headings: Name 2004 2005 2006 2007 Under the name field is all the staff members name. Under each of the...

I have a query that, when I attempt to execute using code (e.g. Set rs = CurrentDB.OpenRecordset(...)), I get a message indicating "Too few parameters....

I'm befuzzled. I moved an Access 2000 database from my old laptop (W2K, SP3) to my new laptop (also W2K, SP3) and now my queries that use the RTRIM() function...

I have a form within which I am trying to define a SQL string via a string variable (I have also tried defining it as several string variables and...

Is there a line you can add to this code WHERE (((InStr(, ))0 Or (InStr(,)) Is Null)) That will allow you to search for the start of the field as well. Say...

Alright, so I have been scouring the newsgroups trying to find a solution to my problem, but it seems to escape me. Here is what I have. There are two tables...

Hi all, I haven't used Access for yrs and now need to create a query quickly. I have a table, in which some of the fields have long data strings. I...

I have a small app to print out multiple reports. The user inputs the data on the form, which writes to the table. Then the user can choose which reports are...

I have a database called Projects that has a Text field called Project ID. I also have a spreadsheet called Invoices that I want to link to the database that...

Hello, I'd like to know if it's possible to set up a relationship as cascade deletes using SQL under MSAccess. I tried "CONSTRAINT fk_column FOREIGN KEY...

What I am trying to do: tblUniveral is made of questions (Q1- Q28)which can only take their value from the list of Satisnumber off the tblSatisfaction....

Hi, I have created a Expression in a query with the following code: IIf(IsNull() Or IsNull(),"No Data","Some data") However, some of the records have 'Some...

I wrote 7 update queries for updating the field startofweek and endofweek depending on the reportday, it takes more than 2 hrs to run all of them for 250000...

Hi, I am trying to return the last comment by projectid, when I run this query it is still giving me all comments instead of the last comment. What am I doing...