Hi all.. Here is what I have: I have a query that is running a search form. The query is made up of three tables: 1.tblMain 2.tblSpouse 3.tblChildren

What I would like to do is reference a text box controll that is on a form in a querry. What I have done is gone to the querry by example grid and...

Hi, I've imported an invoice from excel into an Access table, tblInvoice. The table has an ID number column. I need to figure out how to "copy down" the PO...

Tring to get total worked hours and total maintenance hours summary. I have a table with the clock hours WorkID WorkDate WorkEmployeeID WorkHours And have a...

I'm trying to filter records from a query. The query was created from 2 tables - both with the same userid field but one contains the first/last name fields...

I have 2 tbls, The first tabl (TblOblig) has one ObligID number for multilple Product ID #'s in tbl 2 (ProductTbl). I want to set up a query (UPDATE) when a...

I need help please with the following. I need to run an update query to check if table 1 phone field has a phone listed if it is the same as table 2 then...

Hello all. I am having a bit of trouble getting my query to work properly. I am trying to run a query (for my report) based on criteria entered on a form. I...

I am really new to access and VB so I really could use some help on this one. I have a simple database that keeps track of transations for a small group...

Hi, I am trying to run a query based off of an unbound field in a form. Essentially I would like the end user to input a date in the form and hit the command...

I am designing a database to track and calculate rocket flights. Flights table contains EngineType1, EngineType2, EngineType3, EngineQTY1, EngineQTY2,...

I guess this must be really simple, but I just cannot figure it out. I have a table which lists product images. The images are custom sorted with the help of...

Hey I got a query problem here and hope you all can help me. I doing a school project and non-sql user here therefore the solutions provided should be as...

i have a table which shows customers oustanding, out of 500 customer if 3 pays me half the payment the part payment is yet to be received how can i show that...

I'm stuck on this one. I have two tables - tblContacts and tblHistory. There is a one to many relationship (1 contact to many history records) linked on...

I would like to know how to do the following as easy as possible. Have a list of unique business phone numbers about 2000 + can be more. These phone...

I have two patient tables. One has patients with a certain condition, and the other has patients with a different codes. Some patients have both conditions...

Hi All, I need nelp with query i am using Access 2003 and VB 6.0, I have 2 table with fields like: TickNo Date Time Unit ID More fields ... 50001...

Happy Holidays everyone. I have a task to create a report from a data set. I think the quickest way is to query the data. fields: Date, Region (ie BC, AB,...

I need to look at a table like Number Created_Date Modified_Date Updated_Date and in a query I have to find the maximum of the date fields for...