I have a 2002 Access database with a query that uses a function defined in VBA. This query works fine when it's run from within the database, but if I try to...

I have a query that returns service_type, amount, and cost_center. I want to be able to have the user type the filtering criteria in a text box in a form....

Importing data from Paradox file. Need to remove records with a Facility identification equal to 3 characters. Data in this field can be 3 characters or 5...

I'm trying to execute an aggregate function as part of a select statement. It requires me to include all columns not in aggregate function in the 'Group By'...

Have the following query which is not updateable when I open it: SELECT PlaysByBar_Int_5_Full.Ticker, PlaysByBar_Int_5_Full., PlaysByBar_Int_5_Full.,...

wow Ken Snell, I like this. It's strange! Thanks, "Ken Snell " wrote: Actually, a slight "misspeak" in my post... your comment about doing a left ...

I have got a query that I thought was doing what I wanted, but now I'm not sure. I am using the following: ...

Access 2003. My make-table query is used to debug a process. It involves using a Totals query to create a table, then remove a field from the query grid,...

If I try to copy more than one cell after running a query it always includes field names. I want to copy several cells in a line or the whole line and then...

I am using several text functions to create a field which forms the text of a hyperlink. This is for an append query. When the records are appended to the...

I am new to Access 2007. Every time I create a query and get it fine tuned, and then save it and give it a name, then close out of it and then select it to...

I've used this string "= And =" many time, but I may not have used it on a field that has a default value of Now(). I have a field (in my table),...

I've inherited a database and while trying to familiarize myself with how it was constructed I came across queries that have an "filz" prefix. I see that...

hello, i have this form, that has four possible experiments per record per project number. Each experiment has a main resin and 3 additives or 4...

I have follwing data to create crosstab query and column heading is Grade. Student ID GRADE 1 A 2 B 3 A ...

I have two tables, one with projects, one with construction agreements. I need to delete 3 records in each but when I try it says they can't be deleted...

I am requiring the user to enter three parameters for a query and I'd like to control the order in which they are prompted for. Two of the parameters are...

The criteria that I am trying to determine is to have a user input a number and then the query show all the records that have a value of greater than the...

running access 2000; I have a contacts table with name address phone etc... I'm trying to make a "find duplicates" query work, and am failing. When I try to...

I'd like to have a recursive query that refers to itself, but I have run into the 'circular reference' error. Is there a workaround that'll let me do...