Adding Subreport moves main report grand total

Adding Subreport moves main report grand total

Hello there. My job is in the prehistoric district, where we run Access 2007. I am trying to add a subreport to my main report, which works for the most part. However, I have one issue dealing with the main

Posted on

Form’s Date Value not able to bring it over to VBA

I have a query, called “RosterQC” that filters results based on the text object “Text35” in the Form “Quality”:

SELECT Record No FROM TableX WHERE Date = [Forms]![Quality]![Text35]

Running the query itself is fine, but when I try to run

Posted on

Searchbox that that searchs multiple columns?

This is my first post here I hope I’m well understood.

I’m currently building a database with two tables(hopefully will expand more) one table for contacts info and one for evaluation. I have a data entry form and an evaluation

Posted on

Trying to get Median value for a dataset in Access

This is my first post so hopefully I don’t mess anything up.

I’m using Microsoft Access to build a database of chemicals occurring in several different environmental sample types (water, sediment, fish species, etc). I ran a query that required

Posted on

Question about linking Customer names to Orders tables

So i have a Customers Table where each customer has a unique Primary Key number. I also have a Orders Table where i have to enter in the Customers name, but i have to choose a Primary Key number instead.

Posted on

Storing a database online

I’m trying to help some old work colleagues with their database, I really don’t understand much so please bear with me.

The database is, it was made by somehow who is no longer with the company, I did my best

Posted on