I have 2 tables(Status and Deficiency Tracking) that are related by StatusID. Purpose of these tables are to track deficiency status until it is corrected or...

I'm not sure I'm posting this in the right spot, but here goes...I would like to design something to remind users to run a certain report every thirty days. ...

Hello, I was wondering if someone could help me with my query. I am creating a db to track keys and employee info for our school. I am trying to create a...

Hello folks! I've got a problem. I guess it's why we always come in here when that's the case :) I have three tables as follows: SIR (PK : id) SIR_D (PK :...

Hello, I posted (creating relationships with time series) yesterday within "access Database Design". Basically I have 24 tables that are linked to txt files...

Not positive if what i want to do is even possible or if it is in what way to do it. Okay i have a table with tons of information of fixtures including...

The quick background: The ultimate result of this project is a report with information from several different sources. Some information has to do with the...

Hi - I've been trying to set criteria in a query to return certain records from two different fields. When I set the criteria for both fields, only the first...

I use the following code to display multiple fields in one field successfully. Expr2: +", " & +", " & Results: Susan Wu, John Ni, Echo Peng, Chen...

Acct # Amt Due 123456 15 123456 20 445544 11 445544 6 789888 5 099999 4 I want to run a query that finds the total sum...

No error when compiling but when open form, got 'type mismatch'. Here is the code: Private Sub Form_Load() If DLookup("", "users", "Trim() = '" &...

I want to run a query so it will give me all data from the last 5 years from today's date without having to specify the actual dates. Is there a way to do...

My query returns: OpenDate, CloseDate, DaysOpen with iif(NZ(T.CloseDate,"")="",Now() - T.OpenDate,T.CloseDate - T.OpenDate) AS DaysOpen It seems to work when...

I have my records sum and group by date in week number. But I can't get the week number in the right order. It currently output as...

I have a local table into which I need to append data I retreive from our AS/400. I initially developed both the local and pass thru queries which work just...

Hello, In my database i have an invoice amount that the field properties is set to double standard and auto in the invoice table.It is not needed to be in...

How is the primary key established when a make table query is used?

Hello, In my query results I want to show only 5% of the results. I know about the TopValue which will show only the top percentage of the query...

For reasons too obscure to describe, I very much like to segregate my overall database into several .mdb files. The main file contains queries and joins, the...

I am passing date values from text boxes on forms into query criteria. The field name in the query is: "Critical Date: CDate(DateAdd("d",-, ))". is a date and...