I want to limit the number of records showing for individuals with multiple Addresses. Following is my table structure. tblARTISTS tblADDRESS_TYPE ...

Hi I have a field that can have either A, B or C as its value. I need to write a query that will return the number of A's, B's & C's in the field X for...

Hi I have defined global constants in a module. How can I access these constants in a query? Thanks Regards

i have a one-to-many relationship between 2 tables. i am needing to develop a query that will SUM all the records of one field on the 'many' side of...

I have two tables with a one-to-many relationship, and i need to SUM all the records of one field that link to each 'one' side for each record on the 'one'...

Hi I have a database, which at the moment I export into excel to achieve my goal. I have a table of email addresses under the field heading "Email", from which...

Hi When I run my query from a command button, the query shows the result in the query window. I do not want this to happen and would like the result shown in...

Hi How can I ensure that date is always assigned in dd/mm/yyyy format to a date filed, in an update query? Thanks Regards

Hi I have a list which the user can multi-select. My question is, how do I take the selected list items across to a report as data source? Thanks Regards

Hi I need to assign sequential invoice numbers to orders starting from the last highest number + 1. I have tried the following code; UPDATE Orders SET...

I have problem with a query not returning all matching records. **** Design of Db****** I have three tables and three forms (Audits, Findings and Notes). ...

The following is my table: EmpId AutoNumber FirstName LastName DeptId Salary This is my query to find the hignest salary in each dept. My question is how can...

I am trying to get some data from two tables. Tbl_Dates has multiple values in the WatchOffGroup field. I know that this is not a best practice - but I have...

I am getting an error message when trying to create a SQL pass-through query and a value has a " ' " in it. For example: Select * from Northwind where...

HI, How do I count the number of records returned in a query and then display the count on a form textbox? Regards John

Hi, How can i view only the highest record ID or most recent date in my query. There are many entries but I need only to print the latest history of...

Hello, My problem is that i have a database with fields linked to each other (some more than once). But in a particular query i have created showing all...

Hi How can I replace all characters except a-b,A-B,0-9 and hyphen from a field in a table? Thanks Regards

Hi How can I select records that have non-alphanumeric characters in a field using a select query? Thanks Regards

Hi, I am a little new to Access, so bear with me. I am trying to write a query in which I pull data from two tables, but each is sourced from a different...