Search results for query: *

I think you are missing one of the main features of the RAD and the software for it. It can be used to connect directly with a serial cable and it gives you a GUI for the programming. I am not talking about the template of the phone. Use the Browser tool. You will have to reset the RAD...

I have problem. I need to enter into a database data collected on paper forms and at the end of the month I need to export that data to a fixed field length file and forward it to a state agency. The problem is that there are over 290 fields of information totaling over 400 characters of...

I am doing a subtraction of times on a make table query. I am pulling the data from an linked sql db that I cannot modify. Some of the dates and times are stored in a text format and as seperate fields, so I am converting them into DateTime fields when I do the make table query. I also need...

I think I have made a goof in the data I collected to send. The problem with all of this is that the data is coming from linked tables in a large sql database. I was trying to pull everything I needed through a query and do the reports I need, but I ran into more issues than I had planned for...

Ok, here goes The table associated with this case has 60-70 fields in it, but I am only concerned with 6 of them. The fields are tdate, vehicle, status, priority time_1 and time_2. All the queries are for the same range of dates and I have no problem with that. vehicle is a text field...

will do. Thanks

I do not need to get data from multiple tables. Just from one table. But I need 4 different queries to get the data I need, and Access tells me I cannot use 4 different queries in a report if they are all from the same table. It will not let me even use two tables if they are on the same...

All very true. As a beginner my self I am forced to go the simple approach first. Dave

I have a case where I need to produce a report that contains several different results from the same table. I have 4 queries, each one giving me the results I need, but Access tells me that it cannot connect to more than one query that is from the same table. I need all of the results in the...

If you base the report on a query, then you can design in a prompt to request the user provide the start and stop dates of the report. For example if the field containing the date was "xdate" then in the criteria area of the "xdate" column you would enter something like this "=[Enter Date for...

That worked great. Thanks Dave

I'll give it a try. Thanks Dave

They are in two fields in the schedule table. employee1 and employee2. the record might look like this 2007-01-15 08:00:00 17:00:00 323 224 Where the fields are... SchedDate, BeginTime, EndTime, Employee1, Employee2 Dave

I reversed them by mistake when I re-typed them on the post..... you are correct though. I did state it correctly in an earlier post. I do have aother question though. In the same project I have another issue. I have a table that is the schedule for a given day of two employees that are on a...

I did not think it important since I alread had converted the data in the query for a report. My Bad... To answer you other question, the two fields they are using look like the examples below. 2007-01-16 and for the time 14:44:30 The date field is text type field with a length of 10 and the...

Skip, I realize that, but the table I am linked to is storing the date as a text field, not as a date field. Why, I do not know. Instead of using a Date/Time field, they use a text field for the date and another one for the time. Each record has several times recorded, and for each one they...

Jerry, Thanks for the reply. I did get the format to display correctly on the query, and on an associated report, by changeing the format in which my PC displayed the time. I cannot change the format in the table though. It is a linked table that is used by our main software application...

I have a project where I need to convert a time into military time. I cannot use the Short Time format, as I need to display hour, minutes, an seconds. I have searched here and other places on the web. Thanks in advance Dave

I have made the conversion work with "DateValue" on my Make Table Query. I am now having problems with the Update Query. I am getting a Reserved Error (-3002) and it states that there is no text associated with that error. Has anyone see this before. I googled it and could not find anything...

I think that should work, I will give it a try. How would I use the above to convert the data as it is pulled in through the query. What I started with was a make table query and then I use a append table query for additional data as needed. I started with a maketable query. I every few...