Search results

We import data from an external program into this DB. The external program does not have a place for DOB, so we use the email field. The problem is, on certain records, we use the email field for the email (go figure right...) I do not need any email addresses in the DB. Only the DOB My...

I have a database that is used every day. I want a query that will list which days are not in the database. We have to delete the raw data and re-import the corrected / verified data. We do make mistakes, so I want a query that will help us ensure all dates are present. Example. 1/1/12...

I need some help. I created an append query in which data from the web is downloaded and is appended into an existing table. Easy enough. Here is my delima. My PO Number is set up to use our fleet number of the van and the date of order. Example 18081512 would reflect van 15 and the order...

I have several records that have "(stringofinfo)" at the end of the first name. So example: Smith, John (stringofinfo). I need to figure out a way to remove the "(stringofinfo)" so it just reads Smith, John. I really need to use a query to do this as I would really like to do this during the...

I have a database of customers that have trips at specific times. I have a report that sorts the times. The problem I am having is that I need space between the trips according to 30 min blocks of time. Example. Jane Smith is being picked up at 9:30am. Then the drivers next trip is at 1pm...