musclecarlover07
Registered User.
- Local time
- Today, 05:54
- Joined
- May 4, 2012
- Messages
- 236
Ok ill break down the whole database. We pull three different reports into excel. Then we will take the three reports an import them in to the database.
Table:TSP_Data
Table:Customer_Data
Table:Storage_Data
For testing purposes i left the tables the same name as the excel spreadsheets.
I have a query that will pull info from each table for the main form.
Query:Customer_Data Query
Within this query I have 3 Expr
Expr: DateAdd("d",[STRG Start Date],[Storage Days Qty])
Expr1: DateDiff("d",[Expr2],[Expr])
Expr2: Date()
I then need to be able to sort everything based on Expr1. This is how we priortize the information. I tried to create a query an use Expr1 as a field. It pulls the data like its suppose to put I need for 1 query to show only values 30-45. When I put the following into the Criteria "Between 30 And 45" then click Run or click the datasheet view it gives me an Error, "Data type mismatch in criteria expression"
I need for a list box to pull the query that displays 30-45 values an then when you click in the list box it jumps to the record. I have everything working except the query. It keeps giving that error. Also if I try to sort the Expr1 Column by Ascending or Descending it gives the same mismatch error. If I can get this to work then I can get the database up an running.
Table:TSP_Data
Table:Customer_Data
Table:Storage_Data
For testing purposes i left the tables the same name as the excel spreadsheets.
I have a query that will pull info from each table for the main form.
Query:Customer_Data Query
Within this query I have 3 Expr
Expr: DateAdd("d",[STRG Start Date],[Storage Days Qty])
Expr1: DateDiff("d",[Expr2],[Expr])
Expr2: Date()
I then need to be able to sort everything based on Expr1. This is how we priortize the information. I tried to create a query an use Expr1 as a field. It pulls the data like its suppose to put I need for 1 query to show only values 30-45. When I put the following into the Criteria "Between 30 And 45" then click Run or click the datasheet view it gives me an Error, "Data type mismatch in criteria expression"
I need for a list box to pull the query that displays 30-45 values an then when you click in the list box it jumps to the record. I have everything working except the query. It keeps giving that error. Also if I try to sort the Expr1 Column by Ascending or Descending it gives the same mismatch error. If I can get this to work then I can get the database up an running.