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...

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...

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

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...

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...

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 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 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 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...

Need help i have a value list of Row source type: Value List Row source: -1;"Yes" 0;"No" "*";"Yes/no" everything is fine except for yes\no value

I want these all QuoteID not to appear in one of my report QuoteID is my Primary key and this my query. iif((iif(858 and 910) and iif(992 and...

Table fields = Name, Sire, Dam. I want to set up a query so that you enter the Name of the animal and the query picks up the rest of the pedigree using Sire...

I need to find out how to convert this: Susan Brown to SUSAN BROWN and also how to convert this: Susan Brown to

Hi: Can any one please help me in creating query. Criteria is that: If LstVldAccount="OtherAccount 1" then match tech_id.corp with Val(Left( .,5 If...

Hi: How to i union both queries. Both queries match record from tabl tech_id. This is the result which i need. First 2nd query run and match with...

I'm trying to build a query off of a table that basically sumarizes by week number instead of date. so in my query I have these fields tech number - shows...

Hi I have an email column in a table. How can I turn values in the column for all records into a single string with each email separated by a...

This is a calculation challenge for a non profit to calculate how many nights during a given month did people stay in there shelter. This is the challenge. ...

Hello, I have an Insert Query as follows: INSERT INTO web_MailingList ( SubscriberName, SubscriberEmail, SubscriberDate ) SELECT , , ; My question is, can I...

Hello, I have an Access database table, named web_MailingList, with 4 fields: SubscriberName, SubscriberEmail, SubscriberDate, SubscriberId SubscriberId is...