Hi, I am new to access, I need help to solve the problem My data is from range 1 to 31 sr cdate no1. no2 no.3 no.4 no.5 1 1/9/08 1...

Greetings, thank you for looking. I am attempting to display the grouped contents of a field ...a field that the user will select from a combo box. There is...

Hi, I have two fields in my Query, which are dropdown lists: Issues I, Issues II. I only want the user to be able to choose from one of these fields. How do...

I have a query that has the following fields: date punch in time punch out time I want the results to show me all the records of a particular timeframe...

Hi I am trying to pass an argument from a control box on a form to a Filter Query Criteria: The Filter Criteria currently reads: IIf(Trim(!!) Like "All...

Hi, I have three fields in my Query: Issues I, Issues II and Issues III. The user will select and option from either Issues I or Issue II, never both. I...

Hello, I created the query below to add new records to a some joined tables in a database. I ame not that familiar with access sql. SELECT...

Hi All, I want to run a query that will gather data 10 minutes from the now date/time. How can I do this without having to write the date/time in there...

I'm trying to write a query to take two columns from a table: "identification" and "date" and return only the latest date for the identification (there...

Here is my quandary. I have 72 different reporters that should report data on every weekday. Each time one of them reports it is called a census event with a...

Hi, I'm trying to the get field information from an old table into a new table that is already populated with company information. I want to say: if...

I want the user to be able to specify the quantity of the "Top Values" property of a query. Can this be done via VBA? Im thinking I might have to do it by...

Hello, everybody, Perhaps someone here can help me out a little bit. I need an expression that calculates the elapsed time between the date a letter was...

I am using Dev Ashish’s ConcatFld function to concatenate fields from different rows in the same table. The problem is that I need to concatenate the...

In Access 2007 I am trying to create a Make Table Query. I have three tables that I want to extract data from, they have a relationship based on the Logon....

Hi, I'm creating a query from the code, and then i execute this query from the code, but I'm only getting 593 records out of 14,000 records. Yet , if I go...

Good morning, guru o' access. I am dealing with two issues I hope you may be able to clarify for me. My tables which pertain are Products, Techs, and Jobs....

Hi Im trying to run a query and I want to filter on field that has a yes/no date entry (in my table its in the form of a checkbox). Im sure this should be...

Hi Guys, I need a query in my front end to retrieve the names of the tables in the back end. The two databases are in the same pc right now but will connect...

I would appreciate any help with the following. I have identified duplicate rows per address field. Now I need to create a query that will flag in a field...