Hi all I am a real newbie to Access (I don't even know how to insert a calculated date into a record during an action query) and John Spencer gave me a lot...

I need to query information from two different tables but am not sure how to link these tables. The fieldnames are the same but the records are different. ...

Hi, i have a problem that i think someone will be able to help me with, i have a log file showing my router connectivity. the fields are Date, Time, cct...

I have set up a databse that other users will use and search. Apart from being able to search I would like users to view the datasheet of a specific form,...

Hi. I've got a table with about 10 columns. Im running the first query: 1) SELECT Id, Supplier FROM tableA WHERE condition and the second one: 2) SELECT...

XP Pro, 2003 I am trying to develop a program for managing petty cash. I have a table with Deposit and Payment fields. I use a form based on the table to...

I'm looking to add a queries that would let me know when a arrival time was "late or "on time" Any help on the would be appreciated

Hi I want to know how to run a report from a very basic table. My table is ie: A B C D E across the top and 1 2 3 4 5 down the side and then in all the...

Could anyone direct me to a source for this problem? I have two tables where 1 one field must be compared with 1 field in the other table. One table is the set...

I use an access query as the sorce for a mail merge in a publisher item. The query, as viewed from access, shows less records than when the merge takes place...

I thought I had this query finished, but apparently it's not working as I had hoped... I have two tables and one form. "Contacts" and "Calls" are the tables...

Hi. Please help me What can I write as a Criterie in my query so that I will get all the records with empty date-fields? Kim P.

Hello. I need help to breakup a mailing address. I'm hoping to use Left( or Right( in a query. Here are two examples: 1022 TURN CIRCLE SE #180...

I have a table that has two columns that are unique fields, item code and city. I want to run a duplicate query for any duplicates of item and city. When I...

Hello, I have a string in a field named "Samp_Date" that is like this: 20021002. I am going to run a make table query, and want to have it so All of the...

I get a data source regularly that I pull into Access as a temporary table then manipulate. This table has multiple rows for each item on a order but in truth...

I'm working in access and I have a table which has sequence numbers and text associated with these sequence numbers. I would like to take the text for these...

I am attempting to display the results of a query in a datasheet view to my user, but in a "spreadsheet" method...The view I am looking for is exactly like a...

I am using Access 2003. In my program, I base my reports on date ranges. Currenlty, I am using a form with two "unbound" text boxes that are "Date_From"...

Are you interested to join our business? The details are available at our site www.myvideosystem.com/90547 & our blog www.mvtwealth.blogspot.com Pl. confirm as...