I have a table with 3 columns. Last Name, First Name, Amount. There are multiple entries for each name, eg: Smith, Jane $50 Smith, Jane $100 Smith, Jane...

"Snide" schrieb im Newsbeitrag ... I have created a query that get information from three differant...

I have a question to you Access guys. In the news group I frequently read terms like "insert query" "update query". When I learned SQL I was taught that the...

Hi folks, I have a question how to obtain an update lock when talking to a MS Access ODBC data source. The DSN is roted to an otherwise unused .mdb file...

I am converting a Crystal Report which I believe looks at SQL server data (for which I am only secured to read) to a similar MsAccess routine. There is a root...

I know there is a MSAccess function: Cstr(value) that will convert a numeric field to a text field. What is the function that takes a text field (that always...

I have a database (access) of vehicles, where each vehicle can have many transactions in any month. how do I access only the last record of a month for eachj...

I have a form that supplies the parameters to a query. Can I set this to query the database if partial information is entered? For example, the user enters...

I have the fields LastName and FirstName in a datatable. I need to combine this information into the format "LastName, FirstName*". Can anyone help me do...

If an employee's probation period ends between the 2nd and the 30th of a month, he/she will be eligible for benefits the following month, how can I create an...

I have a query that I am trying to concatenate more than 2 fields. This new field is set up as a parameter that asks the user for a value that equals the...

I am trying to combine multiple select queries into one select query, but I am not getting the results that I want. Any tips for this process?

Here is a simple query that should match Buy.ID with Sell.BuyID SELECT Buy.ID, Sell.ID, Sell.BuyID FROM Buy INNER JOIN Sell ON Buy.ID = Sell.BuyID; But here...

I understand the unique values property, but how does the unique records property work. I have tried to use it, but without any luck. Can someone give me a...

I have two tables. One table is the main record holder (name, address, etc). Within that table is a lookup field from the second table. The second table...

Dear all, I am trying to create a select query that will retrieve my specific text terms only when they are followed by a space. For example, one of my text...

I need to exclude all records have a particular value. Using the criteria not like "steve" does filter out all of the Steves, but it also filters out all...

Hello, I have a query set up which relies on the user entering a date. When it prompts the user to enter a date the message (Now) comes up to enter the...

I'm creating a VBA script in Access that will take data selected by a basic query, place it in an Excel worksheet, and format the data. I cannot figure out how...

I have my date values set up as 00/00/0000. Is it possible for me to query for all entries in a specific month (i.e. all June birthdays)?