I am trying to work out how I can take a table of data that lists AddressID, LetterNumber & LetterDate in that form to this way AddressID Letter1 Letter1Date...

I think I must be doing something wrong. I'm trying to get an average of 5 fields in a query using the following: Total Average Age: Avg(++++) The result...

Access 2003'de rakamlar nasıl yazıyaçevrilir bunla ilgili herhangi bir modül gönderirseniz sevinirim. Ayrıca burda hiç türkçe soru ve cevap yok...

I have 2 tables - partial order and backorder file1. I want to remove all order numbers on the partial order table from the backorder file1 table. I looked...

Questions on an access data base: I have two tables in a data base Employee daily ins/outs (time clock) Employee master file I am considering have different...

I have a current query and the user is requesting an update by adding only Event.Status that are "Open", only for the StartCount records. I can't seem to...

I have a question about UNION's. If you have a SQL Union Query and you want to UNION it with another SQL Union Query how would you do this? Is there a...

Hi everyone. i'm racking my noodles on this one and am in need of an idea. i ddeveloped an app which does sales, inventory etc. it also tracks customer...

Does anyone know the maximum length allowed for a passthrough query in Access 2007? So far, I have found a query length of 76,944 fails, but length 52,537...

Hi, I have a 'standard' range of queries that create the outputs from an analysis database in Access 2003 (running in 2000 mode), and would like to 'tailor'...

Please help I'm absolutely stuck on this one, and I need assistance pretty badly. I'm issuing a query whereby my order source field has 3 possible values,...

Hi... I'm trying to update several fields in several records in a table. I use a form for user input. Here's the code that I use. Private Sub...

I have a calculated field that calculates a date. It does not seem to retain the date property. It sorts as text rather than a date – I have been able to...

I think it is Access 'feature'. Design table can't show every SQL-expression. Anybody know exactly? Humble elementary problem: Microsoft knowledgebase...

How to calculate the age of the persons of a group for a precise day? Example: what age do each one will have on July 1st 2008? Thank you

I am trying to find a querry that will exclude a line of data if the UnderlyingSymbol is in the list and the TradeType is Pip. I tried this but to no...

I'm trying to add to my query the percentage of New Business Issued with a Downpayment. In my query I'm counting the "RecordID" to count All New Business...

I have a situation with a number of corrupted mdb files when they are opened on a machine running Vista. If I also try and compact/repair I get a message...

Hello. I'm creating a database for a website and I need a query that Identifies how many records and that gives them numbers. In my site I have 5 columns....

Hello all I have a 2 tables that contains the fields Table1 EmployeID EmployeeName Table2 EmployeeID AbsenceStartDate