Hi, I'm using MS Query to execute a stored procedure in an Access .adp sqlserver link and return the data to Excel. It works fine, but when the result set...

Hello all... I am trying to query a few tables, but in one of the criteria I use . When I do that, Access never pulls the data and I have to shut it down...

Hi Guys, sorry to cross post, not sure where this qiestions should be asked? I had hoped I could simply copy the SQL code into a view and use I have...

Hi Guys, Can anyone tell me how to limit a query to the top 'n' records? I do my queries in the design view window not sql panel, so suggestions in view...

OK, let me explain the subject a little better. Please note, I have not yet built the query, I am still working on the "how to" part of it. I have a table...

Yes, that's right, I have created a NULL query! OK, to explain. I am developing a form of Financial Management database for my organisation. The database...

Are the names in the memo field separated by comma or some other punctuation? If not, I suppose this is why you need to compare? Don't do the task in...

I'm doing a query to find people who are currently on travel. I have a field of "Date Started" and one for "Date Returning." Where in the query and how...

I am currently creating a master form called "Client Form." Within the Form there are several subforms that pull data from various tables, all linked by the...

Thank you for helping me. I have two queries, qryA and qryB. They are being used by qryC, which has about 6 total queries in it. When qryA and qryB are both...

"Reserved Error (-1517) There is no message for this error" This is the message that I get when I run a query. This query used to work and has not been...

I'm trying to do time value investment calculations in a small Access database I've been building. For the sake of this discussion, we're talking about a...

I have several forms that I need to use the same query (one at a time) each form has a field with the same name on it that I am using to pass criteria to the...

What is the syntax for creating a text file? I know how to do this manually using the menus but I'd like to put the language in a query (not a macro or...

I am using Access 2002 SP 3, I am attempting to evaluate a string (a name string with last name first, a comma then first name) to find where the first space...

I tried the following in a query, but could not get it to work: Not Like ("*Top*") Or Not Like ("*Remaining*") Or Not Like ("*Total*") Or Not Like...

I have a phone table with multiple records for one individual. I want to show all the phone types and numbers for an individual on one row. How do I get them...

I am currently converting a database to a more efficient design for a client. The client previously had a memo field where they stored all the names of people...

I have an append query in an Access 2007 database that uses a linked Excel spredsheet as its source. When I run the query it appends about 65,000 records to...

I wanted to append one table to another through a Query, so i took my table 2 and clicked append query, thus adding all the records in table two to table...