Hello everyone, I have exhausted my attempts to figure out the problem with my database. First, this is the first database I have created. All was going well...

Hello, I have table called “tblTag” in that one of the field name is called “Tag”. The Tag field contains some equipment names which are in the below format....

I have 6 tables that I have built 6 different queries on. Individually, these queries return the correct amount of records in the tables. Which is 80...

hi friends i would like to know that how it is possible to select the last ten records related to a particular suppliers. supose a supplier supply me the...

I am trying to write a very basic make table query pulling some of the data from a form. the form has a check box, and a default value of -1 (this is to...

How would the critera be wrote to get a greatest value? (Not greater than, but just the greatest - I don't want to see any other entries)

I have a query in the RT field there are records that = 1111111 and 9999999 In LOC_No file I have counted the record that match Zip_codes, Company,RT If any...

I have an Access table in which I record information about photography of art objects in a museum collection. Any object may have been photographed a number...

Query includes 2 tables: t040Project (ProjectID PK, ProjectName) t41ContactsProj( ProjectID PK, ContactSubID SK, ContactID SK, CurrentPMorMgr) all PK and SK...

Can anyone help me with this? I need to know where to put the coding to tell the formula that if there is no value in any of the txt's, to return a value of...

hi - I'm wondering why the following SQL doesn't work. It treats the 'FullName' alias in the last line as a parameter and asks the user for its value. ...

I'm not a strong individual with VBA code; however, let me explain what I think I know and I'm hoping someone will show and explain in simple enough terms...

Greetings to all - I have written SQL to rank athlete's scores. My query works, but not quite the way I'd like. Here is a simplified version of my...

I have a text field that contains both numbers and text. At the end of some of the data in this field , it has a partial date -- such as 12/24 - 01/23. ...

I read the following tweet on twitter. I have happily used nested views in MsAccess, but I have been dealing with dataset 100,000 records. Are nested views...

Hi All, I've puzzled over whether I can accomplish what I want using just a query (or a set of queries), and came to the conclusion that I couldn't - but...

Trying to run an aggregate/totals query to group on a particular field but getting message...."Can not group on fields selected with '*' . And when I pick...

Hi, i am trying to get a count of a certain criteria but in different columns. Its hard to explain, but assume i have a table which consists of... A 550 B ...

I have a query and one of the fiels is numLevel. Then i have a form wirh an unbound combo called txtLevel. then in that query in criteria under numLevel i...

Hi, i have a table suptblLevel with the following values: autLevelID txtLevel 1 ALL 2 OPS 3 ...