Hi all, I have 3 tables (and forms) - tblFee6, tblFee61 & tblFee62. They all have the same fields - MinAmount & Fee. Each Fee field in each form has to have...

I want to query the numbers column to show my records in numeric order. By default it shows the records without a number assigned, first. I want those records...

I don't know of any format that will do this I would try a calculated string field in a query that looks like Field: RightJusified: FORMAT( Int(,"000000000")...

Can someone please help me with the following code that now produces an error 6 overflow message : Function JoursOuvres(deb, fin) Dim db As Database Dim r As...

In my homework assignment, I am being asked to print the definition report for qryDistributors, page 124, Microsoft Office Access 2003.

Hi Lucy, I'd probably do Format(33.10 * 10E6, "000000000000000") On Thu, 26 Jan 2006 11:15:02 -0800, "Lucy" wrote: Hi,

I need to do count(Actions2="34")...is this possible? Here is the query: SELECT last, first, middle, count(IP.Actions1) AS total, count(IP.Actions2)+total...

Hi all I have a little problem i have a table with the following values12/17/2005 20:20 12/17/2005 20:20 12/17/2005 20:20 12/17/2005 20:20 12/17/2005...

Hello, I have a very frustrating problem. I have a form, with a "Run" button that runs a query. Very simple, nothing to it. Except that after I run...

i have a large table in which there is a numeric field "batch no" with input mask "00/00000" ie if i enter this no "0546766" it stores it as 546766...

Hi there, I need to run a .exe file to run some exported data through a programme before importing it back into Access. Where/how can I run the .exe file from...

Hello, I have a series of queries which tell me: Daily appointment totals Weekly appointment totals Monthly appointment totals. I need all of this...

I have OFFICEPRO 7.0 on another computer. I now have Windows XP with Office Basic 2003. I want to transfer several Access databases on my old machine. Do I...

I have a table with the following fields: Date MemberID Grouping Income Expenditure I am trying to create a query that that will show a running balance. i.e....

I'm showing Expr 1001 as a field in the field list for one of my forms and I have no idea why. Here is the sql: SELECT ReminderID, ReminderType, Reminder,...

Hello, I have a series of queries which tell me: Daily appointment totals Weekly appointment totals Monthly appointment totals. I need all of this...

Is it possible to run a query or report that runs formulas from data in a table/form and turns them into totaled numbers in that query or report? Query/Report...

Hi,I have a table containing 50.000 order lines divides between 2.000 customers. I need to find the three largest orders per customer. Can I do this by a...

I have a Count Query that I would like it to only look up the 3rd Item in the ID field. I would like to find all the 1D1 that are in the ID field. But the...

Ok, I have what I think is going to be next to impossible, but I thought I'd see what the brains around here might be able to come up with. Bare with me as I...