The following query is supposed to calcualte a date, which it actually does. Most of the calculations work. There are a few cells that have no answer...

Hello, I have a link to a vfp database table. I also have a local table with some of the items that exist in the vfp table. When I run a query with an...

I've discovered a serious problem in my application. My app uses an MS Access ('97) format database to process some data for reports. I have a lot of queries...

I have a program with a form with a combo box whose source is a query. The user selects part # from the box. A command button opens another form that finds...

A form-driven query currently generates a report in USD, I've been asked to create a similar report using local currency. (access 03; created by...

Hi guys, I have the following query: SELECT Orders.OrderNumber, Orders., Orders., Order_Details., Order_Details., Order_Details.Description,...

I am baffled by this problem. When I execute an append query in vba by the db.execute strSQL, dbfailonerror command I am only getting 76 out of the expected...

Hi All, Here’s my situation using Access 2003. I have a linked table to a VFP data source (using ODBC for VFP). I have a query that trims the fields so I...

It has come to my attention that sometimes, when I open a Query in SQL View, the SQL that I see is not exactly the same as the SQL in the Query's Querydef. The...

I have a form based on a query which when the employeeID is entered, the forename and surname are displayed. However, I have had to make some changes which...

My boss has been asking me about whether we can incorporate a popup calendar that will note the computer user when certain dates within access tables are...

I am trying to put an IF statement in my query. I need raw scores to be adjusted to be between 0 and 1 if they aren't already. Here's what I want it to do...

I'd like to incorporate this SQL statement into my main query as a subquery:Here's the statement. (Select Avg(Average) fromQAVERAGE).With this statement i'd...

I have a table of data for which each record has a date and an amount of lost time. I am trying to group the total lost time into each week for a each year....

With a sample input of: Date Begin_Balance Sales EndBalance 9/1/04 100 20 ...

Hi, can someone please put me out of my misery. This is driving me nuts. I have a database based on a newsagent shop where I have set up a query that has...

I have a standard, unbound form. It has around 30 fields of various types. I created a simple Select Query. "SELECT Forms!frmWorkOrders!txtWO_ID AS WO_ID,...

Can I use a specific field in a table to display data in a combo box that is on a form? My issue is that I am trying to create a combo box from a table that...

Hi, I'm linking 3 tables.. when I run the query, the info for patient visit id, ticket number, Date of Service, Description, vbalance, logged date, and...

Hello, I am using MS-Access 2003. I updated my forms and tables, with new information. I ran a query, to find out what user was missing a chair. The database...