I have a table with company information, where the uniqe key is organisation number, which i have normalised on company code. In that new table on company...

Hi all, I have Access 2003 on WinXP. I have a table with: PartID TransactionID (runs in incremental order by 1) DateOfSales TotalCost NumOfUnit UnitPrice...

Hi, I have several tables in my database.. Products, Customer, Items, Supplier. The Items is a kind of transaction table that stores every product...

I write a lot of Crystal reports but needed an actual dbase to consolidate some data. I now have a database that I'm using to calculate sales commisions. I...

Is there a way to set global variables in an Access database and use those variables in queries, without having thoes variables reside in a table or query...

i am not sure if this is the proper Group but i will post it here, i want to calculate from a table the geomean of some values, the table has a primary key id,...

Has anyone sent email to contacts in a table in Access without using a third party add-on?

I have a Query created with the Access Query designer. What I am trying to do is the following: I have a table of 'leads', consisting of information including...

I am using MS Office 2007. I have a query using Now() for the date/time. When I generate the run-time version on my machine, it worked fine. However, when...

I have created a query with the criterion based on checkbox control input. This is input by the user in an input box to return results dependant on whether the...

Using Access 2000, I am trying to find a good way to sort a secondary column in a table before an autonumber is assigned for each record. We have a db into...

i wish to update a table, but only with information that meets my criteria. I wish to compare if a separate feild is within the limits, then update with...

i wish to update a table, but only with information that meets my criteria. I wish to compare if a separate feild is within the limits, then update with...

Can one use alter and update in the same query?

I tried to use a control as a criteria of a Select command in a Combo Box but the returned value d'ont atualizes after the second query. Therefore a tried to...

I am trying to set up a query that will find things like ID code V48.3. However, I find that I can not enter the period of the 48.3 in the perameter text. ...

Hi, I have a custom menu bar that is in use for an A2003 application that I want to make ready for 2007. One thing that I do in 2003 with the custom menu...

Hi, Is it possible to use a calculated fied in an update query? For example, this scenario: 1. create a calculated field that counts something...

Is it possible to define the jolly character '*' (star) as a query field's criteria at run time? How?

I have a Trips form and a Visit sub form, the Visit sub form has a sub form called “Trips� in the trips form. In the Sub Sub Form “Visits� I want to...