My query is based on 2 tables (pounds & Hours). Both tables use autonumber as a PK. Both tables share 5 similar fields:(Year, Month, Week, Location,...

I have a database set up to do quality reviews on files There are a number of questions with Yes, No, N/A as the possible outcome to each question. Each...

hi i have created a query but for some reason no matter what i name it even "query 1" access seems to bring up an error message saying " query1 is not a...

Hi All, I'm trying to create an update query using two databases in sql code. Now I have an access query named LIJST: SELECT * FROM Archief IN...

Any suggestions no how to programmatically examine a QueryDef to discover where a Field came from? Candidate properties: Name, SourceTable, and...

Dear all, I need the help on below; Colunm1 0.9 0.89 0.87 I need to show my results as 0.69687 (0.9*0.89*0.87) in query.

How can I create Primary Key autonumber field by SQL Command? For existing data start from 1 and end at the end of rows Example: Field Name : Id Auto Number...

Using the statement below, the criteria for Cust_Id1 field yields "00001" records as well as other records not = to 00001. This is a text field. I would...

I have a query in which there is a date field and a field for a dollar amount. I want to have a calculated field in which the dollar amount for the date...

Good afternoon.I am a newbie to Access but very familiar with Excel. Here is the setup: 3 tables linked to Oracle database 1 query using the 3...

Hi everybody - I started a database with data that I collected last year. It was all going fine, until I started entering older (2006) data. Now, when I run...

I've imported data from an excel ss that looks like this: Org A 5 Z 7 M 1 K Org B 5 ...

Reports are simple in design view but queries are what I am interested in. I have not found a way to alter the header information in a query other than to turn...

I am working on yield, I have 2 qureys one for good and the other to sort the bad in to catagorys. I want to add the total good and total bad for total...

Hi, Hopefully you can help with this. I've done the query below to show records in our call logging system where a case has been completed by Month. This...

Hey all, I am trying to write a function for a Module. Here is my code: Public Function fncModelNo(OptionKey As Variant) Dim ModelNo As Variant ...

I have a query that currently runs using built in date parameters. I want to change this to run from a form, but every time I try to run the query this way...

I need to use an If statement in a field in my query, here's what I need it to do: If field name "PYE" equals "12/31" then insert "1/1" or If field name...

I have excell spreadsheet for various credit cards (table a, b & c), and checking account (table d), and want to join automatically so I can run reports and...

I have been trying to set the criteria for a Yes/No field so that the user can choose to see True, False, or both. The "both" part has me stumped. I have...