I have an Access table that has a field named "DateSubmitted".. The default value of this field is Now() which will insert the date / time when a new record is...

I have a table that has 5 fields: ID, AutoNumber Ticket, Number Techs, Number Start, Date/Time Stop, Date/Time I built 3 seperate queries that output the...

I have a database where I have people listed with two other columns of data that goes with the name. The names are listed multiple times. I was wondering...

We have dates that are in this format: 20080513 This is the date for 5/13/2008 If I import data from a text file that has this format, how can I convert it...

Hello All, I was hoping to do this without to much difficulty but not having much luck. I got the round down to the nearest 15 minutes. NOW I would like to...

running access 2k; I have 2 queries - BOTH should work as far as I can see, and NEITHER does; each reporting "could not delete from specified...

Ted, I really appreciate your help on this. The Inception table is used to specify the inception date and the starting point for 100 in the IDTotRet field for...

Can anyone help please? Report Gross Grand Total and Sales tax Total are off by a penny or 2 The amounts are being generated by the sum expression below...

Dreamweaver8, Windows XP Pro (SP2), Homesite and msAccess (2000) Hi Anyone know of a good/quick (and free) way to compress HTML code? We are trying to use...

I need some help please. I want to build a query based on a form with two combo boxes for Month 1 and Month 2 and then have a report that has two columns...

Have read at least 100 posts re #name errors and still can't figure out what's wrong with mine. I have a master form (and table, both called "Client") that has...

I need help on running balance for my banking DB. I have a Table (Transactions) where I store all account transactions, with the fields: TransID...

I have a table with Accounts, let's call it Account. It has the following fields: AccountID AccountName ParentAccountID Data in the table: AccountID ...

Hi, I have two date/time fields: StartTime and LastActivity. In the History table, there are Location and LastActivity fields. I want to run a query which...

I am trying to export a query to a .txt file. I can't get the number field to right align. Any help would be appreciated.

I have a Receipts Allocation table in which the payment received for invoices are recorded by INVOICEID number. When the final payment for an invoice...

This is what the Query code is and What is between the stars ** is what I would like added to it......Thanks Bob SELECT tblHorseInfo.HorseID,...

I need to assign a customer code for 5000 records. The customer code would be as follows: The number 2 followed by the first 3 letters of the business name,...

I am writing a subquery using the all statement and it seems to be giving a problem. SELECT EID, Salary, Department FROM tblAccounts WHERE Salary ...

I have a query based on two joined tables and need to know how to insert SQL into existing sQL so my query counts "Assigned Consultant" Properly. if the...