I am able to create an Access 2003 pass-through query to Oracle 10g that uses a SELECT statement; it returns a resultset. But, I cannot get a resultset when...

I'm getting a "Query timeout expired" error when running my Access pass-through query. The query works when I retrieve a small date range, but when I expand...

What is the SQL-92 equivalent to Access '&' when combining strings? Such as getting a Full Name using Access is & " " & . Specifically, I am trying to get a...

-------------------------------------------------------------------------------- I need help. I have several Excel formulas that I need to use in Access. I...

I've recently gotten into Access pivot tables, and am finding them very useful. I use a MakeTable query to create a new table containing the info I want...

Hi, how do you set the criteria in an Access 2000 Project example Criteria will be Forms!Form1!txtCustID. When I tried this it is returning an error. Please...

Hi. I have a quite bothering problem with Access 2003 and a SQL Server. I created a form where the user is able to pick which colums he wants to have in his...

I'm very curious. I have a book I'm working through on Access using VBA. One of the chapters speaks of using ProperCase() but this doesn't work as a direct...

This has got me stumped - hope someone can point me in the right direction. We have a large db split with shared backend on the common drive. Windows...

i have table,which are designed on the basis ofid.meaning for every field an id is maintained.eg: for address, name everything,address id,name id...so how can...

I am working on a very detailed financial database and I am trying to balance my numbers as I go. One of the queries that I need to write involves a...

I have a search form with a number of parameters eg. last name, id number, age(selected from a combo box). On the same form, I have a list box in which i want...

I am trying to compare the results from one query and another and cannot figure out how to get just the difference of the two results Any suggestions

I have a contact table and a company table: Contact table has a company id based on the company id field in the company table. This is the relationship I am...

I accidentally made a correction in the query view, when I should have made the correction in the design view. When I did, the particular change I made to...

I have a query run from a master table. It looks great in print preview but when I print it sometimes fields overlap or have spaces that I didn't put there....

Is there any way to select the only the top 5 records in a query or table that is sorted by amount.

How do I return the birthdays in the next 30 days in a date of birth field

I have two access queries, there is one criteria "GB or ML" in both of these queries. In the first query, it still gives me back the GB and in the second...

I need to perform a query that will show me all of the items that were posted between two separate dates,such as 05/26/2009 - 10/24/2009. Can anyone please...