Adding a date and a text value... (1 Viewer)

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.
 

Users who are viewing this thread

Top Bottom