I was wondering if it is possible to create a parameter query that prompts a response from the user but only part of the data is needed to be inputted? For...

I have an Access database which includes multiple fields populated by selecting from drop-down combo boxes. The columns are bound to return the the list box...

H, I'm having a problem creating a query that will be used for a stacked chart. Here's a small example of the data in the table. Class Teacher ...

In Access 2003, can you put multiple data items in a field and be able to query a specifc item in the field. Example if I name a field "Musical Instruments",...

All, I have set up a parameter query but I was wondering if it is possible to retrieve results when I only put in a part of the field. e.g. Column one...

Hello, I am trying to trun some numbers into currency using a calculated value in a query. Although the result formats the results as currency, it sorts as...

I nee d remove 2 first characters in the field. What function should i use in a query? For example: '1 group', I will need to have just a word 'group'.

All, I have set up a parameter query but I was wondering if it is possible to retrieve results when I only put in a part of the field. e.g. Column one...

Hi, I'm a begginer in Acces, so probably I will ask you with a basic question. I have a table with the following records: Table Name is TB_Tst - Project -...

I am designing a database to hold recipes and associated information. I would like users to be able to use a form to run their own queries based on a number...

I've created a new field in an existing Access table to store hyperlinks. The hyperlink is a concatenation of other fields, so I'd like to use an update query...

hi, i need to get this last time and date only for each records, Name id Duration Time/date 123 ...

I have a master table with a 9 digit zip code. I need to match it to a table of 5 digit zip codes. How do I get it to match only the first 5 of the 9 digit...

I am running a query and get error: System Resource Exceeded

Can I take a sql query statement and insert it into code? I know that on any sort of event such as "on focus" or "on click" I can run a query. I want to have...

Hello All, I've made a query that returns a list of people's names against certain actions. The list of names can be up to fifteen long and equally it could...

I need to count the number of incidents that occurred for a given month/day over a period of years. Eg. How many incidents occurred on 7/4 from 2000 to...

I have a movie database in Access 2003 The Actor field is linked to a look up table If I try to enter a name that's not in the table, I get an error(of...

I need some help figuring something out. I'm not sure if I heading in the correct direction. What I'm trying to accomplish is the following. I have a table...

Hello. I want to remove old records from a database to an archive. The archived database will have three tables Customers table will simply be a straight...