I have a table with a field containing fractional numbers with the TEXT data type. I need to sort the field from smallest to largest values. However,...

My query will have information from 2 tables membership table: number city male female rodeo table: name winnings points

Hi folks, Here is my problem. I want to do some validation in an overtime entry field depending on the total number of regular hours worked in a week in...

I am new at this, of course! I made a "list box" and of course I made a spelling error! I double clicked on it, which brought up the properties and corrected...

I've never used Access before so, miraculously, I've designed a database. The problem is, it doesn't work!! LOL For the Combo drop down boxes, I can see the...

Hi, I am relatively new to Access and was hoping someone could help me out. I have created a query that accumulates various columns of information...

In the Access application environment, Screen Tips are working fine, but when i set ControlTips in my own forms, i get nothing. Is there a seperate setting to...

I'm designing a query from two tables (Administrators and Budget) where I need to generate a combined list of email addresses. I have several people in...

Here's the deal, I have a report with 36 "boxes" each with 3 expressions that look like this =DSum("","there"," = 'who' AND = 17") OK, the "who" changes in...

Fisrt timer I am new to access I have a database that I want to make better. In a form I have the following fields: Country, State, City I have 3 tables...

One of my co-workers has designed a report but now wants to add other fields from other tables onto the report. I thought maybe if we added an unbound textbox...

When someone starts an application how do I determine the folder name that the database file is in? If the application is opened by starting Access, and...

Hi All.............. I am trying to bring an Excel file into ACCESS. I have a specific named range on one Excel sheet and the top row of the range is the...

Hi, I have a table where there's a "R" field (Yes/No Type) For every record where R equals to -1 I have a function that do "something" I am able to...

I have a membership database where the year runs 1st July to 30th June. The year is referred to as the year as at 1st July. How do I get a yyyy answer that...

After much help from this newsgroup I have a sub form which looks up a value and fills a second field after update. Now when I make a new record I get a zero...

I have a table with the following data month reading Jan 100 Feb 200 mar 300 I need to take the value from a...

I am still having problems. With the settings. All of it is in dark settings, so you can't retrieve it.

If you have many versions of the "Secured" file, the "Toolkit" file and the db file, how can you tell which is being used? I'm going nuts trying to resolve...

I have a tab control with 3 tabpages. I want one of those pages to contain a sub-form. I could swear I had it working properly for a while, but after I...