Search results

I have a database with fields for dates but formatted in "text" so as to allow for partial input of a date. (ie. 12/00/1990 or 00/00/2001) I now need to extract data prior to an exact date and after an exact date. Due to the text format, I am assuming, I cannot create a query to do this. I have...

I am trying to create a report from 5 tables. 3 of those tables will have data initially entered with the other 2 tables (checklists) will be entered at a later time. I created 2 different queries 1 from the 3 tables with data and then the other from the 2 checklists. My main report is from the...

I have 5 tables for which I am trying to create one data entry form. Table 1 (client info) is set up with ClientID as primary key with relationship one-to-many with tables 2 & 3. Tables 2 (rental info) & 3 (invoice info) are related thru ContractID as primary key one-to-one but also have a...

Hi all ... been awhile since I have had to create a database so I have gotten a little rusty. :eek: I have a form where some of the fields I have formulated to calculate an amount. Example... =[GrossAmt]*[FeePercent] This is calculating into the form correctly but not writing to my table...