We have a table that has one field that is used to identify if that record has been printed. Currently, we have a query that identifies all records that...

hi.. I want to ask how to calculate day from date. For example 21/05/08 - 21/06/08, how many days between these dates and how to calculate days from these...

I am not sure if this is even possible, or necessary. With one button click, I would like to update and append to several different tables with data...

Can we create graphs from the data tables

Hi- I would like to be able to go to a record in a report from the record in the table. For example, if we are talking about a specific record, I would like...

Is it possible to use one of the Date Functions in a query grid to group my employee attendance records by the Week of the Month? There is a record if they...

I have two tables INFO1 and INFO which have same structure and how can campare the data of a particular field in INFO1 with same field in INFO

In the qbe window, I would like to chose to select groups of records, For example, in the FORM LETTER field, I want to select groups of records of either...

I'm evaluating the possibility of upgrading to Access 2007, but have run into a problem. A type of query (involving joins between linked ODBC tables) that...

A previous employee set up a tool that takes all of our Ops Plans and combines them all into (what becomes) an Excel sheet called ALL. She is unable to...

Hello, I have a 3-table query that gathers it's criteria from a Criteria Selection Form (This works fine). After I get the results from this query, I...

This is a repost, unfortunately I posed this question about an hour ago and it still wasn't listed, so here it goes again. I am trying to do this in a QBE...

I'm trying to find a way to summarize some data. One of the summary items I want to show is the last time an event occured. The data is a list of scan data...

I have a table w/ many fields incl. an employee's name & his manager. As an employee, the manager will have his own record which includes HIS manager. I...

I have a field which is formated as field type - number , but it is a combo box where the value list is like this...

Hi, I want to compare two dates. I have a date field from a table and I want to compare it with another date (say DateB). The problem is that DateB's day and...

Hi, I am working on a fairly complex database where parent records contain numerous sub-records (which includes a number of actions and each action has a...

When I use the Like statement in a crosstab query criteria, I am getting a jet database engine error message but cannot find anything in the help files that...

In my query I hvae created a field that is not part of my table to calculate the number of days between two dates. I have set up a sort, but it sorts the...

The following statement creates the following Run-Time Error: Run-Time Error 3075: Syntax error (missing operator) in query expression 'PropertyID=2...