I have a number of check boxes in a query, I would like to dynamically alter which check box will be displayed by using a combo box in a form. I am having a...

I have a table in which I would like to combine two fields. The fields are LastName and FirstName. I would like to create a new field called FullName that...

I have a frminvoicepaymentssubform with the following controls: MaxPaymentDate =DLookUp("paymentdate","tblinvoicepayments","=" & & "And =" & ) MaxPaymentID...

I have a table called Contacts. I have another table called Insurance. I want to show in a query which Contacts have a particular insurance. If I query the...

Good day, First, here is a list of tables, PKs and associated forms TblMuseum, MuseumID, frmMuseum TblArtifact, ArtifactID, sfrmArtifact TblSwipeDetails,...

I ask this question earlier and I didnt make myself clear. Hope you can understant me this time. 2 with this expression i am trying to count the number of...

I have a query that looks like below and I want to add a new column that combines the projectID and another new column that numbers each entry incrementally by...

I have several fields in my query. i am trying to write this formula (2) / (total of the xFin column). Ill try and explain this the best I can. nMLO2 as a...

Hi to all, I have an already query that uses SELECT ... UNION Statements to combine fields in tow different tables( infos about Imported and Exported boards)...

I have a table with a field "product_id". The table has a lot of records with the same "product_id", I would like to write a query that will delete all the...

Hi all, I couldn't find any documentation concerning this topic. I want to put a regular expression in an SQL query under Access. As for an example, under...

Hi, This would be a great help if it can be solved. I have 4500 applications for funding. Each application must meet max 6 conditions to receive...

Hi there, Here's one that's bugging me, I'm developing a quotes system and I have a table containing job quotes that can contain more than one record (version...

Hi Group, I have downloded Duane Hookom's excellent sample database for Concatenating. My problem is that it is set up to run with primary keys that are...

I have a few pass-through queries which execute SQL Server stored proc. After I run these queries, Access slows down and become unresponsive - the only way to...

Hi, I have just taken over support and development of an Access 2000 database with data held in SQL Server, there are several queries that use linked tables...

Hi, I have a field called Booking in Date and I need to subtract that from 1/25/05 to get a new field called Days in Jail. I am not sure how to go about this....

Good afternoon. I've written several INSERT ... SET format queries for my Access FE/MySQL BE, but Access will not let them through. It reports "syntax...

I have a report that run a query which a user enters a date on a dialog box and the report runs, which works fine. Here is the twist. The use want to run the...

Dear Sir / Madam I'm Viveck from India. I'm using office 2003 in MS Access i've got an Error, the message is Overflow Please give me the quick reply. Thank...